Creating a Table view using column values off another column

[Andrew Bui]

I'm looking to output a display via our rich filter dashboard that requires a column that displays a field from another column, that is not the key.

I have the following data structure:


ProjectB-123
is unique related to:
ProjectA-456
and ProjectA-456 has versions = 1.0.0, 1.0.1, 1.0.2

My table should be:
ProjectB-123 | ProjectA-456 | 1.0.0, 1.0.1, 1.0.2

I'm having trouble getting the second column in jira rich filters, but was able to get it in jxl. In my rich filter dashboard, I can only show "all linked issues". I cannot seem to get the third column which is a field based off of the "linkedissue" column.

I'm open to exploring jxl and potentially eazyBI. Thank you!

[Marita Norvele]

Hi @Andrew Bui

If Project A and Project B are Issues in Jira that are linked using issue links, you can create a report showing the linked issues and their fix versions in eazyBI. Here's how:

• Import issue links: https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/import-issue-links
• add issue Linked issue dimension in Rows, select "linked issue" level member. In my example below, I am using Linked issue dimension called "Blocks"
• add Issue dimension in Rows, select "issue" level member.
• select "issues created" and "Issue fix versions" under Measures

This report shows which Issues (column 1) are blocking other issues (column 2) and what are the respective fix versions.

If this is not how it's structured in your instance, feel free to reach out to support@eazybi.com to describe your use case & we will be happy to help.

Best,
Marita from eazyBI support