最近搜索

没有最近搜索

Graham Forchuk's Avatar

Graham Forchuk

已加入2021年4月15日

·

最后活动2024年11月04日

关注

0

关注者

0

活动总数

6

投票

1

订阅

2

活动概览

的最新活动 Graham Forchuk

Graham Forchuk 进行了评论，

社区评论 Q&A - Reporting and analytics
社区

That worked perfectly.  Thank you. 

查看评论 · 已于 2021年6月23日 发布 · Graham Forchuk

0

关注者

0

投票

0

评论

Graham Forchuk 创建了一个帖子，

帖子 Q&A - Reporting and analytics
Tickets Solved Same Day They Were Created

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?

已于 2021年6月22日 发布 · Graham Forchuk

0

关注者

5

投票

6

评论

Graham Forchuk 创建了一个帖子，

帖子 Q&A - Reporting and analytics
Explore Metric - Tickets Solved in Under 24 Business Hours

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?

已于 2021年1月20日 发布 · Graham Forchuk

0

关注者

3

投票

1

Comment