Hi there, looking to find the average daily sales per product per customer. the data is at individual sale level and there can be multiple sales per day.
Obtaining the total daily sales per product per customer is working (sumOver part of the field) but I am running into an issue with the average.
When there are two or more sales during the day, the field is calculating that multiple times when computing the daily average
The result is the same with/without the minOver portion of the code, but that is what I am using to try and get one value per day included in the average calculation
I may have been a bit unclear in my question, but I am after the Average of total sales per day Per Product Per Customer rather than the Average of sales within the day.
For each day the calculated field would return the same value for each customer/product pair.
E.G. For Customer A/Prod A
total sales
17/9: 1+3+2+4 = 10
18/9: 2+1 = 3
19/9: 1+1 = 2
Average of total sales per day Per Product Per Customer
= (10+3+2) / 3
= 5
For all Prod A / Customer A rows, the calculated field would return 5