Hello,
I have a table that shows the list of all issues with the correct hierarchy and it is working fine, Now I want to create another version of the same report but only shows the “High” value records but keeping the same hierarchy view where I can expand, any help?
@Tamer
What is the name of this hierarchy in “Issue” dimension you use in report rows and how do you define your calcualted measure “Readiness Risk”?
Martins / eazyBI
Hi @martins.vanags,
Thanks for taking the time, I’m using the “Advanced Roadmap” hierarchy it is named “Site” which is the highest level.
the “Readiness Risk” is just a rename of the field “Risk”
Ok, then make sure you import “Risk” as a dimension.
https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JiraCustomFields
Then, create a new calcualted measure using this formula:
Count(
Filter(
Descendants([Issue.Advanced Roadmaps].CurrentMember),
(
[Measures].[Issues created],
[Risk].[High]
)>0
)
)
Select this measure and click on the column header for this measure to filter rows (Count of high risks > 0) as explained here:
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Orderandfilterrowsbymeasurevalues
It should count the High-risk issues created in the hierarchy below (if there is at least 1 - it will be displayed)
Martins / eazyBI
