Please Help Count/Distinct Count

[#1]

Hi,

I have a table with two columns (see below)

Item	Status
123	0
123	0
32	1
12	1
12	1
1	0

I need to calculate the total number of distinct items and also calculate total number of completed Distinct items (Status = 1)

eventually i need a percentage representation.

Please help me figure this requirement. Thank you for your time and help.

Best,

Nik

[Anonymous · Accepted solution]

1. count (distinct Item)

2. count ({<Status={1}>} distinct Item)

[#3]

Hi Michael,

Thank you, I kept trying different variations of the 2nd option. Wasnt aware that we can have different fields.

Does {<Status = {1}>} act as a conditional if?

Thanks again for your time.