How to show linked issue status in an eazy bi with formula in JIra cLoud?

[thumuluru_shreya]

How to show linked issue status in an eazy bi with formula in JIra cLoud?

[Valerie Knapp]

Hi @thumuluru_shreya , thanks for your question. 

I tagged it with the app eazybi. Please can you show what you are trying to achieve? You have a dashboard with an eazybi report where you want to surface the status of a linked issue to one of the issues displayed in the eazybi report? 

Have you already checked the product documentation here? https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/issue-link-field-dimensions 

You can also reach out to the vendor directly to ask questions here https://marketplace.atlassian.com/apps/1211051/eazybi-reports-and-charts-for-jira 

I hope this helps you. 

Best wishes

[Roberts Čāčus]

Hi @thumuluru_shreya

The first step is defining the issue link in eazyBI - https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/import-issue-links.

After that, you can define a new calculated measure to retrieve the linked issue status. The linked issues must also be imported for eazyBI to be able to retrieve their status. See an example on the eazyBI Demo training account - https://eazybi.com/accounts/22010/cubes/Issues/reports/376217-story-and-bug-overview-by-projects. The report has the calculated measure "Issue bugs with status", returning the linked issue key and its status.

Please look at our documentation page for more information on defining calculated measures - ​https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures.

Best,
Roberts // support@eazybi.com

[thumuluru_shreya]

@Roberts Čāčus , How can I find the status Id and in place of status I wrote status name in that case its showing linked issue only for status showing Null by using this code. Could you please help me in this

Thanks

[Roberts Čāčus]

@thumuluru_shreya, the status can't be retrieved if the linked issue is not imported into eazyBI. Please make sure the linked issue is also imported into eazyBI - https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-Selectapplicationimportoptions.

Best,
Roberts // support@eazybi.com