Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I got Date and User count on a weekly basis:
requirement:
I need a new column where it shows average on a weekly basis
Advance Thanks,
Kumar
Hi,
use
rangeavg(above(sum(Count),0,7))
as expression
Regards
Hi, usually (one of the uses of) aggr is used when you want to use calculation that splits a row in many subcalculations, like if for each date you want to calculate the average by hour, hour is not on the table, but you want to calcualte each hour separatedly, do the average and show in the table by date.
To merge different rows in one you an use total to go outside the dimension value, and in this case you can also use above to go to the last 6 rows, and a Rangeavg to get the average of all different values, so maybe this can work:
RangeAvg(Above(TOTAL [YourCountExpression],0,6))
Thanks for your reply - That worked