Need to calculate for how long ticket is sitting in pending status, but if ticket has been put on pending multiple times, then I want the time only for current pending status. Which metrics & dataset to use to calculate this in explore reports? or any other formula to use?
Need to calculate for how long ticket is sitting in pending status.
Hey @gajanan -
For this scenario, you'll be working with the updates history dataset and custom metrics & attributes.
I believe you'll need to deploy this solution.
Hope this helps!
Brandon
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.