https://community.qlik.com/t5/App-Development/Median-Total-Table-Chart/m-p/1597256#M44170 <P>Hello everyone,&nbsp;</P><P>I'm trying to figure out how to create a Median column that would show the true Median in the <STRONG>Total Function</STRONG>, but Sense only offers "Auto", "Avg", "Count", "Max", "Min, "Sum", and "None". Unfortunately these options do not give the correct Median.</P><P>The table chart that I'm working with have customers with their Move In Dates. I have a column that calculates the Duration by taking the vMaxSelectedDate - Move In Date and this works fine when I choose "Avg" for Total Function. However, Median is giving me problems. In the expression, I'm using Median(vMaxSelectedDate - Move In Date), which when looking at individual customers, the Median is the same as Duration, but I'm focusing on the Total number at the top of the chart.</P><P>&nbsp;</P><P>Picture below shows Median Total of 507 but should be 455.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14652i2E28C59348CA5D43/image-size/large?v=v2&amp;px=999" role="button" title="Capture2.JPG" alt="Capture2.JPG" /></span></P><P>I thought perhaps just creating a KPI chart would work, but using the expressions above, give me incorrect data.</P><P>&nbsp;</P><P>Can someone help me out? First time posting here <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Fri, 28 Jun 2019 18:15:43 GMT Stickman 2019-06-28T18:15:43Z https://community.qlik.com/t5/App-Development/Median-Total-Table-Chart/m-p/1597256#M44170 <P>Hello everyone,&nbsp;</P><P>I'm trying to figure out how to create a Median column that would show the true Median in the <STRONG>Total Function</STRONG>, but Sense only offers "Auto", "Avg", "Count", "Max", "Min, "Sum", and "None". Unfortunately these options do not give the correct Median.</P><P>The table chart that I'm working with have customers with their Move In Dates. I have a column that calculates the Duration by taking the vMaxSelectedDate - Move In Date and this works fine when I choose "Avg" for Total Function. However, Median is giving me problems. In the expression, I'm using Median(vMaxSelectedDate - Move In Date), which when looking at individual customers, the Median is the same as Duration, but I'm focusing on the Total number at the top of the chart.</P><P>&nbsp;</P><P>Picture below shows Median Total of 507 but should be 455.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture2.JPG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14652i2E28C59348CA5D43/image-size/large?v=v2&amp;px=999" role="button" title="Capture2.JPG" alt="Capture2.JPG" /></span></P><P>I thought perhaps just creating a KPI chart would work, but using the expressions above, give me incorrect data.</P><P>&nbsp;</P><P>Can someone help me out? First time posting here <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Fri, 28 Jun 2019 18:15:43 GMT https://community.qlik.com/t5/App-Development/Median-Total-Table-Chart/m-p/1597256#M44170 Stickman 2019-06-28T18:15:43Z https://community.qlik.com/t5/App-Development/Median-Total-Table-Chart/m-p/1597741#M44193 <P>Would really appreciate any help on this <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Mon, 01 Jul 2019 15:03:39 GMT https://community.qlik.com/t5/App-Development/Median-Total-Table-Chart/m-p/1597741#M44193 Stickman 2019-07-01T15:03:39Z