Aggregation function together with a dimension function input.

Question

Sum(CASE WHEN "ActivityTable"."Activity" = 'something'

THEN 1.0 ELSE NULL END) gives me the count when there is an entry "something" in the table.

My challange is following:

I need to count Distinct Case_ID, whenever "something" happens. It can happen more than 1 time for an Case_ID, so i need a PQL statement like:

CASE WHEN "ActivityTable"."Activity" = 'something'

THEN count (Distinct(Case_ID) ELSE NULL END, which is ofcourse not working like this.

Ideas and solutions are welcome. Thanks a lot

Page 1 / 1

Not sure if it is the same but:

COUNT(DISTINCT

CASE WHEN PROCESS EQUALS activity THEN _CASE_KEY

ELSE NULL

END

)

works for some similar situations.

HTH

Works like a charm...thanks a lot😀

guillermo.gost12 · Accepted Answer

Not sure if it is the same but:COUNT(DISTINCT CASE WHEN PROCESS EQUALS activity THEN _CASE_KEYELSE NULLEND)works for some similar situations.HTH

himanshu.sharm16 · Answer

Works like a charm...thanks a lot&#128512;

Sign up