Hi
I need to see the email for person (reporter or assignee) in every tickets.
For example,
Reporter | email
Marcelo Cid | marcelo.cid@example.com
Hi,
when using eazyBI for Jira Datacenter or Jira Server, the Email property is imported by default in eazyBI for all standard user dimensions - Reporter, Logged By, Assignee, Transition Author.
Create a new calculated measure using this code:
[Reporter].CurrentMember.get('Email')
Then use this measure with Reporter dimension members at the user level.
The same approach with the other 3 user dimensions.
However, the same won’t work when using eazyBI for Jira Cloud because of GDPR restrictions in Jira.
In Cloud infrastructure, user email is not returned in issue JSON, and eazyBI can’t import it automatically.
In this scenario, you would need to import additional data as properties to user dimension members in this case.
Martins / eazyBi
Hi @martins.vanags Thanks for answer.
I created a automation that copy email when a issue is update.
The measure is [Issue].CurrentHierarchyMember.get(‘Email’)
Is there a way (through what I told you) to generate something similar to the table you attached (I’m in the cloud)
Please share more details about the automation.
How exactly does it work? Does it return the email from “Reporter” user on the issuescreen somehow?
Martins / eazyBI
After you import “Email” field there should be a way to find the first issue for each reporter and then extract the “Email value” from it to link it with Reporter dimension member name.
What will be the layout for your final report? Will you use “Reporter” dimenion in report rows?
Martins
Try this formula for custom calculation, that should return the first issue for reporter and return the email from it
CASE WHEN
[Measures].[Issues created]>0
THEN
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Issues created]>0
AND
CoalesceEmpty([Measures].[Issue reporter],"") = [Reporter].CurrentMember.name
).item(0).get('Email')
END
Martins / eazyBI