Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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