Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
I want to create a KPI which should first check a field of one column and if the condition applies count the rows of an other column.
I went with the following:
count (if([FIELD_NAME]="EXPRESSION"), distinct [COLUMN_NAME])
I tried several other ways but nothing worked yet. Any suggestions? Thanks in advance!
something similar
count(distinct{<FIELD_NAME ={"EXPRESSION"}>} [COLUMN_NAME])
or
sum(if([FIELD_NAME]="EXPRESSION",1,0))