3 Replies Latest reply on Mar 9, 2017 12:49 PM by Christina Gremore

    Current vs. Previous Date Range with Single Line Chart (Workbook Attached + Reference)




      I know this question gets asked a lot and I have indeed researched and tried out a few solutions, however, from a business dashboard design perspective, they are often times not practical.


      Here is an example:



      Great solution, works as intended, easy to follow instructions but it simply does not work in the context of one of many components on a functional business dashboard in terms of using the line chart as a filter.


      Has anyone found any solutions that do not require parameters to be used to display current vs previous date ranges on a single line chart?


      I would like to be able to see a comparison of the following on one line chart:


      Current Date Range: 03/01/2015 - 02/28/2016

      Previous Date Range (Same Period One Year Earlier): 03/01/2015 - 02/28/2015


      Thank you,