developer , reviewer 1, reviewer 2 and tester

[CESAR DALDOSSO]

I have an automation that feeds some multi picker user fields : developer, reviewer 1,reviewer 2 and tester . These fields are automatically fed by an automation , that feeds this fields depending on the user that changed the status.

Now I want to have some measures like who many items an user worked on (develop, test, reviews) .

These fields (developer, reviewer 1, reviewer2 , tester) collects the accound id , so how can I show their names  ?

[Samuel Ng]

Hi Cesar, 

You can do an inner join with the "account" table on the "account_id" column from the Atlassian Data Lake, and fetch the corresponding names from the "name" column. Please see the "Schema for organization data" for more details.