Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Creating custom report

derrick March 13, 2024

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?

1 answer

0 votes
Sebastian Krzewiński
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 13, 2024

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.

Screenshot 2024-03-13 at 12.16.17.png

 

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

 

Regards,
Seba

derrick March 14, 2024

@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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 14, 2024

@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 March 14, 2024

@Sebastian Krzewiński 

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events