Depends. If you can use it with a component filter, then it will be FILTER COUNT(DISTINCT "OCH_Cases". "Party_Request_KEY") > 2
If you want to use it as a KPI or Dimension like in a OLAP and you can't use a filter, then a CASE WHEN will do
CASE WHEN COUNT(DISTINCT "OCH_Cases". "Party_Request_KEY") > 2 then COUNT(DISTINCT "OCH_Cases". "Party_Request_KEY") else 0 END (or something like that)
HTH
Thank you for your answer.
Unfortunately, the component filter does not work.
I get the following error:
The aggregation function COUNT cannot be used inside a filter statement. Please check that there are no aggregations used inside filters. Please use a Pull-Up-function instead.
The second formula works very well
Thank you for your answer.
Unfortunately, the component filter does not work.
I get the following error:
The aggregation function COUNT cannot be used inside a filter statement. Please check that there are no aggregations used inside filters. Please use a Pull-Up-function instead.
The second formula works very well
Yes, my bad. In that case you can try the CASE WHEN path, or use PU functions.
What should the formula look like with the PU function?
With "Case When", all the results are still displayed, but they are, for example, calculated with "0". I want all results where >2 are not displayed.
What should the formula look like with the PU function?
With "Case When", all the results are still displayed, but they are, for example, calculated with "0". I want all results where >2 are not displayed.
Depends a bit on details, your model, what you want to measure... but, I guess:
PU_COUNT_DISTINCT(DOMAIN_TABLE(OCH_CASES._CASE_KEY), "OCH_Cases". "Party_Request_KEY")
BTW with the CASE WHEN this can work for you:
CASE
WHEN
COUNT(DISTINCT "OCH_Cases". "Party_Request_KEY") > 2
then COUNT(DISTINCT "OCH_Cases". "Party_Request_KEY")
ELSE NULL
END