Time since a Text Field was updated.

Answered

4 Comments

  • Owen Sloan
    Comment actions Permalink

    Got it working, here is what I wound up with:

    SELECT MIN(SELECT(SELECT(SELECT CEILING (THIS-Ticket updated (minutes)/60/24-25568) BY Ticket Updates) BY Ticket Text Field Change WHERE Text Field = Data Status) BY Ticket Id)

    1
  • Jessie Schutz
    Comment actions Permalink

    I'm glad you got it figured out, Owen! Thanks for coming back to share your solution!

    1
  • Tracy Scobba
    Comment actions Permalink

    Should this work in Explore as well? I'm trying to calculate time since a checkbox was checked until the ticket was solved.

    0
  • Nicole - Community Manager
    Comment actions Permalink

    Hey Tracy -

    We have a recipe on the duration for which a custom field has been set to a certain value (i.e. how long a custom check box has been checked from blank), but not the other way around (i.e. how long it has been checked until ticket resolution): Explore recipe: Reporting on the duration of fields

    One of our experts suggested altering your workflow slightly, to use a custom dropdown field rather than a checkbox.

    or example, you could set the dropdown to Value1 first (same time as you would check the checkbox), then update to Value2 when the ticket is resolved. Then you could use the above recipe to calculate the duration between Value1 to Value2 and that would essentially give you the total time since a custom check box field was checked until the ticket was resolved.

    Hope that makes sense - let us know if this helps or if you have further questions.

    0

Please sign in to leave a comment.

Powered by Zendesk