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
1 Like
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,
1 Like
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
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? 
Thank you so muchļ¼
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ā
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.
- What is the judgment logic of this code? How does it query the project that each person belongs to?
- 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
@martins.vanags Thank you ļ¼ This code is greatļ¼
I want to be more perfect. If a person belongs to 3 projects, I donāt want to display the names of these 3 projects. As long as he belongs to one or more of these 3 projects, I want to name them name1. How can I modify that code?
@jingjing
How eazyBI can know which (one of 3) project to show if a person belong to 3 project?
Is there any sequence of projects do you want to use? If so, what defines this sequence?
Martins / eazyBI