Forum Discussion
Average Daily Spend
Hello All. I need to calculate the Average Daily Spend. Average Daily Spend = Total cost / Avg Days for the selected period. ex: If we select the period 1 to 25 then Average days should be 25. ...
It's possible but that's a pretty strange total to show. How do you interpret it? What does that sum of averages represent?
If it's possible then how achieve it.
You'd need to iterate over one level of granularity where you take the average below that level and sum up those averages. I can't tell what determines what level of granularity you want to change your aggregation rule at though.