Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,558,787
Community Members
 
Community Events
184
Community Groups

How to address rows in eazyBI

Hey,

I would like to display values in the row of a project but I don't know how to address the project row. I use Project as pages but I assume it is still a dimension? Thanks in advance.

 

Screenshot 2023-04-05 130351.png

2 answers

Hi @Onur Cevik 

Thank you for following up with us! 

Could you please export and share the definition for your eazyBI report?
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports/export-and-import-report-definitions
Please send it to support@eazybi.com, and we will continue helping you with your use case through our support email.

It will be easier to help you once I see the report definition. 

Best wishes,

Elita from support@eazybi.com

Hey @elita_kalane ,

I have sent you the definition. Thanks for helping further.

Hi @Onur Cevik ,

I am Elita from eazyBI support team. 

Thanks for sharing your use case!
I recommend removing the Issue dimension from Rows and dragging the Project dimension to your Rows. Once you have added Project dimension to your Rows, enable the "Pages" button to also add Project dimension to Pages (to allow report filtering by Projects). 

You might find the documentation here https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Pagedimensions useful to learn about Page dimensions.
Issues-Sandbox-v3-eazyBI_Page_dimension.png

Best wishes,
Elita from support@eazybi.com


@elita_kalane,

Thanks a lot Elita. Another question. How to get the issues of each project as dropdown? Marked in the picture belowScreenshot 2023-04-06 112357.png

Extend dimension by their hierarchy level members. Extend dimension project by dimension issues as their hierarchy level members.

@elita_kalane
Im close to my desired state as you can see in the picture below. But I don´t know how to remove the 1) column which belongs to dimension project on the left. Otherwise the 1) column is necessary as dimension for my calculated members. Screenshot 2023-04-06 115610.png

Hi @Onur Cevik 
​Thank you for following up and for sending the screenshots!
​In that case, I suggest moving Issues back to Rows and selecting Project level (that will allow you to expand to the issue level as well). 
​Since you have some project-related formulas in your report, you could get the required details with the following calculated measure (the example below is for returning the Projektstatus. Similarly, you could get other properties of the project by changing the last part in the formula and replacing "Projektstatus" with necessary project properties.  

[Project].[Project].GetMemberByKey
([Issue].CurrentHierarchyMember.Get('Project key'))
.Get('Projektstatus')

​​Best wishes,

​Elita from support@eazybi.com

Hi @Onur Cevik 
​Thank you for following up and for sending the screenshots!
​In that case, I suggest moving Issues back to Rows and selecting Project level (that will allow you to expand to the issue level as well). 
​Since you have some project-related formulas in your report, you could get the required details with the following calculated measure (the example below is for returning the Projektstatus. Similarly, you could get other properties of the project by changing the last part in the formula and replacing "Projektstatus" with necessary project properties. 

[Project].[Project].GetMemberByKey
([Issue].CurrentHierarchyMember.Get('Project key'))
.Get('Projektstatus')

​Best wishes,

​Elita from support@eazybi.com

Hey @elita_kalane ,

Thanks for helping. I have tried it but it doens´t work. The column Projektstatus depends to the column Ampeldarstellung Zeit. Another calculated measures counts every green, orange and red cells in the column Ampeldarstellung Zeit and Projektstatus displays 'Project off track' if amount red status divided by amount issues created if bigger than 0.1 else Project on track. When dimension Project disappears the status in row of project name disappears as well. I hope you can follow me. Pictures attached. Screenshot 2023-04-13 104146.pngScreenshot 2023-04-13 104709.png

Hey @elita_kalane 

Otherwise it could work if I change the code. In the post above you can see in line three, that the issue name has to match with the project name. If I replace the code after the equal sign with the name of the project my disered configuration works. How to code after the equal sign to get automatically the project name? In the picture below you can see if I write the name of the project the issue above works. Screenshot 2023-04-13 105704.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events