Explore recipe: Days since an organization last submitted a ticket

Have more questions? Submit a request

5 Comments

  • Samuel Alberto
    Comment actions Permalink

    This is great work! However, is there not a limit on explosions? I want to say I read there is an upper limit of 30, so if I had more than 30 requester orgs, the query would fail. Please correct me if I'm wrong. 

    Thanks

     

    0
  • Nick Dushack
    Comment actions Permalink

    Hi Samuel,

    There isn't a set number of maximum Explosions - it really depends on how many results are included in the date range specified, and how long their attribute names are. You can fit more results if you change the number of columns associated with the Explosions in Chart configuration. From what I can tell from testing, it looks like it can handle approximately 25-35 results before it errors out. If you are requiring a report with more results than Explosions can handle, it is recommended to utilize Rows instead and find a chart style that works for you. 

    0
  • Nathan Dollinger
    Comment actions Permalink

    Is there a way to do this but for over 500 organizations? The Explosion is limiting the number of accounts we are able to see. The other option that I think could work is to only see the orgs with days greater than a certain sum. I attempted to do that by limiting the CreatedAt dates of tickets but that does not work because all groups are still included. 

    0
  • Graeme Carmichael
    Comment actions Permalink

    Nathan

    If you are only interested in how long ago an organisation last submitted a ticket, and can do without the ticket number, you can try:

    Metrics

    • MIN(Number of days between today and date ticket created)

    Rows

    • Ticket Organisation Name

     

    You can then remove the Top/ Bottom filter.

    Hope that helps

     

     

    0
  • Nathan Dollinger
    Comment actions Permalink

    Graeme Carmichael Thank you that did the trick! 

    1

Please sign in to leave a comment.

Powered by Zendesk