Table of content:
- How to install the plugin
- How to setup an initial chart
- PivotChart gadget explained
- Configuration Options
- Frequently asked Questions
How to install the plugin
Pls visit the plugins marketplace page and find an installation instruction here.
How to setup an initial chart
To create a chart the following steps are required:
- Create a new or open an existing Jira® dashboard
- Click on "add gadget", select "Mirrorlake PivotCharts" gadget from the list
- In the plugin configuration screen select a filter and click "save"
- Click on a cell to open related list of issues.
PivotChart gadget explained
A renderer visualizes the data of your pivot table. The following renderers are available:
- Table Barchart
- Row Heatmap
- Col Heatmap
- Horizonatal Bar Chart
- Horizontal Stacked Bar Chart
- Bar Chart
- Stacked Bar Chart
- Line Chart
- Area Chart
- Scatter Chart
Using an aggregator you can define what exactly is shown in a pivot tabel cell:
- Count Unique Values
- List Unique Values
- Integer Sum
- Sum over Sum
- 80% Upper Bound
- 80% Lower Bound
- Sum as Fraction of Totals
- Sum as Fraction of Rows
- Sum as Fraction of Columns
- Count as Fraction of Totals
- Count as Fraction of Rows
- Count as Fraction of Columns
There are to containers to define the horizontal and vertical chart or table axis. Juts drag & drop the fields into the conainers to adjust the layout.
Exporting to excel
Using the button "Excel: create pivot table" the shown table can be exported to Microsoft Excel. This feature was tested with Windows7 and Microsoft Office 2010 and uses an ActiveXObject which requires Internet Explorer with activated ActiveX suppport.
The button is only active for certain renderer/aggregators (e.g. table/sum or table/count). Using the configuration option the button can also be hidden.
The following picture shows the configuration options of the plugin. Succeeding chapters explain the options in detail.
Project or Saved Filter
The fields defines the source of tickets to be taken for the chart planned and real progress data. You can select any predefined filter availabel in Jira® or just select a specific project.
Define your own title for your chart to give a summery of the shown content or leave it empty for hiding any title.
Using the option you can define the format of dates used for your table. Available options are:
The pivotable can be blocked for further modifications. In "view mode" the axis containers are hidden and only the renderer area is shown.
The excel export button can be toggled for being shown (or not) above the pivot table.
Epic link names
In case Jira® Agile is used, tasks can be linked to epics. The information of the "epic link" is just the key of the related epic issue. Activating this option lets the renderer lookup the epic names also. Additional database lookups are necessary which might slow down the creation of the pivot table. Pls report any performance issue to email@example.com.
Used to select the issue fields you want to include in your pivot table.
Frequently asked Questions
Is there any limitation of a maximum number of issues the chart can process?
Since 220.127.116.11 there is no maximum number of issues that can be received from your Jira® server.
In earlier versions the following applies:
Jira® limits the number of tickets a user can request using the REST API. Refer to the following article on the Atlassian website for some hints on how to configure the Jira® server settings to adjust the configured max number: https://confluence.atlassian.com/jirakb/exporting-a-filter-result-containing-more-than-1000-issues-191500982.html
Is there a limitation when opening a ticket list?
You are able to get the list of related tickets when clicking on a chart element. The longer the list of tickets is, the longer the used URL for the ticket list will be. Theoretically there is a browser specific limit which heavily depends on your browser type and version. Pls report any issue to us.
Exporting to excel does not work
Check the following:
- use Microsoft Internet Explorer (IE)
- activate ActiveX support in IE settings
- use a supporter renderer/aggregator (e.g. table/sum)
Contact us at firstname.lastname@example.org for any issue and report browser and MS Office Version.