Set Analysis

[bhavvibudagam]

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.

[Anonymous]

Hi,

try this :
if(Grouping='operations' and (match(Metric,'Met35.1','Met35.2')),null(),sum(Number))

No need using set analysis I think.

[sunny_talwar]

Is this the same thing as this?

How to avoid Duplicate Records

[sudeepkm · Accepted solution]

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.