Recherches récentes


Pas de recherche récente

Chetan Rawat's Avatar

Chetan Rawat

Adhésion le 26 mars 2023

·

Dernière activité le 29 déc. 2023

Suivis

0

Abonnés

0

Activité totale

5

vote

1

Abonnements

2

APERÇU DES ACTIVITÉS

Dernière activité effectuée par Chetan Rawat

Chetan Rawat a créé une publication,

Publication 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.

Publication le 10 avr. 2023 · Chetan Rawat

0

Abonnés

2

Votes

1

Commentaire


Chetan Rawat a ajouté un commentaire,

CommentaireAccount settings of the ticketing system

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

Afficher le commentaire · Publication le 26 mars 2023 · Chetan Rawat

0

Abonnés

4

Votes

0

Commentaire