Pivot Table View in Time in Status – FAQ
The Pivot Table View in the Time in Status app for Jira lets you go beyond standard reports and build flexible, slice-and-dice analysis directly on your Jira data. Instead of exporting everything to Excel, you can group issues by assignee, sprint, project, status, or any Jira field, apply calculations, highlight outliers, and even generate charts from the same pivot.
This FAQ explains what the Pivot Table View is, how to configure it (fields, layouts, formatting), how to use it for cross-project tracking, and how to export and visualize your results.
1. What is the Pivot Table View in the Time in Status app?
The Pivot Table View in Time in Status is an interactive reporting mode that turns your time-in-status data into customizable summary tables. You can drag Jira fields into Rows, Columns, Values, and Report Filters to aggregate metrics like total time in status, average time, status counts, and more. It’s ideal when you need deeper analysis than a simple grid can provide, especially across projects, teams, or time periods.
2. When should I use Pivot Table View instead of the regular grid or chart view?
Use Pivot Table View when you want to:
Combine multiple dimensions (e.g., Project → Sprint → Assignee) in one report.
Compare metrics across projects, teams, or time periods in a single table.
Quickly change the perspective of the same data with drag-and-drop (slicing & dicing).
Apply aggregation functions (Sum, Average, Min, Max, %, etc.) without exporting to Excel.
Add conditional formatting to highlight bottlenecks or outliers.
Use the regular grid for straightforward lists and charts for high-level visual summaries; use pivot tables for interactive, multidimensional analysis.
3. How do I open Pivot Table View for a Time in Status report?
To switch to Pivot Table View:
Open Apps → Time in Status and choose any compatible report (e.g. Time in Status, Assignee Time, Average Time, Status Count, Time in Status per Date).
Configure your filters, date ranges, and calendars as usual.
Click the Pivot icon to switch from the grid to the Pivot Table View.
The pivot uses the same underlying data as the grid; you’re just changing how it’s summarized and displayed.
4. How do fields work in Pivot View (Rows, Columns, Values, Report Filters)?
In Pivot View, the Fields panel lets you define how your report is structured:
Rows (“List by”) – items you want to list vertically (e.g. Assignee, Project, Issue Key, Sprint).
Columns (“Compare by”) – categories you want to compare horizontally (e.g. Status, Month, Issue Type).
Values – numeric data you want to aggregate (e.g. Time in Status, Status Count, story points), shown as Sum by default.
Report Filters – high-level filters at the top of the pivot (e.g. filter by Project, Sprint, Label) without changing the underlying data set.
You select fields from All Fields, drag them into Rows/Columns/Values/Filters, and the pivot table updates instantly.
5. How do I change the aggregation function for values (Sum, Average, Min, Max, %)?
By default, fields added to Values in Pivot View are aggregated as Sum. To change this:
Add a field to Values.
Click the Σ (sum) icon or aggregation label next to it.
Choose the required function (for example, Sum, Average, Min, Max, %, etc.).
This lets you build pivots like:
Average time in status per assignee.
Minimum/maximum cycle time per sprint.
Percentage breakdowns instead of raw totals.
6. What is the TIS Period option in Pivot View, and how do I report by periods?
The TIS Period option lets you break down pivot data by time periods:
In Pivot settings, select TIS Period.
Choose the period you need (e.g. daily, weekly, monthly, quarterly).
Apply your settings and refresh the pivot.
This allows you to build reports like:
Time in status per project by month.
Average time per status by week or sprint.
Cross-project trend reports over quarters using the same pivot.
7. How does the order of fields in Rows and Columns affect my pivot results?
Field order directly affects how your pivot is grouped:
If you set Sprint → Assignee in Rows, the pivot shows time per assignee inside each sprint.
If you set Assignee → Sprint, it shows all sprints for each assignee.
In general:
Put fields with many unique values (Assignee, Issue Key, Summary) into Rows.
Put fields with fewer unique values (Status, Month, Issue Type) into Columns.
Avoid too many levels in Columns to keep the table readable; move deeper groupings to Rows instead.
8. What layout options are available in Pivot View (Compact, Classic, Flat)?
Pivot View supports several layout modes:
Compact – space-efficient view that groups multiple levels in a single column with drop-downs. Great for dense data and dashboards.
Classic – each hierarchy level has its own column, similar to Excel pivot tables; best for detailed analysis.
Flat – shows data in a simple, flat table with minimal grouping and aggregation, useful for quick raw views.
You can also toggle Subtotals and Grand totals on or off to simplify or expand the summary level of your pivot.
9. How do I filter and slice data directly inside the pivot table?
Besides global filters, Pivot View lets you filter directly on each field:
Use Report Filters at the top for high-level scoping (e.g. specific projects, sprints, labels).
For each Row/Column field, click the gear icon next to the field name to:
Include/exclude specific values (member name filter).
Apply value-based filters (e.g. show rows where total time > X).
You can also drag fields between Rows, Columns, and Filters to quickly “slice and dice” your Time in Status data from different angles without creating new reports.
10. How do I configure cell format and conditional formatting in Pivot View?
In Pivot View, the Format options let you adjust:
Number format (decimal places, value format).
Text alignment.
Other cell style preferences.
For conditional formatting:
Open Format and choose Conditional formatting.
Click the “+” button to add a rule.
In the first row, select the calculated value and condition (greater than, less than, equal, etc.), then enter the threshold.
In the second row, choose the font, size, text color, or cell background.
All cells that meet the condition (for example, values > 40 or > N hours) will be highlighted, helping you quickly spot outliers and hotspots in your process.
11. Can I add calculated values or custom formulas in the pivot table?
Yes. Pivot View allows you to add calculated values based on existing fields:
Add a new calculated value and give it a name.
Scroll to select the required source field.
Choose the function to apply.
Drag the value into the formula line to build your calculation.
This lets you create custom metrics, such as ratios, differences, or derived KPIs, directly inside Time in Status without external spreadsheets.
12. How do I generate charts from a pivot table, and what chart types are supported?
You can create charts directly from your pivot configuration:
Switch to Pivot Table View.
Click the Charts icon.
Choose one of the supported chart types:
Stacked column
Clustered stacked column
These charts use the same Rows, Columns, and Values configuration as your pivot, so you can visually compare:
Time per status group across projects.
Time per assignee across sprints.
Any other combination defined in your pivot layout.
13. How do I export pivot results to Excel or PDF?
From Pivot Table View, you can export your data for further sharing or offline analysis:
Click Export and choose Excel (XLSX) or PDF.
The export respects your current pivot setup, including:
Selected fields and layout.
Aggregation functions and values.
Active filters and periods.
This is helpful for management reports, audits, and backups of your analyses.
14. How does the Pivot Table View help with cross-project tracking and workload analysis?
Pivot tables are particularly powerful for cross-project and multi-team tracking:
You can put Project in Rows and Status or Sprint in Columns to see time distribution across projects.
Add Assignee or Team/User Group to see where the workload is concentrated.
Use percent-based calculations or conditional formatting to highlight where too much time is spent in “To Do”, “Blocked”, or “Ready to Release”.
This makes it easier to:
Compare teams and projects side-by-side.
Identify bottlenecks (e.g. tasks stuck in To Do or Ready to Release).
Adjust resource allocation across projects based on real-time status metrics.
15. How are time values represented in pivot tables and how can I convert them to days or business hours?
In Pivot View, time values are displayed as decimal hours by default. You can translate them into days or business days with simple conversions:
Time in days = Total hours ÷ 24
Time in business days = Total hours ÷ (number of working hours in your day, e.g. 8)
For example, if your team works 8-hour days:
40 hours ÷ 8 = 5 business days
Make sure your work schedule in Time in Status matches your team’s actual working hours so your conversions and interpretations are accurate.
If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net
Haven’t worked with the add-on yet? Give it a try
