9 Replies Latest reply on Jul 17, 2014 8:55 AM by Aaron Clancy

    Show values for two different time periods for one measure

    Ryan Esslinger

      Is this possible?


      I have a rolling time series in which I'm trying to display yesterday's date with a look-back of one year's time sliced by YearWeek, but I need to show the aggregated values stacked in the same bar for Current Year versus Previous Year by YearWeek, so that growth is visually displayed.


      The data filter for my viz is:


      IF Date>=(DATEADD("year",-2,TODAY()-1))AND Date<=TODAY()-1 THEN 1 ELSE 0 END


      Where Filter = 1


      However, my viz shows the entire span of time with each bar as its own YearWeek.  I need to take one measure (SUM of dollars) and break it out as different visualizations.