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:



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