7 Replies Latest reply on Jul 11, 2018 8:23 AM by swaroop.gantela

    Running Average vs YTD Average

    Rick Maly

      So I have been trying to figure out how to exactly do this and have run out of ideas.  I have a chart where I am calculating the monthly average of a metric. It is represented as a bar graph.  I also am trying to do a YTD stacked line graph on top.  I have gotten the graph set up but the line YTD graph is showing an average of an average.

       

       

      What I am wanting to do is show the YTD at the end of each month.  It would be a running average where the current % in the month is shown as what it is today, but previous month would show what the YTD average was at the end of that month.

       

       

       

      The Tableau dashboard shows May as being 79.8% but from the above it should be 75.6%.

       

      Any ideas?