We recently migrated to the cloud, and we have a report that shows the status of Epics. The report works fine, but the users want to exclude completed Epics from the report.
Hello @briantaylor,
Thanks for posting your question!
You can achieve this by creating a new calculated measure following the formula below:
([Measures].[Issues created],
[Status.Category].[Done]) =
([Measures].[Issues created],
[Status.Category].DefaultMember)
This formula checks if the number of Issues in Status Category “Done” matches the number of issues created and returns true/false statement.
Once this has been done, you can click on “Done” status header under “Filter measure” and select “filter rows” → “matches” → false
Once the filter has been applied, you can left-click on the “Filter measure” and select to “remove” it from your report. The applied filter will still work.
Switch to Bar chart & you should be able to see report that only shows epics that are not yet completed.
I hope this helps!
Best,
Marita // support@eazybi.com
1 Like