Pivot Reports for Jira

Tagline: Pivot tables, charts and time-in-status over any JQL — live, timezone-correct, and a third of the price.

Getting started

1. Install

Install from the Marketplace listing, or in Jira go to Apps → Explore more apps and search for Pivot Reports for Jira. You need to be a Jira administrator. There is nothing to configure before first use.

2. Build your first report

  1. Open a project and go to Project menu → Apps → Pivot Reports for Jira.
  2. Under Source, choose the project or paste a JQL query.
  3. Under Rows, pick the field to group by — assignee, status, issue type, a label, any custom field.
  4. Under Columns, optionally pick a second field, or a date field with a bucket (day, ISO week, month, quarter, year).
  5. Under Measures, choose what to count: Issue count, or a sum, average, minimum or maximum of any numeric field, cycle time, or age.
  6. The table draws as you go, with subtotals and a grand total. Click any number to drill through to the work items behind it.

3. Chart it, export it, save it

4. Report on history

Under Issue history, set an As of date to rebuild every work item's fields as they were at the end of that day, leaving out items created later. For a time-in-status report, choose Status (time in status) as the rows field and Days in status as the measure. History reports read a changelog per work item, so they are limited to 1,500 items.

5. Put a report on a dashboard

  1. Save the report first.
  2. Go to Dashboards, edit a dashboard, choose Add gadget and search for Pivot Report.
  3. Edit the gadget and pick the saved report.

If something looks wrong

Summary

Pivot Reports turns a JQL query, a board, a sprint or a saved filter into a pivot table and a chart in three clicks: pick a row field, an optional column field, and one or more measures. Count issues, sum or average story points, time spent, estimates or any number field, take a median or an 85th percentile, or write a small formula like sum(points) / count — broken down by status, assignee, priority, type, epic, sprint, version, component, label, any select/user/date custom field, or by created/resolved date per day, week, month, quarter or year. Every cell drills down to the issues behind it.

Ask how long work actually sits in each status, or what the board looked like on a date three months ago, and get an answer read live from Jira's own change history — no import, no cube, no query language to learn. The app reads Jira as you, so what you see is exactly what your permissions allow, and nothing leaves Atlassian's infrastructure (Runs on Atlassian).

Highlights

What it is not

Pivot Reports is the deterministic core of a BI tool, not a data warehouse. It does not import your data into a cube, has no MDX, does not join other data sources (SQL, Google Sheets, Tempo), and cannot publish a report to the public web. If you need those, eazyBI is the right tool — at its price. See COMPETITORS.md for the full comparison, including what is impossible for an app that never sends your data anywhere.

Pricing

US$3 a month flat for up to 10 users, then US$1.00 per user per month, flat. Annual billing: 10 months for 12.

Why: the two apps most teams use for this cost about three times as much per user at the sizes most teams are. Both are good tools that most customers use for exactly what Pivot Reports does — count and sum issues by a field or two, chart it, put it on a dashboard, and ask how long things sat in a status. A 50-person site pays about $150 a month for either incumbent and $50 here; a 10-person team pays $3.

Support

Documentation and support: to be published with the Marketplace listing.