splash page

[Aitelli_805]

In master item filter I have integrater server which has true, false. I need to show which total of true which are present and total kw. I'm using the climber kpi  for dimension i have sum(power_kw), sum('present') count integrated server. Not sure what logic to used to calculated 

• TOTAL INSTALLED - - Plus Total KW (TKW)

[ToniKautto · Accepted solution]

Set expression allow you to alter the aggregation scope, for example:

sum({<MyFlag={"true"}> MyField}

Note, the exact format depends on your data model and flag fields.