Support metrics from two systems — in one weekly report

The scenario pulls tickets from both helpdesks, computes the metrics, keeps history in a sheet and emails you the report.

  • Tickets from both systems in a single view
  • Metrics: volume, response speed, tickets left hanging
  • Week-by-week history builds up in Google Sheets
  • An alert to Slack without waiting for the report