Adding Assignee Field to the Table

Question

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 · Answer

Hey Andrew! It's hard to say what may be going wrong without getting to look at the code used to create the chart and the SQL you were using for the custom table. Could you create a support ticket with the team so we can investigate this further for you? Thanks!

Furlong, Andrew · Answer

Hey Jessie! I'm using the correct join path between Assignee account ID and Account ID. When I ran the same query within a chart (as compared to when I was building a custom table earlier) I was able to get the correct results. Do you have any idea why it wouldn't have worked when I tried to save the results to a custom table?

Jessie Turpin · Answer

Hi Andrew! Could you check that the join path is using the Assignee account ID column to connect the Issue and Account tables? The path highlighted in blue is the current join path used by the query.

It's possible that your query may be using the Creator or Reporter account ID instead, which could explain the incorrect names. If an incorrect join path is used, just click on the line using the Assignee account ID column to connect the two tables and re-run the query to help the join path update.

If the query is using the Assignee account ID column in the join path, you can create a support ticket with our team to help us troubleshoot further.