Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Adding Assignee Field to the Table

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) 



1 answer

0 votes
Jessie Turpin
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Nov 13, 2023

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. 

Hi Jessie, 

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




Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events