Saving, Sharing & Exporting Time in Status Reports – FAQ

The Time in Status app gives you several ways to reuse configurations, share reports, and send data to external tools. This FAQ covers presets (Save & Load), JSON Data Feed links, file exports, and integrations with Confluence, Power BI, Qlik, eazyBI, and Google Sheets.

1. What is the Save & Load (Presets) feature, and when should I use it?

Presets let you save a complete report configuration so you don’t have to reconfigure filters, date ranges, calendars, columns, formats, and groupings every time.

Use presets when:

• You run the same report regularly (e.g. “Support SLA weekly”, “Sprint cycle time”).

• Different teams need standardized views of the same data.

• You want to reuse the same setup for Data Feed / BI integrations.

You can save up to 200 presets per user.

2. How do I create, update, and manage presets (including private vs public)?

1. Configure your report (filters, date ranges, calendar, columns, format, etc.).

2. At the top, you’ll see “Unsaved preset” if nothing is saved yet. Click Save as.

3. Enter a preset name and choose access type:

   • Private – only you can see and use it.

   • Public – all users with access to the app can use it, but only you can edit it.

4. Click Save. Now the button changes from Save as to Save.

If you change something (for example, date range or filters), the Save button lights up again:

• Click Save to update the current preset.

• Open the Save & Load menu → change settings → click Save as to create a new preset instead of overwriting the existing one.

You can load a preset via the arrow/Save&Load menu and delete it using the trash icon.

3. How do shared (public) presets behave when teammates modify them?

Public presets are meant to be a single source of truth that others can safely reuse:

• When you mark a preset as Public, teammates can see it and load it.

• If a teammate tweaks filters/columns/date ranges, those edits do not change your original preset.

• To keep their changes, they must click Save As, give it a name, and save a new preset they own.

This avoids confusion where one person’s changes silently break everyone else’s shared view.

4. How can I share a ready report with another Jira user without asking them to configure anything?

Use the Share report option in the Time in Status app:

1. Configure your report as needed.

2. Click the Share icon in the app header (top-right).

3. The app copies a URL to your clipboard and shows a confirmation flag.

4. Send this link to a teammate inside your organization.

When they open the link in their browser, Time in Status will show the same report configuration and results (subject to their Jira permissions), without them manually setting filters or columns.

5. What export options does Time in Status support (files, charts, gadgets, pivot)?

Time in Status supports multiple export paths:

• Grid exports (CSV / XLSX)

  • Supported reports: Time in Status, Assignee Time, Average Time, Status Entrance Date, Time in Status per Date, Status Count, Transition Count.

  • Export from the grid using CSV or XLSX, then analyze in Excel or Google Sheets.

  • For numeric analysis and formulas, choose Decimal Hours / Decimal Days / Decimal Weeks before export.

• Pivot Table exports

  • Export pivot reports to Excel (XLSX) or PDF.

• Chart exports

  • Chart view can be exported as PNG, JPEG, PDF, SVG.

• Gadget exports

  • From Jira dashboards, you can export gadget data (table view) as XLSX or CSV; the file name starts with [Gadget].

These options cover everything from quick CSV downloads to presentation-ready PDFs and images.

6. What is the JSON Data Feed link and when should I use it instead of file export?

The JSON Data Feed link is a secure URL that exposes a report preset as live JSON data for external tools and automations. Use it when:

• You want to connect Time in Status to analytics platforms like Power BI, Qlik, eazyBI.

• You want data to refresh automatically without manual export/import.

• You embed Time in Status reports in Confluence or Google Sheets using a dynamic feed.

The Data Feed is generated per preset and always reflects the current configuration of that preset.

7. How is the JSON Data Feed secured and what limits apply?

Security:

• Each Data Feed uses a JSON Web Token (JWT) embedded in the URL.

• The token contains only identifiers, no personal data.

• Only requests with a valid token are accepted; invalid tokens are rejected.

• Each token is unique for that feed and acts on behalf of the user who created it.

• Tokens do not expire by time, but you can delete the Data Feed if you want to revoke access.

Limits & behavior:

• Average Time and Time in Status per Date feeds: up to 400 tasks.

• Other reports (Time in Status, Assignee Time, Status Entrance Date, Status Count, Transition Count): up to 3000 tasks.

• If you don’t see all expected tasks, tighten filters or reduce scope.

• Calculations use the calendar and timezone stored in the preset.

• For issues migrated between projects with the same status names:

  • All reports except Status Entrance Date will sum time for that status across projects.

  • Status Entrance Date uses the first (oldest) entrance date for that status.

• Exported files include columns for all statuses in the full report, even if some statuses are not visible on the current page.

8. How do I use Time in Status reports inside Confluence pages?

Use the Time in Status for Confluence macros:

1. Install the free Time in Status for Confluence app from the Atlassian Marketplace (admin required).

2. In Confluence, insert the macro either by:

   • Typing /tis, /datafeed, or /timeinstatus on the page, or

   • Using toolbar: Insert (+) → View more → search “Time in Status”.

3. In the macro configuration:

   • Set Height (px) and Rows (number of lines per page).

   • Paste the JSON Data Feed link generated from a Time in Status preset.

4. Click Insert, then Publish the page.

The report will render directly on the Confluence page and stay in sync with the Data Feed preset.

9. How can I connect Time in Status data to BI tools like Power BI, Qlik, and eazyBI?

All three use the JSON Data Feed as a REST source:

• Power BI

  1. Configure and save a preset in Time in Status.

  2. Generate the JSON Data Feed link for that preset.

  3. In Power BI Desktop: Get Data → Web.

  4. Paste the Data Feed URL and load.

  5. Click Close & Apply and build visuals on top of the imported model.

• Qlik

  1. Generate and copy the JSON Data Feed link.

  2. In Qlik, Add new data → REST.

  3. Paste the URL, name the connection, and create/analyze.

  4. Select the root node and load the data.

• eazyBI

  1. Generate a preset and JSON Data Feed link in Time in Status (often filtered via JQL and with a non-empty custom field if needed).

  2. In eazyBI: Source Data → Add new source application → REST API.

  3. Paste the Data Feed URL and configure dimensions/measures (e.g. Work item key, In Progress, etc.).

  4. Start import and build eazyBI reports on top of that data.

10. How do I sync Time in Status data to Google Sheets and keep it updated?

You can integrate Time in Status with Google Sheets using a template + Apps Script + JSON Data Feed:

1. Copy the provided template Sheet (e.g. “TIS Data Feed – template”).

2. In the copied doc, go to Extensions → Apps Script.

3. Deploy the script:

   • Click Deploy → New deployment, confirm, and authorize access.

4. (Optional) Add a Time-driven trigger to run the import function on a schedule.

5. Back in the spreadsheet, delete the Settings tab and refresh (F5).

6. When prompted, paste the JSON Data Feed link from Time in Status.

7. Click Save; data will load into the Report tab.

The script can refresh data automatically based on the trigger, so your Google Sheet stays in sync with your Time in Status report without manual export.

 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

Request a demo call