2 Replies Latest reply on Oct 17, 2017 4:31 AM by Simon Jacobs

    Can I filter on two years by only selecting one?  To show selected year vs. previous year on a chart

    Simon Jacobs

      Hi everyone,

       

      I have a data file containing the number of daily engagements on social media platforms.  Currently I have a line chart showing total engagements per month for a year selected by a user.  The filter allows the user to choose a single year.  I'd like to include a second line on the chart showing the equivalent data for the previous year.  i.e. if the user selects 2017 on the filter I want to show data for 2016 and 2017.  Ideally I want the comparison year to be automatically generated by Tableau rather than allowing the user to choose a 2nd year for comparison. Is that possible?

       

      Many thanks,

       

      Simon