Clone wiki

pivotcharts / Documentation

Back to Home

pivochartslogo.JPG


Table of content:


Introduction


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.

features_mainusecase.png


PivotChart gadget explained

Overview

feature_overview.PNG

Renderers

A renderer visualizes the data of your pivot table. The following renderers are available:

  • Table
  • Table Barchart
  • Row Heatmap
  • Col Heatmap
  • Horizonatal Bar Chart
  • Horizontal Stacked Bar Chart
  • Bar Chart
  • Stacked Bar Chart
  • Line Chart
  • Area Chart
  • Scatter Chart

Aggregators

Using an aggregator you can define what exactly is shown in a pivot tabel cell:

  • Count
  • Count Unique Values
  • List Unique Values
  • Sum
  • Integer Sum
  • Average
  • Minimum
  • Maximum
  • First
  • Last
  • 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

Axis Containers

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.

Sorting rows+columns

rowsort.png

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.

excel_export.PNG


Configuration Options

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.

Chart Title

Define your own title for your chart to give a summery of the shown content or leave it empty for hiding any title.

Date Format

Using the option you can define the format of dates used for your table. Available options are:

date_format.PNG

Time unit

View/Edit mode

The pivotable can be blocked for further modifications. In "view mode" the axis containers are hidden and only the renderer area is shown.

viewedit_mide.png

Excel export

The excel export button can be toggled for being shown (or not) above the pivot table.

In case Jira Agile is used, tasks can be linked to epics. The information of the "epic link" is just the jira 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 support@mirrorlake.eu.

Field selector

Used to select the jira fields you want to include in your pivot table.

Refresh interval


Frequently asked Questions

Is there any limitation of a maximum number of issues the chart can process?

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

In case this is not sufficient, you may adjust your server settings or contact us and we will adapt the gadget to extend the supported amount of issues.

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 support@mirrorlake.eu for any issue and report browser and MS Office Version.

Updated