- PIVOT-394 - Problems with the time measuring
Support
To check known issues (or if you want to file one), view this app's issue tracker.
To learn more about the app, you should:
- Read the documentation.
This is a supported app, so you may contact the vendor (or support contact) for help:
Description
Multi-dimensional view of your data
Display data from any point of view. Create a multi-dimensional table by combining different dimensions and aggregations. Use this reporting tool to summarize information and structure your extensive amount of issuedata.
Aggregate any information, including time
This gadget aggregates and calculates different datatypes, including time. Compare estimations against the recorded time spent in any dimension. Total time spent by issue type and project becomes easier to track
Drill down to acces your underlying data
The drill down function gives you a quick and detailed view of the information behind the issue. To get more specifics of your subset, simply click on the values presented in the pivot table.
More details
Note: Pivot Gadget will be not available anymore from Feb 15 onwards.
The Pivot Gadget provides similar functionality as found in spreadsheet and business intelligence software.
It is useful for quickly creating cross tabulations across a long list of dimensions and aggregations. Total time spent by issue type and project is now a couple of clicks away.
Supported dimensions:
- Basic issue fields (priority, project, date created, ...)
- Custom fields
- Parent issue to group by subtask
- Epic links
Some supported aggregations:
- Count of issues
- Average, maximum, minimum
- Time tracking aggregations - original estimate, remaining estimate, time spent on work log level
- Time tracking aggregations on subtask level or accumulated (parent and subtask)
- For each number custom field - count and summation
Export to excel supported
Version history
1.8.2-jira8Jira Server 8.0.0 - 8.20.182019-08-27Bug fixes Version 1.8.2-jira8 • Released 2019-08-27 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • Commercial1.8.2-jira67Jira Server 6.4 - 7.13.182019-08-27Bug fixes Version 1.8.2-jira67 • Released 2019-08-27 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • Commercial- PIVOT-394 - Problems with the time measuring
1.8.1-jira8Jira Server 8.0.0 - 8.2.62019-05-22bug fixes Version 1.8.1-jira8 • Released 2019-05-22 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • Commercial- Dimensions not fitting into Dimension drop zone are unavailable for selection
- Pivot cannot be enabled on Jira 8.0, 8.1(in case TGE is not installed)
- Export is broken on Jira 8.1
- Query is broken when using only not default(new) project for querying(JIRA 8.1, Jira 7.10)
- Query does not work when using only not default(new) project for querying(JIRA 8.1)
1.8.1-jira67Jira Server 6.4 - 7.13.182019-05-22bug fixes Version 1.8.1-jira67 • Released 2019-05-22 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • Commercial- Dimensions not fitting into Dimension drop zone are unavailable for selection
- Pivot cannot be enabled on Jira 8.0, 8.1(in case TGE is not installed)
- Export is broken on Jira 8.1
- Query is broken when using only not default(new) project for querying(JIRA 8.1, Jira 7.10)
- Query does not work when using only not default(new) project for querying(JIRA 8.1)
1.8.0-jira8Jira Server 8.0.0.m0021-eap07 - 8.1.32019-04-23Comapatibility with Jira 8 Version 1.8.0-jira8 • Released 2019-04-23 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialNo release notes.1.8.0-jira67Jira Server 6.4 - 7.13.182019-04-23Jira 8 compatibility changes Version 1.8.0-jira67 • Released 2019-04-23 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialNo release notes.1.7.1Jira Server 6.4 - 7.13.182018-01-15Bug fix and JIRA 7.7 compatibility Version 1.7.1 • Released 2018-01-15 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • Commercial- PIVOT-348 - Formatting is not applied
- PIVOT-352 - Compatibility with JIRA 7.7
1.7.0Jira Server 6.4 - 7.6.172016-12-11Now supporting text fields and cascade select. Version 1.7.0 • Released 2016-12-11 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialThis release addresses one of the most requested features
- the support of any arbitrary string as dimension
- Support cascading fields
Check Release History for more details
1.6.1Jira Server 6.4 - 7.2.152016-10-03Jira 7.2 compatibility Version 1.6.1 • Released 2016-10-03 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialJust a couple of small changes ensuring compatibility with Jira 7.2
Do you have ideas about what to do with the add-on. Visit us at our Exalate booth during Atlassian Summit (B22)
1.6.0Jira Server 6.2 - 7.1.102016-07-11Export to excel, labels support, new aggregations and data center compatibility Version 1.6.0 • Released 2016-07-11 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialCheck our release history page for more details
1.5.0Jira Server 6.2 - 7.1.102016-01-20Jira Version 7 compatibility Version 1.5.0 • Released 2016-01-20 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialBug
- PIVOT-227 - Progress bar behaviour
- PIVOT-243 - Config: selected TGE grid G2 => dimensions and aggregations from TGE grid G1 should be removed
- PIVOT-246 - Pivot rows/columns/measures config not persisted
- PIVOT-261 - Parent summary is missing from parent dimension
- PIVOT-262 - Row heading collapses to minimum
- PIVOT-267 - Horizontal scrollbar not appearing consequently
- PIVOT-268 - Dates are not sorted correctly
- PIVOT-271 - Issues with multiple options of MultiSelect selected are handled incorrectly
- PIVOT-277 - Pivot gadget works unexpectedly with userlist column from TGE
- PIVOT-280 - Changing the granularity of date removes date from pivot rows
- PIVOT-283 - Progress bar is not shown on Jira 7
- PIVOT-284 - Components and fix versions from hidden projects are shown in JQL
Improvement
- PIVOT-226 - Aggregation must take into account field configuration
- PIVOT-269 - Add due date as a dimension
- PIVOT-265 - Add Component dimension
1.4.1Jira Server 6.0.1 - 6.4.142015-04-16Share your pivots with your colleagues Version 1.4.1 • Released 2015-04-16 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialReleased on Apr 15, 2015
Major focus in this release was about sharing pivot gadget with other users and ensuring that the selected layout is also shared.
New Feature
- PIVOT-110 - Add parent dimension
- PIVOT-182 - Sharing a dashboard is not sharing the pivot table layout
- PIVOT-216 - Populate dimensions and aggregations with columns from selected TGE
Improvement
- PIVOT-194 - issue summary and label dimension
- PIVOT-245 - support for table grid editor dates
Bug
- PIVOT-251 - An internal server error occurred when requesting resource - when using the pivot with TGE v1.14.2
- PIVOT-254 - Manipulations with TGE break Pivot Table
- PIVOT-256 - Time aggregation does not work in standalone Jira
- PIVOT-257 - Unknown aggregation for previous configuration of pivot breaks the gadget
- PIVOT-258 - Wrong layout of drill-down date headers in pivot
1.3.0-rc1Jira Server 6.0.1 - 6.3.152015-03-05Compatibility with the table grid editor Version 1.3.0-rc1 • Released 2015-03-05 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialIn this release we introduce the integration with the table grid editor.Create pivot reports on the data collected in grid tables.
(requires v1.14.4 of the table grid editor)
1.2.0-rc2Jira Server 6.0.1 - 6.3.152015-02-05Introducing worklog dimensions (worklog author and date) and a nice progress bar Version 1.2.0-rc2 • Released 2015-02-05 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialIn this release we introduce worklog dimensions. Include the worklogs in your pivots to drill down on individual time logs.
When querying large datasets, users will have to wait a bit before the data is ready to be rendered.A progress bar will display
- Bug
- Improvement
1.1.0-rc1Jira Server 6.0.1 - 6.3.152015-01-20Introducing epic name and label dimension Version 1.1.0-rc1 • Released 2015-01-20 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • Commercial- [PIVOT-157] - Epic Name and Label Dimension
- [PIVOT-192] - Use issue key as dimension
1.0.0-rc5Jira Server 6.0.1 - 6.3.152015-01-10Bug fixes Version 1.0.0-rc5 • Released 2015-01-10 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialNo release notes.1.0.0-rc4Jira Server 6.0.1 - 6.3.152015-01-06Initial release Version 1.0.0-rc4 • Released 2015-01-06 • Supported By Exalate: Integrations for Jira, Azure DevOps, Zendesk, Salesforce, GitHub, ServiceNow, ... • Paid via Atlassian • CommercialNo release notes.