I have defined three calculated measures:
- one that calculates the amount of bugs found in testing phase A
- one that calculates the amount of bugs found in testing phases B and C
- one that calculates the percentage of A/(A+B+C)
This all works fine and I can create a combined bar and line chart to show those.
Now I would need to be able to let a report viewer to select if they would like to see those numbers from all bugs or only from bugs that don’t have certain root causes. The bug root cause is a custom field that I have imported to eazyBI as a dimension and property.
I have created a calculated measure using aggregate, except and filter functions to get those issues but I don’t know how I could use that as a “filter” to apply to the current rows. The rows have time as a dimension and pages currently have projects (as I want the report uses also to select the Jira project(s) they would like to see the data from).
Not sure if my approach even creating the calculated measure is the correct one to solve this issue.
Is there a way to do this or should I just create two totally separate reports so that one shows data from all bugs and another from the bugs without certain root causes.