Hello here!
Thank you again for EazyBi development!
I have a table showing how many Epics I have in each initiative.
Now, i would like to count how many rows for each value…
For example with this image, i would like to have a new table showing :
7 epics : 1
5 epics : 1
4 epics : 1
3 epics : 2
2 epics : 8
Is it possible? I don’t know how to do that…
Thank you very much!
Olivier
Hi @obillaud ,
There is no elegant solution for this use-case to count initiatives by the count of children epics and show them dynamically in report.
The closest workaround I can imagine is creating one new calculated measure for each “bucket”.
For example, this would be the formula for “Initiatives with 7 epics”:
Sum(
Filter(
DescendantsSet([Issue.Advanced Roadmaps].CurrentMember,[Issue.Advanced Roadmaps].[Initiative]),
Count(
Childrenset([Issue.Advanced Roadmaps].CurrentMember)
) = 7 --count of epics
),
CASE WHEN
[Measures].[Issues created]>0
THEN
1
END
)
As soon as there is new epic for an initiative it will go to next bucket which you have to create as calculated measure in the report to count the initiative corretly in the report.
Then use “All issues” from Issue.Advanced Roadmaps hierarchy in report rows as the only row in the report and select all measures in columns.
Finally, switch to chart view and show them as measures
The challenge with this workaround you need to know in advanced how many and what buckets there will be to create one calculated measure for each bucket.
Martins / eazyBI
Hello @martins.vanags !
Thank you very much for your answer. I like this workaround… I thought about a solution like that but I have no enough skills with EazyBi to complete it without your help.
So thank you very much again!!
Two things, if you can help me again:
Sum(
Filter(
DescendantsSet([Issue.Advanced Roadmaps].CurrentMember,[Issue.Advanced Roadmaps].[Initiative]),
Count(
Childrenset([Issue.Advanced Roadmaps].CurrentMember)
) > 7 --count of epics
),
CASE WHEN
[Measures].[Issues created]>0
THEN
1
END
)
It always return me “1”… It seems a row called (none) returns this rest… but I don’t know why.
Can you explain me how to ignore this value?
Thank you very much!
Have a nice day,
Olivier
Try creating a new report with “Issue. Advanced Roadmaps” in rows (expanded) and “Issues created” measure in columns
Do you see that hierarchy correctly groups issues by initiatives? Or is it all issues created under “(none)” member at initiative level from the hierarchy?
Martins / eazyBI support
Oh ok, I understood.
I have in the same project : initiative>Epic>tasks and another hierarchy beginning in epic level with “DCH”>tasks. I just added issue type in “pages” to filter only on initiatives and it’s perfect now.
Thank you Martin!
I’m happy to work with EazyBi and your support!
