Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
Hi everyone,
Would anyone be able to help me to simply the following, they are in two dimesnions in the same table and I would like to know if there are more efficent to get the same results? So far they do work but take some time to load the table.
 =IF(call_sign like 'CF*' or
call_sign like 'SF*' or
call_sign like 'NF*' or 
call_sign like '*AED*' or
call_sign like 'DEFIB*' or 
ISNULL(time_on_scene) ,NULL(), call_sign)
 
=IF
 (BatchImages.imageStatusDetail like 'Validated' and 
(Master.ChiefComplaint like '*deceased*' OR
 Master.ChiefComplaint like '*cardiac arrest*' or 
Master.CardArrest='1' or 
Master.ROLE='1')
 ,IncidentNumber,NULL()) 
Thank you in advance for any tips.
 
					
				
		
 alexandros17
		
			alexandros17
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		there are two choices:
1) move the conditions in expressions using set analysis
2) when you load data use an additional field as a flag that satisfy all the conditions, then use that field directly in the dimension (as you do now) or use it in expression with set analysis.
Hope it helps
Alessandro
