Excluding weekends from aging calculation/metric


  • Frank Ferris

    I find these types of custom attribute formulas can be a pain. Typically I would export this data to a spreadsheet where you have access to many more formulas - in this case you can use =networkdays(start_date,end_date) to calculate number of weekdays. You could even optionally add Holidays to your formula to exclude those.

    Try setting up scheduled imports of ZD tickets to Google Sheets using a tool like Coefficient: https://coefficient.io/google-sheets-templates/zendesk-tickets-dashboard


Please sign in to leave a comment.

Powered by Zendesk