Reports by Program Increment

Tips & Tricks
1

The provided use-case is possible in the scenario when using Jira Data Center with Easy Agile Programs app v6.3.0 or higher

If you use both apps (eazyBI and Easy Agile Programs) you can analyze data by Program Increments.

Here are the steps to setup eazyBI account and import data from Easy Agile Programs app into eazyBI.

  1. define the Program increment field from eazyBI advanced settings using Program Increment Jira custom field ID instead of NNNNN
#easy Agile Program Increment
[jira.customfield_NNNNN]
name="Program Increment"
data_type = "string"
dimension = true
multiple_values = true
split_by = ","

in same way, define the “Program” field using Jira custom field ID instead of MMMMM

[jira.customfield_MMMMM]
name="Program"
data_type = "string"
dimension = true
separate_table = true

  1. import Program Increment and Program fields in eazyBI from the import options page > custom fields tab

  2. define one more new calculated field from advanced settings with separate_table = true option, new name, and new field_id - to create a calculated field with Javascript which during data import copies all issue value combinations from Program Increment field in a single-select dimension that in later steps can be enriched in eazyBI with additinal data from Easy Agile Programs API.

Replace NNNNN with Program Increment field ID

#easy Agile program increment copy
[jira.customfield_NNNNN_copy]
name="PI dim"
data_type = "string"
dimension = true
separate_table = true
javascript_code = '''
  if(issue.fields.customfield_NNNNN) {
    issue.fields.customfield_NNNNN_copy = issue.fields.customfield_NNNNN;
}
'''

** I’m using name “PI dim” in my example but any unique name can be used (that is not already imported as field in eazyBI)

When the new field is defined in advanced settings, ensure that the field is imported in eazyBI from the import options page > custom fields tab

  1. use additional data import > Rest API source application in eazyBI where import data from Easy Agile Programs API using the following endpoint example (update JIRA_HOME and {id} for program
https://JIRA_HOME/rest/eap/latest/program/{id}

image
image1576Ă—1602 237 KB

In the eazyBI column mapping step, choose the new single-select dimension for additional data import as explained here:

image
image2124Ă—1186 215 KB

  1. create eazyBI reports with Program Increment dimension or import the dashboard definition from the example below

Finally, you can set up a nice dashboard to analyze data by Program Increments between program increment start date and program increment end date.

image
image2772Ă—1658 333 KB

Dashboard definition if you want to import this example

dashbdef.zip (1.6 KB)

1 Like