'Unassigned' issue types not appearing in results

[Christopher Vickery]

Hi all,

I've created a filter in Atlassian Analytics that picks up any issue types that contain a particular label. The table shows the name of the Assignee and the number of issues types assigned to them per status. 

Everything seems fine but I've noticed the filter doesn't pick up any issue types that are 'unassigned'. 

Does anyone know what the issue is?

I've marked out the names but the 'unassigned' value does not appear.

Thanks,

Chris

[Arumugam M · Accepted solution]

Hey @Christopher Vickery , 

Thank you for posting your question. This is Arumugam from Atlassian Support, happy to help!

I understand that you are expecting "Unassigned" tickets to be returned for the selected join path. 

I'm assuming the join path selected for the above provided screenshot is "Assignee ID" from "jira_issue" table with "Account ID" in the "account" table. 

As you may aware of that we don't have an entry called "Unassinged" in the "Account" table and by default the Visual SQL does a INNER JOIN so the null values are filtered out. 

So either you can switch to SQL mode and manually update the join methods and do grouping. 

If you would prefer to have visual mode, then you can add a subquery and filter just the issues which are unassigned and do a UNION join. 

I'm attaching a sample of how I've built the query on my end here for your reference:

And here are the results for the above setup:

I hope this helps. If you are encountering any issues or have questions, please feel free to reach out to us. 

Thanks, 

Arumugam

[Christopher Vickery]

Hi Arumugam,

Thank you for the detailed response. Everything you've suggested worked perfectly :)

Thanks again.

Chris