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