[nir@motekteam.com]

Hi

I am trying to figure out the average number of SKU's per order over a period of time, is this possible?

Thank you

Nir
This is a cached copy. Click here to see the original post.

[dominicb]

I use a saved search to do this.

Criteria:

Type: is Sales Order

Date: is within this month

Item: Type: is any of Assembly/Bill of Materials, Inventory Item, Kit/Package, Non-inventory Item

Results:

Document Number: Group

Name: Group

Line ID: Count

(Output: Show totals checked)

Divide the "Overall Total" number shown at the bottom of the result by the number of rows (ie "Total" shown top right) to get an average across the date range.

---

nir@motekteam.com replied on 02/19/2018, 10:37 AM: Hi

Thank you, but this gives the total number of items, I’m trying to find how many SKU’s are in an order (avg), so 10 of the same item on an order will count as 1.

Nir

[torin@aminian.com]

If you are trying to find number of unique SKU's per order you will just need to group by document number and count item internal ID. Also, make sure you add criteria: main line, shipping line, tax line and COGS line are all false.

If you are looking to get the average unique SKU's per order across all orders add ONLY the following to the results:

Formula(numeric)

Summary Type: Maximum

Function: Round to Hundredths

Formula: max(1)*count(distinct {item}||','||{internalid})/count(distinct {internalid})

---

torin@aminian.com replied on 03/09/2018, 05:01 PM: The above info should all go on one row on the results tab. So the field should be formula(numeric) and the rest of the info can be filled in to the right. This row will be your average # of unique SKU’s across all orders.

[nir@motekteam.com]

Here are the screenshots of my current criteria and results.

Thank you dominicb and torin@aminian

[Author]

Posts