Skip to main content


Please sign in to leave a comment.



  • Official comment
    Ray User

    Hi Jayesh, 

    Thanks for adding your request to the community! The requested "available_time" field field represents denormalized data. It can be calculated from underlying raw data, which is why we are not syncing them. You can find the reasoning behind this decision in our Shared Responsibility Model:

    That said, for this particular field, it's not immediately clear to me what the calculation formula to determine this value would be. If you know it, we will be interested to make sure that the underlying data points are available.

    Best regards,

    Ray Harris

    Product Manager, Sales & Customer Success Analytics

    Hello, I've found this thread a couple of years late, but I'm working with Zendesk ticket data (ie not voice like this thread was originally about) and wondering what tables within the schema can be used to derive this availability data: