Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I am looking for a way to list distinct data points on a user and then show it in groups after.
Example is a I have an email, name, zip code, and birthday for Bob. That would be 4 data points. We only have Susan's Name and Birthday so that's only 2 data points.
Then I could also do a sum of people with 2 data points and so on.
The data would be null in the fields if there isn't any collected yet for that person.
A table simplified like this for example:
user | name | zipcode | birthday | |
BobD | Bob Kelly | Bob@Kelly.com | 90210 | 12/12/2001 |
Susan O | Susan Oleade | Susan@O.com | ||
DaveC | Dave Clarke | 10001 |
I never tested this with a key field, but that could be the issue. This expression isn't my own creation, so have not tested it fully. Is there any other field you can use which you know would not be null and will always be available?