1 Reply Latest reply on Mar 3, 2016 6:13 PM by Derrick Austin

    Expanding Comparative YOY sales day by day as current year progresses

    Robert Johnson

      At the conference on tour in Sydney, It was suggested I post this here as a guide for others:

       

      I have a year on year comparative sales line graph, but found this unwieldy with lines drawing off into the distance for prior years when only a few days into my current year sales.

       

      I solved this by calculating the number of days we are from September 1  (our FY start date) and then applying this as a filter to prior year data.

       

      More details here:

      https://medium.com/@amenman/tableau-auto-expanding-comparative-line-graph-911461c9409e#.mds6bl88i

       

      I'm rather new to this, so I'd love to hear any ways I could have done this in an easier manner!