How to get issue "Assignee" as value in table

[Ron]

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

[Martins Vanags -eazyBI- · Accepted solution]

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 

[Ron]

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

[Ron]

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

[Martins Vanags -eazyBI-]

Hi,

you could use "drill through issue" feature in eazyBI to drill through the single issue by clicking on the measure in the report if "Assignee" dimension member is used in report context. See attached gif.

And you can use Javascript to calculate a new custom field via eazyBI advanced settings and then create a new separate dimension for "Components"

But before you create a new dimension, perhaps it is worth to read the following community post: https://community.eazybi.com/t/create-a-list-of-projects-without-component/1109

Martins / support@eazybi.com

[Ron]

Hello Martins,   Really appreciate the suggestions/efforts...but not what we're looking for. Please see a little more detail below as to what are goal is.  Thanks Much, Ron

We are attempting to get all of the Project/Component assignees (aka. project owners) for each single issue to display on the screen 'all at once' with color coding (Red, Yellow, Green) to indicate health of project.  We plan to put the chart on a touch screen television sitting in each department for management walk up and/or review during stand up meetings.    We are up for suggestions if the 'After' image above cannot be created, but we want to make the clicks minimal and show the project status for all projects in one shot.....

Note: We've had success with the UI using other BI tools, but we want the drill into issue capability from Jira/EasyBI real time and not from external tool using URL.  We've experimented with the Kanban board, but it didn't react as expected.

[Martins Vanags -eazyBI-]

Hi Ron,

Perhaps, you could reach out to support@eazybi.com and share the example of your "after" layout and more details on this use-case.

For example, how do you expect to filter the report or what would you put in rows, columns, pages and also how do you define colors for project health?

Martins / support@ezybi.com

[Ron]

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. 

[Nic Brough -Adaptavist-]

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