9 Replies Latest reply on Oct 14, 2016 8:10 AM by Shinichiro Murakami

    Help needed with Date calculations

    Brad Sheridan

      Hi Community!  Spent considerable time on this today and I'm sure there is an easy answer.

       

      I'd like to create a scatter plot of sales for of the current year vs. last year.  There will be a relative date filter (previous month, current month, previous year, etc...) that needs to drive the "last year" calculation.

       

      For example: user selects current month and the x-axis shows the sales (by employee for example) for October 2016.  On the y-axis would be the sales by employee for October of 2015.

       

      Please let me know your thoughts/tricks/hacks

       

      TIA!

      Brad