Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to get a count of single select options

359 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

3 Replies 3

Hi @jterrell

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

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.

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

image