Average Customer Order widget

Graph the average amount, in the domestic currency, for customer orders in the selected date range.

Filter: Select a customer number and a date range (today; 30, 60 or 90 days: 6 or 12 months). If the customer field is blank, all customers are included. However, if a filter is set in the Customer/Prospect Lookup widget, this widget is filtered to show only that customer.

Calculation: To get the average, total the amounts for all customer orders in the date range and then divide by the number of orders. Convert all amounts to the domestic currency.