I need to generate a bug report per fix versions and for the epics which are under the particular fix version only

I need to generate a bug report for the epics under a fix version. There are other bugs from different epics from earlier fix versions which needs to be avoided. When I try to group the bugs per fix versions and then epics, the report shows all the epics from previous versions as well.

Can someone please help?

Hi @rikashyap

Welcome to eazyBI community.

Try using issue link field dimensions to import Epic Fix version as separate dimension

Martins / eazyBI

Thank you so much. I could get my output with this approach.

Hi @martins.vanags,

I am in much better shape for my report now. In the next step, I wanted to count number of stories under an epic excluding few stories based on a “string/word” in the story title. I am quite new to eazyBI. Can I get some help here?

Filtering by substring in the issue title would be a very slow query. A faster approach would be using some boolean or single-select custom fields to exclude issues from the report.

Anyway, If this logic of yours will be used across multiple reports (filtering based on your string/word) perhaps you can import a precalculated field as a separate dimension and use it as a page filter in the report.

See some examples of precalculated field dimensions here:

If you want to exclude these stories in all reports in the account, perhaps you can use a JQL filter in the eazyBI import options and not import these stories in the eazyBI at all

But of course, you can try also the MDX approach
It will be slow depending on the number of imported issues.
Try creating a new calculate measure using this approach:

NOT [Issue].CurrentMember.name matches ".*word.*"
[Measures].[Issues created]>0

When selecting this measure in the report, make sure you enable the “Nonempty” cross join for report rows.

Martins / eazyBI

Thank you for the options. I did end up writing a complex MDX measures and it worked. But I will try to create a dimension or exclude such stories while importing.

I also tried to publish the report to a confluence page using public access token but I get below error. Not sure where have I gone wrong

You do not have access to this dashboard.
Please log in to eazyBI and then refresh this page.

@rikashyap please follow steps described here:

If that is not the way how you published, please reach out to eazyBI support and share more details on steps you did.

Martins / eazyBI