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.
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,
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