3 Replies Latest reply on Jul 6, 2016 9:42 AM by Aiswarya Sundaram

    Same time last year reference line

    Matthew Hefferon

      Hey Tableau Community!

       

      I was hoping one of you can help me out with a calculation?

       

      I have a bar chart showing the sum of sales for July 2015 and July 2016. We have a full bar of sales for the month of July 2015 but since we're only 6 days into July 2016 we have a short bar. I want to show the full month of sales so we can see where we need to get too but I also want to add a red reference line showing where we were the same time last year. Any thoughts or ideas appreciated!

       

      Reference Line.PNG

       

      Attached is a dummy workbook!

       

      Thanks

       

      -Matthew