https://community.qlik.com/t5/Integration-Extension-APIs/Explain-box-plot-median-calculation/m-p/1723400#M12959 <P>I'm getting different values when comparing the middle value of a box plot and the calculation of median of the same data. I traced it down to the default equation for the box plot median value.&nbsp;</P><P>However, i don't really understand what all the fields are doing.</P><P>This is the equation in the box plot that calculates the median:</P><P>=Median( total &lt;[Line]&gt; Aggr( calculated_delay, [Line], [=calculated_delay] ) )</P><P>&nbsp;</P><P>I know "Aggr( calculated_delay, [Line])" groups the calculated_delay by the Line, but i don't quite understand what '[=calculated_delay]' or the 'total &lt;[Line]&gt;' does.&nbsp;</P><P>Can anyone explain this for me?</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:01:29 GMT beaubellamy 2024-11-16T02:01:29Z https://community.qlik.com/t5/Integration-Extension-APIs/Explain-box-plot-median-calculation/m-p/1723400#M12959 <P>I'm getting different values when comparing the middle value of a box plot and the calculation of median of the same data. I traced it down to the default equation for the box plot median value.&nbsp;</P><P>However, i don't really understand what all the fields are doing.</P><P>This is the equation in the box plot that calculates the median:</P><P>=Median( total &lt;[Line]&gt; Aggr( calculated_delay, [Line], [=calculated_delay] ) )</P><P>&nbsp;</P><P>I know "Aggr( calculated_delay, [Line])" groups the calculated_delay by the Line, but i don't quite understand what '[=calculated_delay]' or the 'total &lt;[Line]&gt;' does.&nbsp;</P><P>Can anyone explain this for me?</P><P>&nbsp;</P> Sat, 16 Nov 2024 02:01:29 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Explain-box-plot-median-calculation/m-p/1723400#M12959 beaubellamy 2024-11-16T02:01:29Z