Skip to main content

Hello Tableau community!

 

I have a request and having issues coming up with a solution.

 

For example I have create date, user name and the total number of records:

I need to use "create date" as a quick filter and display like below.

 

The works as expected but not what is needed.

 

What I need is to show the total count of records for the full time period even if the start date in the create date is filtered. So instead of showing the 8 records I need to see 30. The only filtering should be when the end date of the create date is filtered.

 

I've attached a sample workbook. I've tried some LOD calculations and start date / end date parameters but not sure the best approach.

 

Thanks

19 answers
0/9000