https://community.qlik.com/t5/App-Development/Calculated-measure-incorrect-in-line-graph-due-to-sorting-with/m-p/1582458#M63024 <P>I have a line chart showing DSO (current month A/R divided by total revenue over last 3 months divided by 90)&nbsp; trending over time.&nbsp; The calculation works fine when I just have the data points plotted by project, but when I try to add the dimension of Payor Category, to split out each project even further, the calculations get thrown off due to the sorting order.&nbsp; When I display the data in the table, if I sort by Payor Category, and then by Month/Date as the last sorted value, the calculation is correct.&nbsp; However, in the line graph, it defaults to the month/date being the first sorted value, and I cannot reorder them.&nbsp; I've tried a number of different things, but I'm still very new to all of this so any help would be appreciated!</P><P>Here's the calculation&nbsp; (The chart is also only showing data for the last 6 months):&nbsp;&nbsp;</P><P>Sum({$&lt;[KPI Date.autoCalendar.MonthsAgo]={"&lt;=6"}&gt;}[Total A/R])/(RangeSum(Above(total Sum({$&lt;[KPI Date.autoCalendar.YearMonth]&gt;}SS.Revenue),0,3))/90)</P> Sat, 16 Nov 2024 20:49:54 GMT BZane 2024-11-16T20:49:54Z https://community.qlik.com/t5/App-Development/Calculated-measure-incorrect-in-line-graph-due-to-sorting-with/m-p/1582458#M63024 <P>I have a line chart showing DSO (current month A/R divided by total revenue over last 3 months divided by 90)&nbsp; trending over time.&nbsp; The calculation works fine when I just have the data points plotted by project, but when I try to add the dimension of Payor Category, to split out each project even further, the calculations get thrown off due to the sorting order.&nbsp; When I display the data in the table, if I sort by Payor Category, and then by Month/Date as the last sorted value, the calculation is correct.&nbsp; However, in the line graph, it defaults to the month/date being the first sorted value, and I cannot reorder them.&nbsp; I've tried a number of different things, but I'm still very new to all of this so any help would be appreciated!</P><P>Here's the calculation&nbsp; (The chart is also only showing data for the last 6 months):&nbsp;&nbsp;</P><P>Sum({$&lt;[KPI Date.autoCalendar.MonthsAgo]={"&lt;=6"}&gt;}[Total A/R])/(RangeSum(Above(total Sum({$&lt;[KPI Date.autoCalendar.YearMonth]&gt;}SS.Revenue),0,3))/90)</P> Sat, 16 Nov 2024 20:49:54 GMT https://community.qlik.com/t5/App-Development/Calculated-measure-incorrect-in-line-graph-due-to-sorting-with/m-p/1582458#M63024 BZane 2024-11-16T20:49:54Z