Query to get ticket count where status is moved from resolved to closed.

Dedeepia Chadalla January 28, 2019

Hi Team,

Please help me out with a query to get the tickets in a month for which ticket status is changed from resolved to closed.

 

Regards,

Dedeepia

3 answers

1 vote
Jakub Hanak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 28, 2019

Hello @Dedeepia Chadalla

try this:

project = "project" AND status changed FROM "Resolved" TO "Closed" AFTER startOfMonth() BEFORE endOfMonth() 

Best regards,

Jakub 

0 votes
Jakub Hanak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 28, 2019

Go to your dashboard, click on "Add gadget" and there pick whatever chart might be useful for you. There is lot of them and it depends on what you would like to see. 

0 votes
Dedeepia Chadalla January 28, 2019

Thanks.

One more question, Please let me know a dashboard where we can create a statistics chart with the required fields.

Suggest an answer

Log in or Sign up to answer