Adding Assignee Field to the Table

[Jakob Hernandez]

The data source that was added to connect to doesn't have the Assignee field there without having to do extra configurations on a separate Google Spreadsheet. 

What are the steps to get a column for the Assignee field to view who is assigned that issue on the table when added to an Atlassian Analytics dashboard? 

(Asking here as it seems each time it's there and the next day it's not - curious how to build that string if it's not already there and was before) 

[Jessie Turpin]

Hi Jakob, 

To find the assignee of an issue, you can use the Assignee account ID column from the Issue table. Note that if your organization is a managed account, the Account table in the Atlassian Data Lake will have the user's names as well. Then including the Name column from the Account table would let you see the assignee's by name instead of by account ID. You can use the "Top 5 assignees by open issue count" chart template to get an idea of how to query the assignees by name in Atlassian Analytics. 

Let us know if you have any additional questions. 

[Jake]

Hi Jessie, 

Thanks! I'll give that a try and let you know. 

Best, 
Jakob