Filter a Straight Table Visualisation

[Ja4]

I have a straight table visualisation where I'm trying to show a summary of jobs completed yesterday .

I have a calculated dimension:  If(actstart >= Floor(Today()-1) and actstart < Floor(Today()), -1, 0) as DateCheck,

so if DateCheck = minus 1, just show all the data for yesterday.

Other Fields include [job number] [Location] [duration]

I even have a variable vShowActualShartDate,  =date(today()-1)

But nothing seems to work, please help.

[YuriMary · Accepted solution]

To filter your straight table for jobs completed yesterday, use the following expression in your calculated dimension:

=If(DateCheck = -1, [job number], null())

This way, it only shows data for yesterday when DateCheck is -1. Raiderlinkttu