1 Reply Latest reply on Sep 27, 2018 9:41 PM by lei.chen.0

    calculate variance at group and 'ALL' groups level

    Julia.rose

      Hi

       

      I have product data. what i need is coeff of variance = standard deviation/ Mean . Average is avg of revenue within the week. Std.dev is std.dev of revenue within the week.

      Finally I have to show a bar chart with week number on x-axis and variance on y-axis.

      variance numbers should change as we select product,type,week in filters .

      Can anyone help me with this.

      Can you make sure you get variance right when 'ALL' is chosen for product type. I used LOD but for 'ALL' option i am not getting right numbers.

      I think the problem is for 'ALL' option, first i need group by product,type,week,all groups. and then again do a groupby calculation for avg and std.dev.

       

       

      Row LabelsTotal Revenue
      7/7/20182980730.081852Variance
      7/8/2018291491308429.6Average
      7/9/201827166725245.5Std.dev
      7/10/2018325486
      7/11/2018340930
      7/12/2018333372
      7/13/2018297988
      (blank)
      Grand Total2159007