Adding additional filter based on a custom field value

[Horacio Escalada]

Using the Jira - Simple Project Overview I added a dropdown to filter results. 
I need one of the charts to return results filtered by the value selected.
Drop down uses values available on a custom field "Group of Agents" that is basically similar to Team names such as Infrastructure, Security, etc

Any help appreciated

[Mohsin Shaikh]

Hello @Horacio Escalada

To achieve what you described—filtering a chart in Atlassian Analytics by a dropdown based on your custom field "Group of Agents"—here’s a step-by-step approach:

---

How to Filter a Chart by a Custom Field Dropdown in Atlassian Analytics

1. Add a Dropdown Control for Your Custom Field

   • Go to your dashboard and select Control > Dropdown.

   • In the control editor, search for your custom field ("Group of Agents") in the Issue custom fields table.

   • Add this field as a column in your query.

   • If your custom field can have multiple values (array), use the ‘Explode’ Group function to ensure each value appears individually in the dropdown.

   • Run the query and configure the dropdown settings as needed.

   • Save the dropdown control to your dashboard.

2. Connect the Dropdown to Your Chart

   • Edit the chart you want to filter.

   • Add a filter step where the chart’s data is filtered by the value selected in your dropdown control. For example, filter where Group of Agents = {DROPDOWN_NAME} (replace {DROPDOWN_NAME} with your actual control name).

   • Save your changes.

3. Result

   • Now, when you select a value (e.g., "Infrastructure" or "Security") from the dropdown, the chart will update to show only results matching that group.

---

Tips:

• If your custom field is not showing up, make sure it’s available in the “Issue custom fields” table and that you have the correct permissions.

• For more advanced scenarios (like key-value pairs or array fields), refer to the official documentation for Create "Dropdown" control from an array custom field in Atlassian Analytics.