You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Time spent report is one of the options if you’re looking for a way to make data-driven decisions. Having that data is the first step, and Jira has a lot of tools to offer: from time tracking to the automatic calculation of time spent while performing tasks. For advanced data analysis, some companies apply analytical or Business Intelligence (BI) systems.
In this article, we overview how to export time reports to such external sources as Google Spreadsheets.
Exporting time reports to external analytical systems helps to analyze in detail the time spent on the project. You can adjust the formulas and create a convenient report for management. In the broader perspective, it means detecting problems, optimizing time, and saving money.
Let’s look at the examples with Time in Status for Jira Cloud add-on. It’s one of the best-rated time in status monitoring tools. As integration with external analytical systems is a highly-demanded option, our SaaSJet team has recently launched the Data Feed feature.
3 main steps to create an analytical report:
Open the Apps Script extension's table window. Create a function to generate the table from the data in the Data Feed using the start trigger "when opening the document". Setting the triggers will help to update and display the current information.
Find full step-by-step guidelines here: How to integrate data into Google Spreadsheet?
Jira is surely one of the most valuable data sources. Here you can find information about core business operations, including time-consuming. By connecting Jira as a data source for Google Spreadsheets or other application, you will get a helicopter view and acquire actionable insights.
Is there anybody who has already tried Time in Status for Jira Cloud add-on?
Please share your experience with the community.