1 Reply Latest reply on Aug 29, 2018 4:41 AM by Martin Asztalos

    Understanding - Table Calculation ("PCT75" & "Moving Calc.")

    Martin Asztalos



      I am trying to understand why Tableau computes the value "398" for week 52 with the calculation of "75% Percentile" combined with "Moving Calc." (red arrow in the table screenshot)  .

      The "simple" 75% percentile of week 52 matches my check in excel.

      But the check of the "75% Percentile" combined with "Moving Calc." does not match at all.

      If I cross check the raw data in excel the I would expect a value of 129.


      What is wrong in my calculation?