最近搜索


没有最近搜索

Chetan Rawat's Avatar

Chetan Rawat

已加入2023年3月26日

·

最后活动2023年12月29日

关注

0

关注者

0

活动总数

5

投票

1

订阅

2

活动概览

的最新活动 Chetan Rawat

Chetan Rawat 创建了一个帖子,

帖子 Q&A - Reporting and analytics

Hi, I'm trying to find the Time a ticket spent during Business Hours in a particular field before moving out.

This is the metric I'm using to get my tickets.

IF ( [Changes - Field name] = "Current Escalation"  AND  [Changes - New value] = "X"  AND  [Changes - Previous value] = "Y" ) 
THEN [Ticket ID]
ELSE NULL ENDIF

Now I  need a report where I will know how many hours each ticket spent in business hours and outside of business hours before the field changed from X to something else.

I tried using the following logic to create an Attribute but not working for my ask.

Separate Hours 

Let me know if there is a solution to this.

已于 2023年4月10日 发布 · Chetan Rawat

0

关注者

2

投票

1

Comment


Chetan Rawat 进行了评论,

评论Account settings of the ticketing system

Hey ZD team, my eyes are loosing sight. Pls add a Dark Mode. Would be forever grateful.
Thanks 

查看评论 · 已于 2023年3月26日 发布 · Chetan Rawat

0

关注者

4

投票

0

评论