3 Replies Latest reply on Apr 26, 2017 6:01 AM by Michael Hesser

    Create a filter or calculated field of specific date ranges?

    Katie McCann



      I'm not sure if this is something can be done in tableau, but what I'm trying to do is create a filter of a series of set date ranges.  I have 5 set date ranges right now that overlap:

      October 10, 2014 to June 30, 3015

      January 15, 2015 to September 30, 2015

      April 15, 2015 to December 31, 2015

      July 14, 2015 to March 31, 2016

      October 14, 2015 to June 30, 2016

      (these are the 180 non-holiday weekdays ending each quarter)


      I am wanting to calculate the average vehicle volume during each of these date ranges and it would be nice to have a filter where I can easily click and compare between ranges rather than having to slide the date range bar to each of my desired date ranges every time. 


      What I have right now is two parameters: start date with my 5 start dates, and end date with my 5 end dates, and that is better than using the slide bar, but I still can't look at more than one range at once.


      This screen capture shows what I already have and what I would like to have with each of the columns representing a the five ranges.

      Is it possible to create a calculated field of set date ranges that overlap? Is this something that parameters can do?