https://community.qlik.com/t5/App-Development/Average-trend-line-calculation/m-p/1790405#M61758 <P>Greetings, Qlik Aces!</P><P>&nbsp;</P><P>I'm creating line chart to analyse values by month compared to previous year. Using trend line to see average value. So, the problem - when analysing current year, the average trend line is calculated by dividing summ of, for example, first two month / 12, no divided by two.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rolands_0-1615454542961.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/50930i2520D17B03C30370/image-size/large?v=v2&amp;px=999" role="button" title="Rolands_0-1615454542961.png" alt="Rolands_0-1615454542961.png" /></span></P><P>In my opinion the average trend line should be calculated based on month with value, not on total month count.</P><P>&nbsp;</P><P>Any ideas how to solve this?&nbsp;</P><P>&nbsp;</P><P>Thank you.</P> Sat, 16 Nov 2024 00:27:19 GMT Rolands 2024-11-16T00:27:19Z https://community.qlik.com/t5/App-Development/Average-trend-line-calculation/m-p/1790405#M61758 <P>Greetings, Qlik Aces!</P><P>&nbsp;</P><P>I'm creating line chart to analyse values by month compared to previous year. Using trend line to see average value. So, the problem - when analysing current year, the average trend line is calculated by dividing summ of, for example, first two month / 12, no divided by two.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rolands_0-1615454542961.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/50930i2520D17B03C30370/image-size/large?v=v2&amp;px=999" role="button" title="Rolands_0-1615454542961.png" alt="Rolands_0-1615454542961.png" /></span></P><P>In my opinion the average trend line should be calculated based on month with value, not on total month count.</P><P>&nbsp;</P><P>Any ideas how to solve this?&nbsp;</P><P>&nbsp;</P><P>Thank you.</P> Sat, 16 Nov 2024 00:27:19 GMT https://community.qlik.com/t5/App-Development/Average-trend-line-calculation/m-p/1790405#M61758 Rolands 2024-11-16T00:27:19Z https://community.qlik.com/t5/App-Development/Average-trend-line-calculation/m-p/1790484#M61769 <P>Have you tried calculating the average manually?</P><P>sum(Value)/count({$&lt;Month={"=sum(Value)&gt;0"}&gt;} Month)</P><P>You would need to add whatever set analysis you are using to limit the time frame.</P> Thu, 11 Mar 2021 12:14:38 GMT https://community.qlik.com/t5/App-Development/Average-trend-line-calculation/m-p/1790484#M61769 GaryGiles 2021-03-11T12:14:38Z