This content has been marked as final. Show 1 reply
See the attached for three different options. All end up with 2 dates in the view and use the Difference quick table calculation.
- Parameter - we use two parameters to pick the dates and a calculated field to filter them. The disadvantage with parameters is that they are not dynamic.
- Self-blends for dynamic parameters - the data is joined to twice to get data sources that we can get dates from, this technique is covered in more detail here: Creating a Dynamic “Parameter” with a Tableau Data Blend | Drawing with Numbers
- Using a multiple values filter. The challenge here is that we can't limit the user to just two selections, so to warn the user there's a table calculation to filter the results to only display them when there are two dates, and a separate unfiltered worksheet that blanks out all the marks and uses a table calculation generated title.