Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
1. count (distinct Item)
2. count ({<Status={1}>} distinct Item)
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.