https://community.qlik.com/t5/App-Development/Formula-Help/m-p/1685905#M52236 <P>I have this lovely code that is charting a trend line.</P><P>I have no idea how to decipher this.</P><P>&nbsp;</P><P>=LinEst_M(total aggr(if(Count(WOID),count(WOID)),MonthYear), MonthYear)*<BR />only(MonthYear)+LinEst_B(total aggr(if(count(WOID),count(WOID)),MonthYear),MonthYear)</P> Sat, 16 Nov 2024 18:55:22 GMT FMDF 2024-11-16T18:55:22Z https://community.qlik.com/t5/App-Development/Formula-Help/m-p/1685905#M52236 <P>I have this lovely code that is charting a trend line.</P><P>I have no idea how to decipher this.</P><P>&nbsp;</P><P>=LinEst_M(total aggr(if(Count(WOID),count(WOID)),MonthYear), MonthYear)*<BR />only(MonthYear)+LinEst_B(total aggr(if(count(WOID),count(WOID)),MonthYear),MonthYear)</P> Sat, 16 Nov 2024 18:55:22 GMT https://community.qlik.com/t5/App-Development/Formula-Help/m-p/1685905#M52236 FMDF 2024-11-16T18:55:22Z https://community.qlik.com/t5/App-Development/Formula-Help/m-p/1685907#M52238 <P><A href="https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/StatisticalAggregationFunctions/linest_m.htm" target="_blank">https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/StatisticalAggregationFunctions/linest_m.htm</A></P> Wed, 18 Mar 2020 23:36:51 GMT https://community.qlik.com/t5/App-Development/Formula-Help/m-p/1685907#M52238 dwforest 2020-03-18T23:36:51Z