Creating custom report

Question

I would like to create a report that shows the Time to resolution % Met within a a few timeframes in a month.

For example: I want to see 3 sets of data in my report which are Time to resolution % Met between 12AM-8AM, 8AM-4PM & 4PM-12AM in March.

Any idea what filter/JQL should I use for this report?

derrick_hyz9id · Answer

@Sebastian Krzewiński

I get where you are coming from. Thank you for your advice!

Sebastian Krzewiński · Answer

@derrick Only solution that came to my mind is to create filter per timeframe: created >= "2024-03-01 00:00" AND created <= "2024-03-01 08:00" or created >= "2024-03-02 00:00" AND created <= "2024-03-02 08:00" or ... As I mentioned - this will be very hard to achieve

derrick_hyz9id · Answer

@Sebastian Krzewiński We have employees working in 3 different shifts (which are those timeframes mentioned), I'm looking whether we can track the SLA % met (Time to resolution) based on different timeframes. I have tried JQL to filter. For example, I filtered the results created >= "2024-03-01 00:00" AND created <= "2024-03-31 08:00" and it gave me the data I want. But the problem is it covers only in a day. Is there any way to include 4 aspects in JQL like created >= "2024-03-01 00:00" AND created <= "2024-03-31 08:00" to created >= "2024-03-31 00:00" AND created <= "2024-03-31 08:00" Thanks in advance.