How to get the Status Count report with the Pivot table?

Follow these steps to get the number of how many times the ticket was in specific status:

  1. Open the Time in Status for Jira Cloud app.

  2. Select a Pivot Table view.

3. Then click the Fields button.

In the Field menu, you can customize data presentation by setting your custom fields for Rows, Columns, Values.

4. To get the time and story points, drag and drop such fields:

  • Issue Key and Status → Rows

  • Time (hours) → Values 

  • Assignee → Columns 

Choose the Count option in the Values.

5. “Count of time” (hours) field shows a quantitative indicator (how many times), so set the appropriate format.

As result, you’ll get the number of times an issue has been in every status for each assignee.

If you need help or want to ask questions, please contact SaaSJet Support or email us at

Haven't used this add-on yet? Try it now! >>>