1 Reply Latest reply on Feb 13, 2018 4:26 AM by Zhouyi Zhang

    Calculate average of the last n points

    Abc Abc

      Hello

      Do you know how can I calculate average of the last (by date) 10 points ? The goal is to take to calculation the latest data. I can't ensure that data will be delivered to Tableau in proper date order so some kind of sorting is needed.

      I attached simple workbook with data.

      Thanks

       

      Expected result:

      NameAverage of last n points of sales
      Katex
      Gregy