3 Replies Latest reply on Jul 27, 2018 1:35 PM by swaroop.gantela

    Relative Date Range Filter for a duration

    Tram Le-Nguyen

      Hi,

       

      I would like to create a filter that will show a duration of a task. I have the Start Date and the Duration of each task in my data and I can calculate the end date. I found this Creating a Filter for Start and End Dates Using Parameters | Tableau Software which is pretty close to what I want except I want to use the relative dates filter. Is this possible?

       

      I currently have a filter that shows all task that starts in this range, but I also want it to show ongoing tasks that starts before the range.

      2018-07-26_11-43-28.png

      In the example above, if I had a task that begins in Jun 1 and ends in Jun 5, it will not appear in this chart.

       

      My data is sensitive so I am unable to attach the workbook.

       

      I am currently using Tableau Desktop 2018.1.2