Help with translating text values into numeric values for graphs

Bree Taylor

Hello!

I'm trying to create three (3) graphs with data we're keeping in a Sheet to go onto a Dashboard. There are 3 Teams that will each be one of the graphs, and then the data comes from a dropdown column and each option will be a bar on the graph. I'm having a hard time separating the data first by team and then second by drop down option. These are the two functions I thought would work and have been trying but are all unparsable. What am I missing? For context, Alpha and Bravo are team names. The Parking Lot is one of the Project Statuses. Thank you for your help!

=COUNTM({Active Projects_Master Range 1}) - COUNTIF([{Team}]@row, HAS (@cell, "Alpha"))

=COUNT(COLLECT({Team} "Bravo", {Project Status}, "Parking Lot", Bravo$1, $Label@row))

Paul Newcome

Are you able to provide some screenshots for context?

Bree Taylor

Hi Paul,

Yes so we want to take the data that is in "Project Status" and split it into three different graphs by "Team" and have it create the example chart from Excel that shows where the project status.

Paul Newcome

If you are doing separate graphs for each team, my suggestion would be a row report filtered by team and then grouped by status. Once you apply the summary within the report to the Status column, you can use the report to create your chart. Rinse and repeat for the other teams, and you should be all set.

Bree Taylor

Ahhh okay thank you! That would be much easier!

Paul Newcome

Happy to help. 👍️