nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get issue "Assignee" as value in table

Ron_3f8dqx

I am attempting to get the "Assignee" value form the issue for each cell. (see After image below)

- Only 1 issue will be created for each project/component combination.

- Plan to use to link to issue details and use workflow for color coding status

Any help would greatly be appreciated...

Ron

Accepted answers

Martins Vanags_eazyBI

Hi,

Note that Issue Assignee is being imported as the property (out-of-box) in eazyBI which you should be able to select from "Measures" dimension for each issue.

I guess you would need first to import a separate dimension for "Component" as by default Component is one of the levels in "Project" dimension.

However, from screenshots, I assume that part is already covered.

Next, you could create a new calculated member in the "Measures" dimension.

Try this code:

CASE WHEN
[Measures].[Issues created]>0
THEN
[Assignee].[User].getMemberbyKey(
Filter(
Descendants([Assignee].CurrentHierarchyMember,[Assignee].[User]),
[Measures].[Issues created]>0
).item(0).Key
).Name
END

Martins / eazyBI Support

All comments

Nic Brough -Adaptavist-

This is not a Jira type display. Could you explain what tools you are using and how they connect to Jira?

Ron_3f8dqx

I am using Jira EazyBi tool and I am attempting to create a table report defining a calculated member to return the assignee for each Jira task.

Martins Vanags_eazyBI

Hi,

Note that Issue Assignee is being imported as the property (out-of-box) in eazyBI which you should be able to select from "Measures" dimension for each issue.

I guess you would need first to import a separate dimension for "Component" as by default Component is one of the levels in "Project" dimension.

However, from screenshots, I assume that part is already covered.

Next, you could create a new calculated member in the "Measures" dimension.

Try this code:

Martins / eazyBI Support

Ron_3f8dqx

Hi Martins,

That was exactly what I was looking for, but I neglected to mention I would like to have the ability to DrillDown/Through the associated issue. Is that possible with a calculated measure?

Ron

Martins Vanags_eazyBI

Hi,

Perhaps, you could use "Issue" dimension (project) level in rows, which could be expanded to issue level if needed.

See attached gif how to filter your report by measure "Issues created" before you add "component" dimension.

Martins

how to show issues.gif

Ron_3f8dqx

Hello, Is there a way to drill through the single issue by clicking on the assignee's name? Also, the data we have is pivoted with Rows = Label and columns = project component. The Project name will not work as it's @ a higher level.

Any more thoughts/suggestions?

Appreciate the feedback !!

Ron

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server