Skip to content

Explore ​

The Explore tool is a custom query builder for freely querying collected event data with flexible metrics, dimensions, and filters.

Building a Query ​

Explore works in four steps:

1. Select a Metric ​

Choose what to measure from the metric dropdown:

MetricDescription
eventsTotal event rows
interactionsInteraction event count
actionsAction event count
discord_eventsGateway event occurrences (SUM(data.count))
errorsError event count
unique_usersApproximate distinct users (HLL)
unique_serversApproximate distinct servers (HLL)
avg_latencyAverage response latency (ms)
p95_latency95th percentile response latency (ms)
success_rateInteraction success rate (%)

See Metrics & Dimensions for details on how each metric is computed.

2. Select a Dimension ​

Choose how to group results:

DimensionGroups byChart Type
timeTime buckets (hour, day, week, month)Line chart (time series)
event_typeEvent type stringHorizontal bar chart
commandCommand name / customIdHorizontal bar chart
interaction_kindInteraction typeHorizontal bar chart
guild_idServer IDHorizontal bar chart
user_idUser IDHorizontal bar chart
shard_idShard IDHorizontal bar chart
cluster_idCluster IDHorizontal bar chart
error_nameError class nameHorizontal bar chart
custom_event_nameCustom event nameHorizontal bar chart

Note

  • Time dimension produces a line chart (time series).
  • Any non-time dimension produces a horizontal bar chart ranked by the selected metric.

3. Add Filters ​

Narrow the data using one or more filter conditions. Each filter consists of a field, an operator, and a value.

Filter Operators ​

OperatorDescriptionExample
=Equalsevent_type = interaction_slash
!=Not equalsevent_type != heartbeat
containsString containscommandName contains help
gtGreater thanlatencyMs gt 1000
ltLess thanmemberCount lt 100
betweenRange (inclusive)memberCount between 100,1000

Filtering Custom Event Props ​

Custom event properties are accessible under the props.* prefix:

event_type = custom
props.category = billing
props.priority = high

INFO

Only string, number, and boolean property values work as filter values. Nested objects are stored but not directly filterable.

4. Run the Query ​

Click Run to execute. Results appear as both a chart and a data table.

Reading Results ​

  • Chart: Visualizes the selected metric grouped by the selected dimension.
  • Table: Shows the raw data with sortable columns. Click a column header to sort ascending/descending.
  • Dimension labels: Values are displayed with human-readable labels where possible (e.g., interaction_kind = slash shows as "Slash Command").

Saved Queries ​

Save frequently used query combinations for later reuse:

  1. Configure your metric, dimension, filters, and date range.
  2. Click Save and give the query a name.
  3. Saved queries appear in the side panel for one-click access.

Saved queries store the full configuration including the date range type (e.g., "Last 7 days" stays relative, not fixed dates).

URL Sharing ​

All query parameters are serialized into the URL:

/explore?metric=interactions&dim=command&filter=interaction_kind%3Dslash&period=7d

Copy the current URL and share it with teammates. They will see the exact same query configuration with fresh data for the selected period.

Example Queries ​

Top 10 commands by usage (last 7 days)
Metric:    interactions
Dimension: command
Filter:    interaction_kind = slash
Period:    Last 7 days
Daily active users trend (last 30 days)
Metric:    unique_users
Dimension: time (day)
Period:    Last 30 days
Slowest commands by p95 latency
Metric:    p95_latency
Dimension: command
Filter:    interaction_kind = slash
Period:    Last 7 days
Error breakdown by command
Metric:    errors
Dimension: command
Filter:    event_type = command_error
Period:    Last 24 hours
Gateway event volume by type
Metric:    discord_events
Dimension: event_type
Filter:    event_type contains event_
Period:    Last 7 days
Custom event analysis
Metric:    events
Dimension: custom_event_name
Filter:    event_type = custom
Period:    Last 30 days

Dicolytics — Discord bot analytics