# Simple JIRA report with Issues & release date

**URL:** <https://community.eazybi.com/t/simple-jira-report-with-issues-release-date/3753>\
**Category:** Questions & Answers\
**Tags:** jira-reports, issue-key, release-date\
**Created:** [February 18, 2020, 6:21am UTC](https://community.eazybi.com/t/simple-jira-report-with-issues-release-date/3753 "2020-02-18T06:21:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![izeira](https://community.eazybi.com/letter_avatar_proxy/v4/letter/i/958977/32.png) [@izeira](https://community.eazybi.com/u/izeira)\
**Post date:** [February 18, 2020, 6:21am UTC](https://community.eazybi.com/t/simple-jira-report-with-issues-release-date/3753/1 "2020-02-18T06:21:36Z")

</div>

Hi,

\*\*\* 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:

Pages=Project

Rows=Issues

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):

 ![pic1](https://community.eazybi.com/uploads/default/original/2X/1/1607b2585ceb3e04b72afa919f06808c41357f71.png)

Can you assist?

Thanks,

Ido

---

<div class="post-metadata">

**Author:** ![daina.tupule](https://community.eazybi.com/user_avatar/community.eazybi.com/daina.tupule/32/8838_2.png) [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\
**Post date:** [March 16, 2020, 11:57am UTC](https://community.eazybi.com/t/simple-jira-report-with-issues-release-date/3753/2 "2020-03-16T11:57:57Z")

</div>

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:

 ![image](https://community.eazybi.com/uploads/default/original/2X/b/b5d292d9e2cb0ad7cded20c5aed3d44bd7382421.png)

Daina / [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![joey](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/f14d63/32.png) [@joey](https://community.eazybi.com/u/joey)\
**Post date:** [August 28, 2020, 3:34pm UTC](https://community.eazybi.com/t/simple-jira-report-with-issues-release-date/3753/3 "2020-08-28T15:34:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![daina.tupule](https://community.eazybi.com/user_avatar/community.eazybi.com/daina.tupule/32/8838_2.png) [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\
**Post date:** [October 8, 2021, 11:51am UTC](https://community.eazybi.com/t/simple-jira-report-with-issues-release-date/3753/4 "2021-10-08T11:51:32Z")

</div>

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:

```auto
Generate(
  [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:

 ![image](https://community.eazybi.com/uploads/default/original/2X/b/b374989eb817182d65941c51c5cdab1031e1ce8a.png)

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

Daina / [support@eazybi.com](mailto:support@eazybi.com)