Simple JIRA report with Issues & release date


*** Working with eazyBI for Jira (version 5.2.1) .

I need to provision an Issue (=Jira Epic) report with the fields:

(A) Issue Key, (B) Issue Name, © FixVersion, (D) Fix Version Release Date.

A,B,C - are available in my Jira under Issues table.

D - is available under FixVersion table.

I imported Source data from Jira, and under ‘Analyze’ provisioned

an Issues Report:



Columns -> Measures: Issue status = show + Version release date = show.

All is good, except each version isntance created, is a new column. I want just one column with one text (version name or version date):

Can you assist?



Fix Version dimension is a multiple value dimension. We do not import versions as issue properties.

I would suggest using Fix version dimension on Rows after Issue and show Version level there:

Daina /

like this post but is there a way to add the status (released/unreleased)
as a column?

eazyBI imports versions as properties with eazyBI version 6.1.

Here is a suggested report example, where you can sue this property instead of the dimension Fix version in the report.

Here is an example formula that will pull in versions with release date and current status for each issue:

  [Fix Version].[Version].getMembersByKeys(
  [Issue].CurrentHierarchyMember.get('Fix version IDs')
  [Fix Version].CurrentHierarchyMember.GetCaption || 
  " release date: " ||
  Format([Fix Version].CurrentHierarchyMember.get('Release date'),"mmm dd yyyy")
  " status: " ||
  [Fix Version].CurrentHierarchyMember.GetString('Status')
, chr(10))

Here is how the default issue property Issue fix versions and the calculated measure versions look in my report for issues:

This report will work faster than the previously suggested report with Fix version dimension on rows.

Daina /