Calculated measure to filter tasks based on the status of a linked issue

Questions & Answers
, , , ,
1

Hello there,

I am fairly new to eazyBI.

I am trying to create a report that shows task status over time. But i only want to show tasks that are linked to features in status “Verification“

How would one go about this?

Thanks and Regards

Divya

2

Hi @divya.s,

A warm welcome to the eazyBI community :tada: !

You have several options to filter issues by their linked issue status. The two options I suggest both require you first to define and import the issue link. See the eazyBI documentation page on how to achieve that - https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/import-issue-links.

The first approach is when you have the individual tasks as the Issue dimension members in the report rows. Then you can define new calculated measures to return the linked issues and their status or the count of linked issues by statuses. See both examples in our demo training account regarding stories and bugs linked to them:

Another option is defining an issue link field dimension based on the linked issue status. See more details on that here - Issue link field dimensions. The last example in this documentation page, Feature label, shows a similar example to yours. Replace source dimension and name from Label to Status. After a data import, you can use the new dimension to filter issues by the linked issue status.

Best,
Roberts // support@eazybi.com