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)

    sam.hong.0

      Hello,

       

      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:

      https://talkdatatome.net/2016/10/17/different-time-series-on-the-same-axis-made-easier/

       

      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,

      Sam