I am currently searching for an opportunity to display two filtered KPIs stacked on each other.
I have already found out about the stacking function.
Now I am struggling with counting the cases filtered within the formular.
I tried something like COUNT_TABLE(“Table1”(CASE WHEN “Table1”.“Filter_Column” = ‘Filter_Word’ THEN 1 ELSE 0 END)
I also tried it with the simple COUNT function as well.
Both do not work, respectively give the intended result (Count Table does not work, Count simply gives a number for every occurence of that criterion)
But what I want is the number of cases where that exact criterion is true.
As a background, my filter criterion is always valid for the whole case, so if one activity of a case has that criterion, every activity of that case will have it.
It actually seems so simple, but I just don´t get it right.
I am very thankful for your help.