Creating an Average Items Per Order Search
You can create a saved search to obtain the average number of unique items per sales order. A maximum type summary result field with a formula calculates this amount.
Watch the following video for a tutorial on how to create a saved search that calculates the average number of items per order.
To create a saved search of average items per order:
-
Click Saved Searches > New to open a Saved Transaction Search page.
-
Enter a descriptive Search Title.
-
On the Criteria subtab in the Filter dropdown list:
-
Select Type, choose Sales Order in the popup, and click Set.
-
Select Main Line, choose No in the popup, and click Set.
-
Select Shipping Line, choose No in the popup, and click Set.
-
-
On the Results subtab's Columns subtab:
-
Select Formula (Numeric).
-
Select a Summary Type of Maximum.
-
Select a Function of Round to Hundredths.
-
Enter a Formula as follows:
max(1)*count(distinct {item}||','||{internalid})/count(distinct {internalid})
-
(Optional) Enter a custom label for the formula.
-
-
To enable use of the saved search as a custom KPI, click the Available Filters subtab and select a Date field from the Filter dropdown list.
This filter lets you compare search results for different date ranges, display them as KPIs, and even illustrate them in trend graphs.
If you want to include a dropdown list date selector on results pages, check the Show in Filter Region box.
-
Enter any other search definitions that you want to include.
-
Save the search.