Jira Project Name

How can I add the Jira project name into a column in an EazyBI report? I realize that I can parse data by dragging the Project dimension to the Pages, but I have a tabular report with issues from multiple projects and need to have a column just for the project name.

1 Like

Hi,

In this case, perhaps you could create a new calculated member in “Measures” dimension to return the name of selected/displayed project.
try this code when you create one:

[Project].CurrentHierarchyMember.Name

Martins / eazyBI support

Hi,

I’m trying exactly the same thing, but I can only get the Project Name IF only 1 project is selected:

1 project OK:

2 or more projects KO:

Measure used:

[Project].CurrentHierarchyMember.Name

Hi,

In the case when more than 1 project is select, you could use the following code:

CASE WHEN
[Project].CurrentHierarchyMember.Level.Name = "Project"
THEN
[Project].CurrentHierarchyMember.name
WHEN
[Project].CurrentHierarchyMember.Name = "AggregatePageMembers"
THEN
Settostr(ChildrenSet([Project].CurrentHierarchyMember))
END

It should work also when a single project is selected.

Best regards,

Thank you for your reply.

Couldn’t get exactly the expected result. It’s showing both projects name’s in the column:

Any idea why?

I would like to have: when ROW belongs to Project Contratação THEN project name = Contratação

Hi,

The apprach I shared earlier was very general to return the selected projects regardless of what is displayed in each rows as you didn’t provide more details to the use-case.

Try this code now:

CASE WHEN
[Sprint].CurrentHierarchyMember.Name <> "(no sprint)"

THEN
Nonemptystring(
Generate(
Filter(
[Project].[Project].Members,
[Measures].[Issues created] > 0
), 
[Project].CurrentHierarchyMember.Name, ', '
))
END

Best regards,

1 Like

That’s it! perfect:

ps: I wouldn’t reach this solution by myself only. many thanks!

Hi,
I want to display the project name to which the reporter belongs based on their fullname or username
name. How should I change your code? :grinning:Thank you so much!

@jingjing

Are you saying that each reporter’s lastname+fullname always matches a project name?
And there is just one project for each reporter?

Martins / eazyBI

Yes,a reporter only belongs to one project. I need to display each person’s project name in the “Project to which they belong” column, and I hope to filter the data based on “Project to which they belong”.

For example, I need to specify the project name of “Gao Jing” as Project A, and the project name of “Pan Yue” as Project B. The project name needs to be displayed in the “Project to which” column. And you can filter the table data according to the “belonging project”

@jingjing

Try this formula:

Nonemptystring(
Generate(
Filter(
[Project].[Project].Members,
[Measures].[Issues created] > 0
), 
[Project].CurrentHierarchyMember.Name, ', '
))

Martins / eazyBI

What is the logic of this code? How to determine the project a user belongs to? I want to specify the project names of certain users in the code instead of obtaining them through the system. How can I achieve this? And my user in rows is a custom calculated member. There is a space in the middle of the user name. If you use your code, an error will appear. The error message is as shown in the figure.

@jingjing
The code I shared must be used for new calculated measure
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures

From your screenshots It seems you are using it as calculated member for the dimension.

Martins / eazyBI

Thank you very much, after I use it in new calculated measure, the “所属项目” was obtained.

  1. What is the judgment logic of this code? How does it query the project that each person belongs to?
  2. How to turn “所属项目” into a filterable option in pages?

@martins.vanags
Sorry, could you please help me answer the above question? Our team is using eazyBI reporting and now we have encountered this problem. Thank you very much.

Hi @jingjing

The logic is to use “Issues created” measure to find the match in the “project” dimension by the project name.
If dimension in rows has just one project where issues are created for, this logic will know which project is that project and return it’s name in the calcualted measure.

And Here is how to filter report rows by a measure:
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Orderandfilterrowsbymeasurevalues

For urgent questions you can reach out to support@eazybi.com

Martins / eazyBI

@martins.vanags Thank you !
But "filter rows by measure values " can only be performed in “Analyze” and cannot be performed in “Dashboard”. Ordinary users only have dashboard viewer permissions,and they cannot filter.

Unfortunately, you can not move the “measure” as a page filter in eazyBI reports.

Martins / eazyBI