Hello World from Chili!!!!

[#1]

Hi, my name is Alvaro Hernandez and i am an expert in Atlassian tools in Chile

I have worked in various companies occupying important roles in the same companies leading projects from start to finish.

I have experience in Atlassian tools such as Jira Software, Jira Service Management, Jira WorkManagement, Confluence, Bitbucket and Bamboo. In addition, I have been a consultant in implementations and change management. I have also worked in service companies for end clients in the Banking, Retail, Logistics, Representations market.

My experience includes roles such as Atlassian Solutions Architect, Atlassian Analyst, Information Technology Architect and Business Analyst.

I have skills in agile methodologies, conflict resolution, strategic negotiation and have certifications in Scrum and Jira Service Management.

[Antonio Gonzalez]

The notification of your post came through and I was so delighted and so belated that I just couldn't help myself but come to read it I really appreciate it thank you very much certainly some of us are some of you or in a very different category... I hope that you find and continue to work in the areas that you most enjoy in the world wide web and continue to live peacefully and in peace in your own neighborhood in your own private life enjoy the time that it is very hard and it is not a very good place right now in the world especially to have the freedom of expression online but not maybe so much near to whom or at home thank you sir and have a great day your words are always going to stick with me as a wisdom I would love to be able to learn these all these platforms but the time is expiring in your flees us...

AVGC #tonyvg2013 

[Tanuja_bhosale]

Hello,

We are using the JSM newly for our customers and would like to know how everyone is using the reporting functions? Is it possible to directly use the reports for SLA calculations? Has anyone found the formula to work the number of days / hours spent on the ticket?

regards

Tanuja

[Gizem Gökçe _OBSS_]

Hello @Tanuja_bhosale ,

Welcome to the community!

There is a lot of discussion about this in the Atlassian community. However, there is no built in solution in Jira for this. So in order to track the time spent on each status I suggest you use a marketplace app. Timepiece (formerly Time in Status) ,the oldest and leading "Time in Status" app in Atlassian Marketplace, which is developed by my team at OBSS, has a report type that will meet your need.  Our app is available for both Jira Cloud, and Data Center. 

Timepiece mainly allows you to see how much time each issue spent on each status or each assignee. 

Status Duration report (please see the screenshot above) which shows how much time each issue spent on each status. You can combine the time for multiple statuses to get metrics like Issue Age, Cycle Time, Lead Time, Resolution Time etc. 

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend. 

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Timepiece reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs.

Visit Timepiece (formerly Time in Status) to explore and enjoy a 30-day free trial to experience the full range of features.

If you wish, you can also schedule a live demo. We will provide a comprehensive overview of the application and address any inquiries you may have.

Hope it helps,

Gizem

[Valeriia_Havrylenko_SaaSJet]

Hello @Tanuja_bhosale  👋 and welcome to the community!
I have 2 add-ons for you :)

First one is SLA Time and Report.

You need to create a few goals and set different times. For example, if you need to notify the responsible employee after 75% of the time spent, create two goals, 8 and 6 hours, and set a type of notification (Slack or comment in Jira task).

The add-on has a 30-day trial period and is free for small teams (up to 10 users). 

---

Another option is Time Between Statuses. This add-on measures connections in the workflow by tracking the time it takes for specific issues to transition between statuses. You can calculate the Time to First Response by setting start/stop and pause statuses in the configuration manager. Make sure to select the first/last transition to/from status to define the calculation conditions. 

Give it a try! The add-on offers a 30-day free trial version and is free for up to 10 users. It's developed by SaaSJet.

Hope it helps 😌

[Mehmet A _Bloompeak_]

Hi @Tanuja_bhosale

Welcome to the Atlassian Community!

To get a report of time spent on each ticket, I can recommend Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

Here is the online demo link, you can see it in action and try without installing the app.

For example, if you want to get a report of how much time passed on each status of an issue, you can have a look at Time in Status for Each Issue report. This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

For further details, you can have a look at Status Time Reports How to Videos.

App Fetures:

• You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
• Status durations are calculated according to the working calendar you define. Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days.
• You can set different duration formats.
• You can export reports in CSV file format and open them in MS Excel.
• You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
• You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

If you are looking for a completely free solution, you can try the limited version Status Time Reports Free.

If you have any questions, feel free to schedule a demo with us.

Hope it helps.