Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

2 date ranges for data

I am currently working with a large data set and I am using created date as the driver for the majority of my reports. Currently created date spans from 01/01/2016 to current day but will be including much more history soon.  The way I have the data set up wtih measures now is to look at this year and last year based on the year of the creation date. Now I am being asked to be able to filter the data to one set of time and compare the second set to that first one. Meaning If they set the first set to 1/1/2016 to 5/1/2016 they want to compare it second set of data on the same graph of 1/1/2017 to 5/1/2017. So what I did was create a copy of the created date and give them seperate names and update the measures to look at the different date sets and then  use those as my filters to adjust the data. So Created date 1 and Created date 2 on the same graph for time frames that are the same months but for different years. When I did this and updated the measures that the graph is based on the graphs went blank. My data set is to large and diverse to create a key to link it to a duplicate of itself and I am not out ideas. I tried to have a year and a quarter filter but was told that was not ideal for what was wanted being that they want more flexability in being able to pick date ranges to compare.

20 Replies

  • Hi Anonymous,

     

    Not sure if i'm understanding your question correctly but if you add a calendar table to link to your data and use that calendar for the axis of your visuals this should give you what you need when calculating your measures.

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable

      I added a calendar table do I link that to my created date? Here is my issue, I have data from 1/1/2016 to yesterday. I have a graph that lists the months of the year and one column is for this year and one column is for last year so you can compare them. So for whaterver time frame I select in 2016 I want to see how the numbers compare to 2017. Are you saying that by linking my created date to the caldenar I can do this? I have not used the calendar before and just created it so I am little confused as to how to use it.

      • MFelix's avatar
        MFelix
        Super User

        HI Anonymous,

         

        You need to link the calendar table to the column that you are using the measures and then replace both the visual axis and in the measure the date by the calendar date.

         

        If you can give some sample of the data and measure I could send you a walktrough.

         

        Regards,

        MFelix