Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Please help me on the below requirement.
In a Straight Table I have Three dimensions named Grouping, Metric and Number as like below.
When Operation= Met35.1 and Met35.2 then correspoding records need to avoided and When operations=Met 35.6 then need to keep
those records in the result.Please find the expected result below.
another approach could be like below.
you can create a flag in the load script and can use that flag in the UI expression instead of applying the if condition.
at load script:
if(Grouping='operations' and (match(Metric,'Met35.1','Met35.2')),0,1) as GrpMetricFlag
from <your source>;
Then in UI chart expression you can do:
sum({<GrpMetricFlag={1}>}Number)
this approach could perform better in case of large volume of data.
Hi,
try this :
if(Grouping='operations' and (match(Metric,'Met35.1','Met35.2')),null(),sum(Number))
No need using set analysis I think.
Is this the same thing as this?
another approach could be like below.
you can create a flag in the load script and can use that flag in the UI expression instead of applying the if condition.
at load script:
if(Grouping='operations' and (match(Metric,'Met35.1','Met35.2')),0,1) as GrpMetricFlag
from <your source>;
Then in UI chart expression you can do:
sum({<GrpMetricFlag={1}>}Number)
this approach could perform better in case of large volume of data.