Recent searches


No recent searches

Graham Forchuk's Avatar

Graham Forchuk

Joined Apr 15, 2021

·

Last activity Nov 04, 2024

Following

0

Followers

0

Total activity

6

Vote

1

Subscriptions

2

ACTIVITY OVERVIEW

Latest activity by Graham Forchuk

Graham Forchuk commented,

Community comment Q&A - Reporting and analytics

That worked perfectly.  Thank you. 

View comment · Posted Jun 23, 2021 · Graham Forchuk

0

Followers

0

Votes

0

Comments


Graham Forchuk created a post,

Post Q&A - Reporting and analytics

I haven't found any luck searching but I am looking for how to set up an Explore query to show me the number of tickets solved the same day they were created.  Any guidance on how to set this up?

Posted Jun 22, 2021 · Graham Forchuk

0

Followers

5

Votes

6

Comments


Graham Forchuk created a post,

Post Q&A - Reporting and analytics

I run a weekly and monthly report showing some ticket resolution numbers.  Under Insights I was able to use the following metric to show me how many tickets were solved within 24 business hours.

SELECT # Tickets WHERE (SELECT [Biz Hrs] Full Resolution Time (hrs) [Mdn] BY Ticket Id)BETWEEN 0 AND 24

How would l set this same metric up for use in Explore on a similar query?

Posted Jan 20, 2021 · Graham Forchuk

0

Followers

3

Votes

1

Comment