1 Reply Latest reply on Apr 3, 2018 5:46 PM by Zhouyi Zhang

    Comparison with monthly average

    arun.yadav

      Hi All,

       

      I have a scenario , where I want to compare yesterday's value with monthly average and determine the deviation.

      GroupName
      GroupAverageLatestTimeStampCount
      GroupA1004/03/201810
      GroupB1504/03/201815
      GroupC2004/03/201822
      04/03/2018

       

      Now ,I want to compare "Count" column with "GroupAverage" and flag accordingly.

      "GroupAverage" is calculated for every group.

       

      Any input will be much appreciated.

       

      Regards,

      Arun