# Count values for each User

**URL:** <https://community.glideapps.com/t/count-values-for-each-user/75948>\
**Category:** Ask for Help\
**Created:** [August 28, 2024, 3:00pm UTC](https://community.glideapps.com/t/count-values-for-each-user/75948 "2024-08-28T15:00:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Laura\_Taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/laura_taylor/32/79092_2.png) [@Laura\_Taylor](https://community.glideapps.com/u/Laura_Taylor)\
**Post date:** [August 28, 2024, 3:00pm UTC](https://community.glideapps.com/t/count-values-for-each-user/75948/1 "2024-08-28T15:00:24Z")

</div>

Hi (total begginer here), I have a table that tracks all of our projects and I have a column that has Project Status and a Project Manager (user) column. I would like to find out how many jobs for each project manager are in each status (Approved, In Progress, Finished). Ideally I want to create a radial chart that shows this but that’s a question for another time.

Thank you!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 28, 2024, 8:11pm UTC](https://community.glideapps.com/t/count-values-for-each-user/75948/2 "2024-08-28T20:11:00Z")

</div>

Well, you can use a query column to find all matching rows with the same Manager and Status, and then add a Rollup column to sum count the number of rows in the query.

There might be a little more to it though if your goal is a chart. In that case, the Query and Rollup may not be necessary. You would probably just need a template column linking the manager and status together, and then configure your chart to use that template column.