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?

       

      Regards!

      Júlia