Filter a Straight Table Visualisation

Ja4 — Mon, 09 Oct 2023 11:58:40 GMT

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.

Re: Filter a Straight Table Visualisation

YuriMary — Tue, 17 Oct 2023 12:49:44 GMT

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