# Reports by Program Increment

**URL:** <https://community.eazybi.com/t/reports-by-program-increment/17007>\
**Category:** Tips & Tricks\
**Tags:** easyagile\
**Created:** [April 22, 2024, 12:48pm UTC](https://community.eazybi.com/t/reports-by-program-increment/17007 "2024-04-22T12:48:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [April 22, 2024, 12:48pm UTC](https://community.eazybi.com/t/reports-by-program-increment/17007/1 "2024-04-22T12:48:08Z")

</div>

The provided use-case is possible in the scenario when using Jira Data Center with [Easy Agile Programs](https://marketplace.atlassian.com/apps/1219491/easy-agile-programs-pi-planning-program-board-dependencies?hosting=datacenter&tab=overview) 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](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields) using Program Increment Jira custom field ID instead of **NNNNN**

```auto
#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**

```auto
[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](https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JiraCustomFields) 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](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube) from [Easy Agile Programs API](https://help.easyagile.com/easy-agile-programs/easy-agile-programs-api).

_Replace **NNNNN** with Program Increment field ID_

```auto
#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](https://docs.eazybi.com/eazybi/data-import/data-from-jira/additional-data-import-into-jira-issues-cube) \> 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

```auto
https://JIRA_HOME/rest/eap/latest/program/{id}

```

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

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

 ![image](https://community.eazybi.com/uploads/default/original/2X/5/500b0da49755d44820d460a70aa08172407072be.png)

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](https://community.eazybi.com/uploads/default/original/2X/1/1a962a14d3c1c31b39e61decf11a2461a6f801e7.png)

_Dashboard definition if you want to [import](https://docs.eazybi.com/eazybi/publish-reports/create-dashboards#Createdashboards-Exportandimportdashboarddefinitions) this example_

[dashbdef.zip](https://community.eazybi.com/uploads/short-url/1gS9UmpqG1CaYmqm25JrDG8KkIy.zip) (1.6 KB)

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [April 22, 2024, 1:04pm UTC](https://community.eazybi.com/t/reports-by-program-increment/17007/2 "2024-04-22T13:04:43Z")

</div>



---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [April 22, 2024, 1:05pm UTC](https://community.eazybi.com/t/reports-by-program-increment/17007/3 "2024-04-22T13:05:11Z")

</div>