Trend lines (average) for Charts

Jörn Constabel

Hi there,

 

I'm searching for a solution to add trendline in my charts.

For example: I have a chart which shows the Sales per week. Every week is shown in a bar.

Our Sales dept. is interested in have a trendline showing the average sales of the selected period (let’s say 4 month or 20 weeks) in the same chart.

 

Changing the the selected period has to lead to a new calculation of the average.

 

Any idea?

 

Regards,

Jörn

Björn Reuber

Hi,

 

there are different solutions

a) moving average (so first period shows first period, 2nd period shows average from first and second one):

using Average function of Analytics tab

Result

b) you can also use nexel to show allways the same average (has to been created within a DV and then hte layout needs to be copied to the Chart)

 

c) using Summary algorithm AVG and DownTotal Function [ dt(a)]:

I hope this might help you for finding the best fitting solution for your case

 

regards

Björn

Jörn Constabel

Thanks, Björn!

 

Regards,

Jörn

Previous Member

thanks Björn Reuber, for showing method c)

I used to think that the dt, rt, gt functions were just sums of the column, the row, the total. Now I understand that they basically take the value that is in the row total. Or in the column total. So they are extracting one specific cell value.

So dt can show asum, and also avg, max, min, count values or a calculated result. The latter, if the summary algorithm of the referenced block is "Calculated".