Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to show an average trendline on a column chart of weekly opened cases (I have a single dimension Open.WeekYr) . When I try to calculate the same value using the expression =avg(aggr(sum(#Cases),Open.WeekYr)) I get a different value.
Any ideas?
Hi, David
According to my understanding about Aggr function, you dont need it in one dimensional chart.
i think =sum(sale) and aggr(sum(sale)) will give you same result, if you have one dimension.
so in your scenario, you dont need aggr function, simply, avg(#Cases) will give you result.
kindly correct me if i am wrong...
Sorry for the confusion.
The aggr statement is in a separate text box.