I have an issue where my Date Filter (based on parameters) is not displaying properly and I hope someone can help. For each retailer, a start and end measurement date are provided. I use these values to populate a start select parameter and end select parameter and then use a filter to select "within range". This works perfectly for the table, but if I just want to see totals, it breaks as soon as I remove the start/end dimensions from my visualisation. I'm happy to try something completely different. The only caveat is that the totals need to be stand alone, apart from the main table. Hugely simplified mock up attached. Any ideas very welcome. Thank you in advance!
@Tonia Perretta
Hi, I guess you need a row filter like:
if [Measurement Start]>[Select Start Date] AND
[Measurement End]<[Select End Date] then "Within Date Range" else "Outside Date Range"
END
Check if the attached workbook helps.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
