Issue Distribution by Project and Issue Type Report

Issue Distribution by Project and Issue Type Report

This document outlines the process of creating an issue distribution report based on Project and Issue Type in Visionade. The report provides insights into the distribution of issues across projects and their respective issue types, helping teams analyze workload distribution effectively.

Introduction

The Issue Distribution Report enables users to visualize how issues are distributed across different projects and their associated issue types. This report helps project managers and teams to identify trends, allocate resources, and optimize workflows. The report will be displayed as a Pie Chart for an intuitive visual representation.

Prerequisites

Before generating the report, ensure the following conditions are met:

  • Visionade is installed and accessible within your Jira environment.

  • User has Jira Admin permissions to configure data source and data set

  • User permissions allow access to Jira Dashboards.

Post-condition

  • A dynamic Issue Distribution Report will be displayed on the Jira Dashboard.

  • Configured report is saved in Reports list.

Use Case Flow Diagram

Untitled Diagram-1741842550573.drawio (1)-20251219-090341.png

Step-by-Step Implementation

1. Configure Jira Data Source

Actions

Actions

1

Open Data Sources tab, click on Jira source

image-20250930-102840.png

 

2

Click Select Dimensions button

image-20250930-103131.png

 

3

Select dimensions and then click Save Selected

image-20250930-103310.png
4

Click Index All Dimensions button to reindex the data of all selected dimensions, ensuring it is fully up to date.

image-20250930-103422.png

2. Configure Data Set

Actions

Actions

1

Open Data Sets tab, click Create Data Set button

image-20250929-083509.png
2

Enter “Project SM” for Data Set Name

image-20250930-104149.png
3

Select “Local Jira” in Select Data Sources section

image-20250930-104300.png
4

In Select Dimensions section, select/deselect dimensions based on your needs.

image-20250930-104558.png
5

Enter JQL query to narrow down the data set that you want:

Project in (SM)

Then click “Run Query” or “Preview” button to filter and preview data in Data Preview section

image-20250930-104805.png

 

6

Click Save to save data set configuration

image-20250930-104853.png

 

3. Configure Issue Distribution Report

Actions

Actions

1

Open Reports tab, click Create Report button

image-20250929-100544.png
2

Fill in Report Name and click Next button

image-20251001-022831.png
3

In Table View tab, select data set “Project SM” that we have configured

image-20251001-033853.png
4

Open Analytics & Pivot tab to start configuring report

image-20251001-034007.png
5

Drag dimension Issue Type to section Rows to view issues types as row headers

image-20251001-034128.png
6

Drag dimension Project to dimension Columns to view projects as column headers

image-20251001-034238.png
7

Drag dimension Issue Key to section Values

Select Count in Aggregation field to view number of issues

image-20251001-034351.png
image-20251001-024457.png
8

Drag dimension Created Date to dimension Filters to filter issues created in 2025

image-20251001-034518.png

Click on Created Date dimension to select filter condition Date Is After and enter value “2025-01-01”

Use Date format: YYYY-MM-DD

image-20251001-025129.png
9

Select Pie Chart in section Visualization

image-20251001-034650.png
10

Click Apply Config to generate report

image-20251001-034818.png
11

Click Save to save report configuration

image-20251001-034928.png

4. Add Issue Distribution Report to Jira Dashboard

Actions

Actions

1

Open Dashboards screen and click Create dashboard button

image-20250313-111751.png
2

Fill in Name and click Save

image-20251001-032019.png
3

Click Edit button to edit the dashboard

Search “Visionade” to search gadget

Click Add button on Visionade Report gadget

image-20251001-035053.png
4

Select Issue Distribution Report

image-20251001-035207.png
5

Click “Save Changes” to save changes on gadget

image-20251001-031526.png
6

Click “Change layout” and select “One column”

image-20251001-035946.png
7

Click Done to save dashboard

image-20251001-040044.png

5. Result

Report is displayed on Jira Dashboard.

image-20251001-031903.png

Conclusion

By following the above steps, you can successfully configure and integrate an Issue Distribution Report into your Jira Dashboard. This report provides valuable insights into how issues are distributed across projects and issue types, helping you manage projects more effectively. We encourage you to experiment with different filters and visualizations to tailor the report to your specific needs. Happy reporting!