Distinct count with conditional function

Q&A
,
1

Hi All,
We have below use case where we need to get distinct count based on a condition.
Input table:
name ; status
abc ; complete
abc ; incomplete
abc ; complete
cde ; incomplete
def ; complete

output table: (app name with atleast one ‘incomplete’ status should be counted as one.
status ; name_count
incomplete ; 2
complete ; 1
can you help us with the calculated filed expression for this.
Thanks,

2

Hey @varun786 ,

could you provide some demo tables - how your data looks like and what you want as a result?
Maybe as a screenshot or in Arena.
That would be really helpfull.

BR
Robert

3

Hi Robert,
Thanks for the reply.
Attaching the screenshot with sample data.
Any name with atleast one ‘Incomplete’ status should be treated as ‘Incomplete’. With this condition, we need the distinct names by status.

distinct count
distinct count859×233 35.4 KB

.

4

distinct_countIf({name}, {status} = ‘Incomplete’)

5

Thanks for the response Deepa.
Is there a way to include derived table logic also in the same calculated field expression.
We need to achieve derived table condition and distinct count(expected output) in one calculated field expression.

6

You can try using firstValue() to get the status column in the derived table.