Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Name | Date | Value | ID |
A | 1/1/2017 | 0 | Ax |
A | 1/1/2017 | 0 | Ay |
A | 1/1/2017 | 1 | Az |
B | 1/1/2017 | 0 | Bx |
B | 1/1/2017 | 1 | By |
B | 1/2/2017 | 0 | Bz |
The Count of Value should give me 5 (0 for A (1/1/2017), 1 for A (1/1/2017), 0 for B (1/1/2017), 1 for B (1/1/2017), 0 for B (1/2/2017) |
May be this -
Count(Aggr(Count(Distinct Value),Name))
Or this
Count(DISTINCT Name&Date&Value)
Thank you Digvijay. That was really helpful.
Thanks stalwar1 That helped.