11 Replies Latest reply on Jun 23, 2015 10:07 AM by Tom W

    How to do comparison for arbitrary date intervals

    Josh Patchus

      I have a list of a few stores, and i have the daily sales for each store. I am looking to do arbitrary comparisons. This is done quite easily on a single data slider level, because I can limit the days to sum over. However, I want the user to be able to select an arbitrary comparison range. This allows the user to go from last week to last month to this week last year, this month last year. So ideally there would be two date slicers, one to select date range 1, the other to select date range 2 (the comparison range). Then in the table, there would a % change.

       

      I cant seem to get two date slicers in the same dashboard. I also cant seem to merge the two data tables together to form a single table to do the %'s.

       

      Cheers,

      Josh