https://community.qlik.com/t5/App-Development/Cumulative-Average-Calculation/m-p/1893175#M73665 <P>I have data as shown below.&nbsp;I am trying to calculate the <STRONG>cumulative</STRONG>&nbsp;average of the volume. So essentially I am trying to create Column F (Cumul Avg Vol) in Qliksense. The cumulative aspect is by increasing&nbsp;<STRONG>Bucket </STRONG>value.&nbsp;</P> <P>For example:&nbsp;</P> <P><STRONG>Sub Order 1 and 2</STRONG> are in the same <STRONG>Bucket (=5)</STRONG> so calculate the average volume of these (<STRONG>7.5</STRONG>).</P> <P><STRONG>Sub Order 3</STRONG> is a larger <STRONG>Bucket value (10)</STRONG>, so calculate the average of the volume of Sub Order 1, 2, 3 (<STRONG>5.75</STRONG>).&nbsp;</P> <P><STRONG>Sub Order 4 and 5</STRONG> have the same larger <STRONG>Bucket value (15) </STRONG>, so calculate the average of all smaller Bucket values, so row 1, 2, 3, 4, 5 (<STRONG>5.83</STRONG>).&nbsp;</P> <P>Sub Order 6 has a larger <STRONG>Bucket value (25) </STRONG>, so calculate the average of all smaller Bucket values, so row 1, 2, 3, 4, 5, 6 (<STRONG>6.125</STRONG>).&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnnyjohn_0-1644935215961.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72328i8BFD9AB81F762AA9/image-size/medium?v=v2&amp;px=400" role="button" title="johnnyjohn_0-1644935215961.png" alt="johnnyjohn_0-1644935215961.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>by increasing bucket. I.e. if the <STRONG>Bucket&nbsp;</STRONG>for the Sub Order ID is less</P> <P>&nbsp;</P> Tue, 15 Feb 2022 14:30:14 GMT johnnyjohn 2022-02-15T14:30:14Z https://community.qlik.com/t5/App-Development/Cumulative-Average-Calculation/m-p/1893175#M73665 <P>I have data as shown below.&nbsp;I am trying to calculate the <STRONG>cumulative</STRONG>&nbsp;average of the volume. So essentially I am trying to create Column F (Cumul Avg Vol) in Qliksense. The cumulative aspect is by increasing&nbsp;<STRONG>Bucket </STRONG>value.&nbsp;</P> <P>For example:&nbsp;</P> <P><STRONG>Sub Order 1 and 2</STRONG> are in the same <STRONG>Bucket (=5)</STRONG> so calculate the average volume of these (<STRONG>7.5</STRONG>).</P> <P><STRONG>Sub Order 3</STRONG> is a larger <STRONG>Bucket value (10)</STRONG>, so calculate the average of the volume of Sub Order 1, 2, 3 (<STRONG>5.75</STRONG>).&nbsp;</P> <P><STRONG>Sub Order 4 and 5</STRONG> have the same larger <STRONG>Bucket value (15) </STRONG>, so calculate the average of all smaller Bucket values, so row 1, 2, 3, 4, 5 (<STRONG>5.83</STRONG>).&nbsp;</P> <P>Sub Order 6 has a larger <STRONG>Bucket value (25) </STRONG>, so calculate the average of all smaller Bucket values, so row 1, 2, 3, 4, 5, 6 (<STRONG>6.125</STRONG>).&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnnyjohn_0-1644935215961.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72328i8BFD9AB81F762AA9/image-size/medium?v=v2&amp;px=400" role="button" title="johnnyjohn_0-1644935215961.png" alt="johnnyjohn_0-1644935215961.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>by increasing bucket. I.e. if the <STRONG>Bucket&nbsp;</STRONG>for the Sub Order ID is less</P> <P>&nbsp;</P> Tue, 15 Feb 2022 14:30:14 GMT https://community.qlik.com/t5/App-Development/Cumulative-Average-Calculation/m-p/1893175#M73665 johnnyjohn 2022-02-15T14:30:14Z https://community.qlik.com/t5/App-Development/Cumulative-Average-Calculation/m-p/1894361#M73778 <P>Bump. Any ideas here please?&nbsp;</P> Thu, 17 Feb 2022 14:43:16 GMT https://community.qlik.com/t5/App-Development/Cumulative-Average-Calculation/m-p/1894361#M73778 johnnyjohn 2022-02-17T14:43:16Z https://community.qlik.com/t5/App-Development/Cumulative-Average-Calculation/m-p/1904559#M74586 <P>little bump here in case any can help</P> Mon, 14 Mar 2022 09:16:04 GMT https://community.qlik.com/t5/App-Development/Cumulative-Average-Calculation/m-p/1904559#M74586 johnnyjohn 2022-03-14T09:16:04Z