Simple JIRA report with Issues & release date

Questions & Answers
, ,
1

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
pic11833×1412 140 KB

Can you assist?

Thanks,

Ido

2

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
image2470×1142 430 KB

Daina / support@eazybi.com

3

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

4

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:

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
image1770×1106 206 KB

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

Daina / support@eazybi.com