Multi-Dimensional Pivot Table Documentation

Welcome to the Multi-Dimensional Pivot Table documentation. This guide will help you create powerful, multi-dimensional reports directly on your Jira Dashboards.

Getting Started

Follow these steps to add a Multi-Dimensional Pivot Table to your dashboard:

  1. 1 Open any Jira Dashboard and click Add Gadget.
  2. 2 Search for "Multi-Dimensional Pivot Table" and click Add.
  3. 3 On the gadget, click the three dots (...) and select Configure.
  4. 4 Use the live editor to drag and drop your dimensions and see your report update in real-time.

Pivot Structure

Multi-Dimensional Pivot Table allows you to create complex, hierarchical reports by combining rows and columns.

1. Row Dimensions

Drag fields into the Rows area to create vertical groupings. You can nest multiple levels (e.g., Project > Issue Type > Status) to create hierarchical drill-downs.

2. Column Dimensions

Drag fields into the Columns area to spread data horizontally. Like rows, columns can also be multi-level (e.g., Priority > Resolution).

3. Metrics & Summation

Choose what data to display in the cells. You can count issues or sum up numeric fields like Story Points, Time Spent, or any custom numeric field.

Data Connection & JQL

Your reports are powered by real-time Jira data through JQL (Jira Query Language).

Custom JQL Queries

Enter any valid JQL to define the scope of your data. The pivot table will automatically process all issues returned by your query.

project = "PROJ" AND issuetype = "Story" AND status != "Done"

Live Preview

The configuration panel shows a live preview of your data as you change your JQL or dimensions, allowing for rapid report building.

Key Features

Multi-Level Drill Down

Click the + / - buttons on the table headers to expand or collapse specific dimensions. This allows you to explore data from a high-level summary down to granular details without leaving the dashboard.

Automatic Totals

The table automatically calculates sub-totals for every level of your hierarchy and a grand total for the entire data set.

Modern Themes

Choose from several curated themes (Ocean Blue, Midnight Slate, Royal Purple) that look great in both Jira Light and Dark modes.

FAQ

Is there a limit to the number of levels?

While technically you can add many levels, we recommend up to 4 dimensions per axis for the best readability and performance on your dashboard.

Does my data leave Atlassian Cloud?

No. Multi-Dimensional Pivot Table is built on the Atlassian Forge platform. All data processing happens within the Atlassian secure infrastructure. Your Jira data is never transmitted to or stored on external servers.

Can I add this to multiple dashboards?

Absolutely! You can add and configure as many pivot tables as you need across different dashboards.

Support

Need help with a complex query or have a feature request? Our team is ready to help.

Email: [email protected]

Visit our website: plugio.io