Hi Brette Husar ,
What about using a materialized view? I would try something like below:
- Start by Searching sum of quantity monthly
- Save the Results as a view
- In Search change the data source to use the view
- Search Average of the view's new quantity column
The result should be the Average of the total of each month's quantity.
If that works for you make sure to go into the view under the data tab, click on Schema, and set the materialized view schedule so that the data updates everyday.
Let me know if this works for you?
Saving a Search as a View
Materialize a View