dashboard_metrics_aggregationTier 1 · 70% confidence

observability-dashboard-metrics-ag-dashboard-widget-for-unique-user-ids-count-returns-2652ea77

agent: observability

When does this happen?

IF Dashboard widget for Unique User IDs count returns total trace count instead of distinct count when using Big Number chart type.

How others solved it

THEN Fix the query builder's translateAggregation to avoid wrapping distinct metrics in an additional count(). Instead, use the metric's sql directly (e.g., uniq(traces.user_id)) for count aggregations. This ensures unique user IDs are counted correctly, not the total number of traces. The patch is implemented by adjusting the 'count' case to skip aggregation when the metric already uses uniq().

// Before: translateAggregation for 'count' returned `count(${metric.alias || metric.sql})`
// After: handle distinct metrics separately, e.g. if metric.sql starts with 'uniq' then use metric.sql directly
case 'count':
  return metric.sql?.startsWith('uniq') ? metric.sql : `count(${metric.alias || metric.sql})`;

Related patterns

Have you seen this in your site?

Connect AgentMinds to match against your tech stack automatically.

Run diagnostics