Count-if formula in SAP Lumira (for calculated measure)

[Former Member]

Hello everyone,

I am new to SAP Lumira and want to create a calculated measure, that will do a count(Distinct) on one field, if another field has a certain field == 'some_value'.

Exemplary pseudocode: count(alert_ID) if alert_type == 'urgent'

Can anybody assist me with this?

Best wishes,

Marvin

[Henry_Banks · Accepted solution]

Hi,

If Then Else formulae are described in this reference document

You should check out the guide "Grouping Calculations"

regards,

H

[Former Member · Accepted solution]

Hi Henry,

Thanks for your reply.

With that I was able to create a calculated dimension that writes "urgent" if the value is so, and "other" if the value is something else.

But it seems not to be possible to write Integers (results in: HDB 01057), so that I am able to create a measure counting the occurrences of "urgent".

[Henry_Banks · Accepted solution]

Do you have a screenshot of that?

You might want to try using a "1" Else "0" flag and counting on that .

cheers,

H

[Former Member · Accepted solution]

Hi Henry,

thanks. The solution for me was to use "1" and "0". Afterwards converting the String-type dimension into a Number-type dimension. Then I was able to create a measure that sums up the dimension.

Best wishes

Marvin