Multi-Count Query to power Dashboard Chart

Kidd_Ip I use the Azure DevOps ticketing system to manage and track an Agile development backlog. I have added some custom fields to the Epic ticket/issue type, and I would like to create a dashboard within the tool to show how many epics are tagged with each attribute in either a pie or bar chart. This is the first time I have used DevOps; I have a lot more experience with JIRA, so from watching YouTube and AI tools, I can successfully create a query to count an individual value with the DevOps query, but I cannot count all.

I have posted the instructions that ChatGTP supplied, but I have been unable to get it to work to count multiple Values:

Step 1: Create a Query to List All Items with Tactics

1. Open Azure DevOps and Navigate to Boards:

   • Go to your Azure DevOps project.
   • Select "Boards" from the left-hand navigation panel.
   • Click on "Queries."

2. Create a New Query:

   • Click on the "New Query" button.

3. Set the Query Conditions:

   • In the "Query Editor," add the necessary conditions to filter work items with the Tactics field.
     • Add a new clause: Work Item Type = [Type] (Choose the relevant work item type, e.g., Epic, Task, User Story).
     • Add another clause: Facet1 Contains [SomeTacticValue] (Since multi-select fields might require specific values to be checked, start by checking for any specific value you know exists).

4. Add a Column for Tactics:

   • Click on "Column options" to customize the columns displayed in the query results.
   • Add the "Facet1" field to the displayed columns.

5. Save the Query:

   • Click on the "Save Query" button.
   • Provide a name for your query and save it in an appropriate folder.

6. Run the Query:

   • Click on "Run Query" to execute the query.