How to create a report for specific timeframes?

[Ana Rita Henriques]

Hello Team,

Hope you are all doing well.

I would like to kindly request for your support on a report I am trying to create.

To give a bit more context, I need to check how many cases an agent receives for two different periods of the day: 15h - 21h (CET) and 21h - 23h (CET), from 26/12/2023 until 24/01/2023.

Could you be so kind to let me know how this can be done?

Many thanks in advance!

[Riley Venable · Accepted solution]

You can create a Recently Created Issues Report to show the number of issues created over a period of time for a project or filter. You can set up the report by adding series filtered by the service request types you want to compare and set up the calendar to suit your team’s needs by choosing working days and adding the required time slots for each day (15h - 21h (CET) and 21h - 23h (CET)). You must be a project admin or Jira admin to create SLA calendars.

[Kateryna_v_SaaSJet_]

Hi @Ana Rita Henriques 

Welcome to the community!

In addition to the previous comment, I can show the SLA configurations in the SLA Time and Report add-on (developed by my team).

You need to set up two calendars by setting as working hours your intervals: 15h - 21h (CET) and 21h - 23h (CET),

You can get a report for the required range date (26/12/2023 until 24/01/2023) in two ways.
1) In SLA configuration Manager, create 2 SLAs for both Work schedules, setting the START condition Issue created BETWEEN 26/12/2023 and 24/01/2023. Add other Pause (optional) and Stop conditions, and Save (with any SLA time goal).

2) If you need to change the date range for reports regularly, setting simple START conditions - Issue created (without date limits) is easier.

You can select any date range, assignee and your created SLA as filters for the issues. 

Then export the report in a convenient form, removing unnecessary columns, and you will get the number of your tasks.

As for me, the application is easier to use, and you can use the 30-day trial to do the same, but you also can reproduce similar configurations with the original JSM SLA.

I hope this solution helps you. If you need further clarification or assistance, please let me know.

[Ana Rita Henriques]

Hey @Kateryna_v_SaaSJet_,

Thank you so much for this, is perfectly clear!
Wish you a lovely day! 

[Kateryna_v_SaaSJet_]

@Ana Rita Henriques You're welcome!
If you have any new questions about SLA in Jira, then I will be happy to prepare the same detailed comment :)

Best regards,
Kateryna