8 Replies Latest reply on Jun 25, 2019 11:16 AM by Jim Dehner

    Use Table calculation with a month delay

    Ana RIta Oliveira

      Hi all,

       

      I'm trying to use table calculation (previous_value() function) to create a tendency/goal line in a graph. Below the graph I have so far.

       

      The problem is, I need this tendency line starting not in the first month (Maio de 2019) but instead in the second and so far. I can simulate this in excel although I'm struggling to get it in Tableau. The image below shows the result in Excel and also the formula I use to calculate the tendency)

       

      How can I set a delay in a table calculation to get this kind of result? I have attached the tableau workbook and also the sample data used to do this graph.

       

      Best

      RO