How to find all tickets < solved with no agent public comment for x days

4 コメント

  • Brett Bowser
    Zendesk Community Team

    Hey Bill,

    I believe this recipe should help point you in the right direction: Explore recipe: Displaying tickets answered within different time brackets

    Let me know if you have any other questions!

    0
  • Bill Cicchetti

    Thanks Brett, I'll take a look.

    Would I have the ability to capture tickets in the past (i.e have already been closed or replied to) that had this scenario?  We are  looking to see how many tickets in a particular time period in the past had this data condition.

     

    Thanks

    0
  • Brett Bowser
    Zendesk Community Team

    Hey Bill,

    As long as the tickets haven't been deleted from your account then you should be able to report on it :)

    0
  • Bill Cicchetti

    Hey Brett,

     

    I put together a custom attribute :

     

    IF (VALUE(Requester wait time (min)) > 60*24*30)
    THEN ">30 days"
    ELSE " < 30 days"
    ENDIF

     

    The issue issue is it appears to take into account the sum of all of the requester wait time and not one individual wait time > 30 days..

    It seems like I need some "time since" attribute but not sure.  Any ideas?

    0

サインインしてコメントを残してください。

Powered by Zendesk