Calculated Dimensions

[#1]

Hello!

I have a couple of tables and charts that have the following expression as a calculated dimension:

= IF (FLAG_ANOMALY = 1, 'Anomaly',

     IF (FLAG_ANOMALY = 0 AND FLAG_INSPECTION = 1, 'No Anomaly')

I use that expression to show that value depending on the flag and other conditions.

Do you recommend me to use it directly in the script for better performance?

(In general, is it better to avoid calculated dimensions if we could?)

Should I get the same result?

Thank you!!!

[tresesco]

Yes, if your data size is big, it would be better to do it in the script using mapping , and you should get same result.

[#3]

And would it work if I use the conditionals I mentioned on the corresponding table that have the anomalies?

[tresesco]

Yes, that would work too. However, it is suggested to avoid multiple IFs statement. So, if mapping doesn't help, you could think of another alternative of using Pick(Match(....combination that is comparatively better that IFs in terms of performance.