Daily Sum - Daily Average on bar chart (daily deviation from avg)

[roisolberg]

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

[Or · Accepted solution]

Something along the lines of:

Avg(total Aggr(Sum(Sales),EntryDate))

Should get you the daily average across all selections, I think.

[roisolberg]

Thank you @Or !!

Working perfectly