4 Replies Latest reply on Sep 8, 2012 8:36 AM by Gordon Young

    Reference line for average within year

    Gordon Young

      Hi Tableau Community.


      It's Friday afternoon and my brain is not working so need some help before I can leave for the weekend.

       

      I have a sales transactions by product that I am displaying by month. I am trying add a reference line that calculates the average monthly sales for each year.

       

      MMy problem is that the reference line for average is only taking into account months that have data. What I want is the average to take into account each month even when there is no data.

       

      For example, Product = 1 and Year = 2012.  The average I want to show is 9,000/12months =  750. Instead I current get the picture below.

       

      Monthly Sales.png