Display email for person

Questions & Answers
, , , ,
1

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

2

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.

image
image1920×1156 104 KB

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

3

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)

4

@Marcelo_Ignacio_Cid1

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

5

Hi @martins.vanags

That is automation:
image

And Json is

image

6

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

7

@martins.vanags Like this

image

8

Hi @martins.vanags any update ?

9

@Marcelo_Ignacio_Cid1

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