8 Replies Latest reply on Oct 9, 2018 11:47 AM by ShivaRam Chennapragada

    Year over year graphs?

    Jeremy Bayless

      I've been looking this up for a couple hours now - and I realize that this is a commonly asked question and I don't really get why this is so difficult to do, but I've tried several different things and can't make it work.

       

      All I am wanting to do is have a line graph that shows, by month values for 2017 and values so far for 2018.

       

      My data is coming from an access database and I have it like this (all months for 2017 and 2018 - just am not listing them out fully here)

       

      ValueMonth
      Year
      Date
      150September201809/01/2018
      85August201808/01/2018
      192July201807/01/2018
      ........
      125December201712/01/2018
      207November201711/01/2018
      217October201710/01/2018
      And so on
      for every
      month, data
      formatted

      -----

       

      What I want to happen is have the months going across the bottom of the Graph - January - December.  I then have the values going up the left side of the graph.  I then have two lines - one representing 2017 values per month and one representing 2018 values per month.

       

      In Tableau -> Month, Year, and Date fields are all Dimensions and the Value field is a measure.

       

      Any assistance would be greatly appreciated and I'm pretty sure this will be asked, but no - I can not upload a copy of the Tableau workbook unfortunately.