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!
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.