Counts per desk (fast)

Overview

The counts_per_desk_fast function provides a performance-optimized way to retrieve session, message, and user counts grouped by desk. This fast variant uses materialized views for improved query performance on large datasets. Use this endpoint to:

• Build fast desk performance dashboards
• Compare desk activity across your organization
• Generate quick reports on desk usage metrics

Quick start

query CountsPerDeskFast(
  $accountId: uuid
  $deskIds: _uuid
  $startDate: timestamp
  $endDate: timestamp
) {
  rows: counts_per_desk_fast(
    args: {
      account_id: $accountId
      desk_ids: $deskIds
      start_time: $startDate
      end_time: $endDate
    }
  ) {
    desk_id: id
    num_requests
    num_sessions
    num_users
    last_used
  }
}

Variables:

{
  "accountId": "991c12a1-cc58-4377-8e37-f72259e9dac1",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17"
}

Parameters

Parameter	Type	Description
accountId	uuid	Account identifier
deskIds	_uuid	Filter by desk IDs
startDate	timestamp	Start date (format: yyyy-mm-dd)
endDate	timestamp	End date (format: yyyy-mm-dd)
isTest	Boolean	Exclude test sessions

Response fields

Field	Type	Description
desk_id	uuid	Desk identifier
num_requests	Int	Total messages processed
num_sessions	Int	Total conversation sessions
num_users	Int	Total unique users
last_used	timestamp	Last activity timestamp

Common use cases

Try it

Loading GraphQL Playground...

Account overview

Get counts for all desks in an account:

{
  "accountId": "991c12a1-cc58-4377-8e37-f72259e9dac1",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17"
}

Specific desks

Filter by specific desks:

{
  "accountId": "991c12a1-cc58-4377-8e37-f72259e9dac1",
  "deskIds": "{d2be0283-9b53-4d7b-b77d-2650f3a1a99c, 51ff88a7-dfab-44e5-9303-9b2bf13f1c94}",
  "startDate": "2024-01-08",
  "endDate": "2024-01-17"
}

Production only

Exclude test sessions:

{
  "accountId": "991c12a1-cc58-4377-8e37-f72259e9dac1",
  "isTest": false,
  "startDate": "2024-01-08",
  "endDate": "2024-01-17"
}

Example response

{
  "data": {
    "rows": [
      {
        "desk_id": "d2be0283-9b53-4d7b-b77d-2650f3a1a99c",
        "num_requests": 5420,
        "num_sessions": 1250,
        "num_users": 980,
        "last_used": "2024-01-17T14:32:15.123"
      },
      {
        "desk_id": "51ff88a7-dfab-44e5-9303-9b2bf13f1c94",
        "num_requests": 3180,
        "num_sessions": 820,
        "num_users": 650,
        "last_used": "2024-01-17T12:45:22.456"
      }
    ]
  }
}