Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to show a dynamic daily deviation from the average
Every day there is a certain quantity entering production, I need to show that quantity less the avg quantity of the selected period.
for example i chose the past week, the week avg is 54
so in a bar chart for every day i should get that day sum of quantity less 54
if no time period was selected, it should show the sum of each day less the total avg.
when i try to do so in a bar chart i get all 0 (it calculates the sum and avg on every day)
Any ideas?
Thanks,
Roi
Something along the lines of:
Avg(total Aggr(Sum(Sales),EntryDate))
Should get you the daily average across all selections, I think.
Something along the lines of:
Avg(total Aggr(Sum(Sales),EntryDate))
Should get you the daily average across all selections, I think.
Thank you @Or !!
Working perfectly