CODEWITHSUNDEEP
tableau-api
MrKrizzer
MrKrizzer

Reputation: 439

Date filter for not showing the recent date data in Tableau

I am building a dashboard for retention. The data that I am getting for the most recent day seems to have huge spikes because the denominator is not having entire data for the day.

So, I just want to show the data till previous day and it should be automated likewise.

Please let me know if anyone had dealt with the same problem.

Thanks, Sai

Upvotes: 0

Views: 616

Answers (2)

Sam M
Sam M

Reputation: 4166

Create a calculated field to return a boolean value if the data is from today's date. Then filter on False.

DATETRUNC('day', [Your Date Field]) = DATETRUNC('day', TODAY())

Upvotes: 0

smb
smb

Reputation: 673

The best way to do this is through creating a calculated field: Create a field called Recent Date as follows:

DATETRUNC('day',[Date]) = {FIXED : MAX(DATETRUNC('day',[Date]))}

What this does is creates a Boolean field where the most recent date will be flagged as TRUE and all others as FALSE.

Drag this field into the filters pane and select FALSE. This will remove the most recent dates data.

Upvotes: 2

Related Questions