How to create an eazyBI report to get the number of issues flagged by each team member

[GeoHan]

Hi all,

I am pretty new to eazyBI reports. I would like to create a report which shows the number of issues flagged as Impediment by each user.

I got a Dimension named 'Flagged'.

But when I create the above report, it shows the count of flagged issues against the user who created the issue, not against the one who flagged it.

Please help.

Thanks.

Geohan

[Martins Vanags -eazyBI-]

Hi Geo,

Indeed, when you use "Reporter" or "Assignee" user dimension in eazyBI, you would get the number of issues based on the user who is a currently reporter or assignee for an issue but not the one who has flagged it.

In this case, I believe you could ensure that you have imported issue change history and value changes for custom field "Flagged".

And then you could try defining a calculated custom Javascript field via eazyBI advanced settings that would go through the changelog and find the first user (or last) who flagged this issue.

Note that each issue can be flagged/unflagged more than 1 time

Please reach out to eazyBI team if you need help with the Javascript calculation.

Best regards,

Martins / eazyBI team

[GeoHan]

Thanks for the reply , Martins.

Could you please help me with the Javascript Calculation.

Thanks.

Hanna

[Martins Vanags -eazyBI-]

Hi,

Actually, you could try using "Transition Author" dimension to get a list of users and create a calculated measure in "Measures" dimension using the following code:

[Measures].[Transitions to]

"Transition Author" dimension is available when you import issue change history.

Best regards,

[GeoHan]

Thank you, Martin. It helped.

Regards,

Hanna