3 Replies Latest reply on Aug 28, 2018 9:20 AM by Shinichiro Murakami

    Moving Percentile as a Calculated Field within "Data Source"

    Martin Asztalos

      Hi,

       

      How can I compute a moving percentile by week and group?

      I would like to have this computation as an calculated field within the Data Source sheet.

       

      The aim is to compare  the 0.75 percentile of week X to the 0.75 percentile of week (X-1 to X-3).

      WW34 --> WW33 - WW31

      WW33 --> WW32 - WW30

      etc.

       

      Computing the 75% percentile of week X for a group works but I struggle to calculate a Moving Percentile.

      Does someone have an idea how to solve this?

       

      Martin