Pivot Report

October 2023 update

Hey there,

It’s been a while, but now we’re back with a significant update that we believe deserves its own dedicated article. We’ve been hard at work to enhance your experience, and we can’t wait to share the exciting improvements with you.

New User Experience for Report configuration

Before the October 2023 update, configuring tabs was less user-friendly. The field configuration pop-up had limited functionality, lacked real-time updates, and its constrained space made adding new options more difficult.

vkkuudr.png
Obsolete configuration menu

After some extensive internal discussions, we decided to revamp this experience by introducing a side panel.

As a user, you can now witness changes as they happen, and as developers, we’re no longer boxed in by a window’s size. The side panel is not only more dynamic but also neatly organized into collapsible sections.

The window is now replaced by a Settings right-hand sidebar, allowing you to observe changes to your report in real-time.

Moreover, this sidebar includes collapsible sections like Rows, Columns, Values, etc.

GuP1L0c.png
Settings sidebar configuration options

We can’t spill the beans on why we need this extra space just yet, but rest assured, more options are on their way to make Pivot Report even better =)

Breakdown in a separate pop-up

Since day one, our layout included a Summary section with a breakdown for each row displayed beneath it. However, as the Pivot tab grew more intricate, having all elements on a single page no longer sufficed—especially with row grouping enabled.

  • Exploring specific issues within the Summary section without leaving the report wasn’t possible.

  • Similarly, Progress indicators and Charts had clickable elements in the legend that opened Jira’s Issue Navigator in a new browser tab. While functional, it lacked the convenience of staying within the same window.

After brainstorming, we introduced a custom pop-up to streamline issue exploration.

YaLFKHM.png
Example of pop-up

Supported features

This pop-up works like the Issue Navigator but offers additional functionality. You can include Pivot Report-specific columns, such as Overspent, Underspent, Work Ratio, and Completion Rate, which aren’t available outside Pivot Report.

The best part: you can stay within the same report window, avoiding the need to switch to a different browser tab and interface.

Clickable report elements

Across various tabs, numerous clickable elements are available, including legend items, Progress indicator bars, Charts, and cells in the Summary section, such as sub-totals and headers.

Clicking any of these elements opens a pop-up showing their breakdown.

Clickable dashboard widgets

The prior functionality also extends to Dashboard widgets. Clicking an element within a widget directs you to a detailed view of its Breakdown. From there, you can access the original report through a link in the header.

Disabling breakdown

The Issues breakdown pop-up doesn't replace the Breakdown section beneath the Summary section.

To enable this feature, click the Advanced button as shown in the screenshot below.

Next, go to the collapsible Breakdown field. Ensure the icon is blue, indicating the section is enabled. If the icon is gray, the section is currently disabled.

DxkVGqf.png
Example of enabled Breakdown

Two levels for Columns for Pivot tab

Similar to the capability to configure multiple Rows for the Pivot summary, you can now utilize up to two levels to group issues in columns.

In the example below, issues are initially grouped by Issue Type columns and then by Priority level.

K1ygMBC.png
Example of two Columns appearing in Pivot summary

Additional highlights

Theming Support

Full support for Jira themes (Light, Dark, or Match browser) is now available on Cloud for Pivot reports. Once themes are supported by Atlassian for Jira on Data Center/Server, we will implement them as well.

Column dragging

The behavior for users dragging columns within the Breakdown section of the report has been updated. Notable improvements include highlighting the entire column and clearly identifying the column header for dragging.

Manage Report page

The layout of the Manage Pivot Reports page has been updated by removing the left-side options and replacing them with buttons above the header of the table. This change is designed to facilitate users who are using Jira on handheld devices.

SDFDFSFSADFSAFASDFASFD.png
Changed menu layout

Thank you

We’re incredibly proud of this update and are immensely grateful for all your feedback. Our commitment is to enhance your reporting experience, and we eagerly anticipate how you’ll utilize these new features.

You can communicate with our support team concerning any of these changes through this portal.

Happy reporting, everyone!