How to get a count of single select options

[jterrell]

I have a view set up to group a user with the a single select tag. I’d like to find out the count of each tag for a user. Can’t figure out how to make this happen so I can link it to a chart.

Ex. use case:

User 1 has 4 items attached to them with 3 tagged as new and 1 as old. I want to total account of the tags with it still being associated to the user.

Any help is appreciated.

[Databaser]

Hi @jterrell

Did you try to create an extra table for the tags and use a Linked Record field with a Count field?

[jterrell]

Yes. But it only gave me the overall count of the tag. I couldn’t figure out how to break it down to the user level.

[Databaser]

Depending on the number of users, you can make a Count field per user and make it conditional.