6 Replies Latest reply on Feb 19, 2017 4:23 PM by Madhusudhan Khambham

    Weekly average based on last 7 days

    Nat Vats

      I have to create a chart based on weekly average of Calculation1 in attached report based on bank and weeks are defined by last 7 days from the run date e.g if report is run for 01/23/2017 then week will include from 23rd to 17th, 16th to 10th

      Daily Data:

      day                bank      Calculation1

      01/23/17       Bank1       100

      01/23/17       Bank2       200

      01/20/17       Bank1       300

      01/20/17       Bank2       700

      .

      .

        

      .

      Expected Results: (if run for 01/23/17)

      Bank            Week1 Average(23rd to17th)          Week2 Average (16th to 10th)...................

      Bank1          400                                                       300

      Bank2          500                                                        450   

      .

      .

      .

      .