How to add Issue "Reporter" name to a list, and also add to criteria

[David Chainey]

I have an Analytics Dashboard, and I'm having trouble adding and working with the Jira [Reporter] field. I need to include [Reporter] Name in all my listings of Jira tickets and graphs and also use it in criteria for objects, graphs, etc.

However, when I edit and click "Issues," it's not included in the list of available fields. The closest I could get was the Reporter ID when expanding the schema.

[Tracy Chow]

Hi David,

User name data can be found in the "Account" table. https://support.atlassian.com/analytics/docs/schema-for-organization-data/ 

You can add the "Name" column from the "Account" table to get the reporter name. Just make sure that the join path is going through the "Reporter account ID" so that it's returning the reporter name, and not the assignee or creator name.

Let me know if this works for you.

Regards,
Tracy