You will need to use parameter based on Time Frame. You'll then need to Split the parameter, Dateparse it, then compare to end dates.
Pl proceed like this:
- Create a view like this.
- For this I added another Column to your data (SNo) , to avoid the rows from merging.
- Split the Time frame into Start Time and End Time Fields using the Split Option in Tableau (Delimiter is "-").
- Create the View
I used Date Check Calculated field to check if a END Dt falls in the interval or not;
IF ATTR([End Dt]) >= ATTR([Start Time])
AND ATTR([End Dt]) <= ATTR([End Time])
Now, you can easily Check for the "EndDt" Falling in Time frame by keeping the Date Check Filter=1 as follows:
The workbook in Tableau 10 is attached for your reference. Hope, that helps.