Why Three Dashboards Report Different Active User Counts for the Same Day

A data practitioner describes a scenario where three dashboards show four, two, and one active users for the same day, each answering a different reasonable question. The discrepancy arises from differing definitions of activity, not from broken SQL. The article uses a small six-row fixture to show how counting all events, non-internal engagement, or paid engagement yields the three figures. It recommends naming a metric precisely, such as meaningful_human_dau, and documenting its definition, including the UTC day window and exclusions. The author also advises using a half-open time window so events at midnight fall into one day only.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in