Creating custom report

[derrick]

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?

[Sebastian Krzewiński]

Hi @derrick 

Can you explain why you want to make reports based on timeframes? What value this will bring to you?

Based on what you wrote I'm afraid that it is not possible in easy way. What you can do is create custom report and you are able to set custom range and set period as hourly.

I'm sure that this is not what you are looking for but maybe this will solve your case somehow.

Regards,
Seba

[derrick]

@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.

[Sebastian Krzewiński]

@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]

@Sebastian Krzewiński 

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