How to select from custom field group

[Sharos Pillai]

Hi there, I have custom field group which is a Group Picker (single group).  There are lots of groups in them.  I want to select all issues related to the following groups, Macro.Test1, Micro.Test2 and Major.Test3. I want the chart to display the results based on the groups. 

Macro.Test1 - number of issues linked to this group

Micro.Test2 - number of issues linked to this group

Major.Test3 - number of issues linked to this group

What is the best sql or visual to do this in Analytics?

Thanks

SP

[Mohsin Shaikh]

Hello @Sharos Pillai

I hope you are doing well.

You can use the following SQL in Atlassian Analytics (replace the field/table names as needed):

SELECT
group_picker_field AS group_name,
COUNT(*) AS issue_count
FROM
jira_issues
WHERE
group_picker_field IN ('Macro.Test1', 'Micro.Test2', 'Major.Test3')
GROUP BY
group_picker_field
ORDER BY
group_picker_field

Then, visualize the results as a Bar Chart or Column Chart to display the number of issues per group.

I hope this helps.

Best regards,
Mohsin Shaikh
ATLASSIAN | Cloud Senior Support Engineer