Count dimension if aggregate count passes condition

daviddiener — Tue, 21 Dec 2021 21:56:36 GMT

Problem:

I want to create a single KPI with the count of the dimension SDTL_REFERENZ_NR if the aggr() count of two dimensions (SSL_TEIL_ID_NO_ZZZZ, EBEF_SSL_ID) is greater than 3.

What I have:

count( if( aggr(count({< FALL_REFERENZNUMMER = {""}, >} distinct SDTL_REFERENZ_NR), SSL_TEIL_ID_NO_ZZZZ, EBEF_SSL_ID) >= 3, SDTL_REFERENZ_NR))

The problem is, this funtion gives me the count of aggr() groups which meet the if condition. But I want to count the number of the dimension SDTL_REFERENZ_NR which are in the aggregated group.

Example:

If I put the dimensions SSL_TEIL_ID_NO_ZZZZ and EBEF_SSL_ID in a table and add a count on SDTL_REFERENZ_NR it gives me the values I want to count in the table. This should give me "8" as the result of my KPI. My current KPI gives me "2" because there are 2 aggregated rows.

topic Count dimension if aggregate count passes condition in App Development

Count dimension if aggregate count passes condition