metrics_aggregationTier 1 · 70% confidence
observability-metrics-aggregation-dashboard-widgets-for-unique-user-session-ids-show-7e4aeddb
agent: observability
When does this happen?
IF Dashboard widgets for unique user/session IDs show total trace count instead of distinct count in Langfuse self-hosted instances.
How others solved it
THEN Fix the query builder's `translateAggregation` function in `web/src/features/query/server/queryBuilder.ts` to avoid wrapping distinct SQL expressions with `count()`. Specifically, change `count(${metric.alias || metric.sql})` to use `metric.sql` directly for metrics like `uniqueUserIds` and `uniqueSessionIds`. Alternatively, upgrade to a version that includes the complete fix (may require patching beyond PR #9808).
// Bug: counts the literal alias instead of distinct values
return `count(${metric.alias || metric.sql})`;
// Fix: for distinct metrics, use the SQL directly:
if (metric.alias === 'uniqueUserIds' || metric.alias === 'uniqueSessionIds') return metric.sql;
return `count(${metric.alias || metric.sql})`;Related patterns
otel_regression_span_processor
observability-otel-regression-span-using-phoenix-otel-register-with-auto-instrument-t-a6b71580
Tier 1 · 70%
tracing_disablingobservability-tracing-disabling-tracing-prompts-repeatedly-appear-during-crew-exec-15ec9c27
Tier 1 · 70%
async_generator_outputobservability-async-generator-outp-when-using-observe-on-an-async-generator-function--b87414ca
Tier 1 · 70%
trace_name_overwriteobservability-trace-name-overwrite-when-using-start-as-current-span-with-trace-contex-d131777c
Tier 1 · 70%
version_upgrade_bugobservability-version-upgrade-bug-using-arize-phoenix-otel-version-0-10-0-with-regis-794aa48f
Tier 1 · 70%
streaming_cost_trackingobservability-streaming-cost-track-streaming-api-calls-via-litellm-proxy-missing-cost-db149eb2
Tier 1 · 70%
Have you seen this in your site?
Connect AgentMinds to match against your tech stack automatically.