Average trendline

[DavidFoster1]

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?

[israrkhan]

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...

[DavidFoster1]

Sorry for the confusion.

The aggr statement is in a separate text box.