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())
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.
