5 Replies Latest reply on Oct 18, 2017 11:21 AM by Júlia Dreher

    Last 12 months average

    Júlia Dreher

      Hi all,


      I´m trying to show de last 12 months avarage, but I don´t know what I´m doing wrong.


      This is my sample spreadsheet:



      The value on column 'Média últimos 12 m' show what I expect to show on Tableau, that is the average of the last 12 values. I have used these values as my data base and used the following settings:


      It has created this formula: WINDOW_AVG(AVG([Valor]), -12, 0)


      The point is that the values shown are close to the right values, but they are not the same:


      For example: In october/2017, the average should be 1475, but Tableau shows 1450.


      What do I have to change?