View Users on a chart point returns nobody for weekly charts and for organizations outside UTC

Aperta
  • Qualcosa non va?
#654 0 commenti 0 reazioni 0 assegnatari Vedi su GitHub

I maintainer di solito rispondono entro 1 giorno

@officialasishkumar ci sta già lavorando.

Dal 7/11/2026.

  • #657 di @officialasishkumar — aperta

Valutazione

Difficoltà
3/5
Tempo stimato
1-2 giorni
Idoneità per principianti
35/100
Tipo di issue
Bug
Chiarezza
Specificata chiaramente
Stato di attività
Ferma
Stack tecnologico
typescript
Ambito
analytics

Direzione di ricerca

Start in packages/core/src/modules/chart/src/sql.ts, especially chartBucketProfilesQuery and bucketEquals, then trace how the chart passes its timezone into queries and compare that with getChartBucketProfiles. Check the chart bucket and drill-down behavior for weekly charts and organizations outside UTC; done means View Users returns the users and count shown for each point. Issue #657 has an open linked pull request.

Scritto dal modello di indicizzazione a partire dal testo della issue.

Descrizione

Description

On a time-series chart, clicking a point and choosing View Users often shows "No users found" while the chart shows a non-zero count for that point.

  • Weekly charts: every point comes back empty, in every timezone.
  • Organizations outside UTC: hour points come back empty, and day and month points match the wrong bucket (empty, or missing users near the edge of the period).

Steps to reproduce

  1. Open a report with a line chart and interval Week.
  2. Click any point with a count above 0 and choose View Users.
  3. The modal says "No users found".

For the timezone case, set the organization's timezone to America/New_York and do the same on an Hour chart.

Root cause

chartBucketProfilesQuery (packages/core/src/modules/chart/src/sql.ts, bucketEquals) doesn't match how the chart buckets its points:

  • The chart builds weeks with toStartOfWeek(created_at, 1, tz), so weeks start on Monday. The drill-down uses toStartOfWeek(toDateTime(created_at)), which uses mode 0, so weeks start on Sunday. A Sunday week start never equals the Monday date the chart sends back.
  • The chart runs with the organization's timezone as session_timezone. getChartBucketProfiles calls runQuery without a timezone, so the drill-down buckets in UTC while the point's date is in the organization's timezone.

Expected behavior

View Users returns the users behind the point, with the same count the chart shows, for every interval and timezone.

Lingua principale
TypeScript
Stelle
7.3k
Fork
539
Merge medio
1g 20h
PR unite (30g)
80

Preparare l'ambiente

  • Include un Dockerfile o un file Docker Compose
  • Nessun modello di pull request
  • Nessuna guida per i contributori

Come iniziare

  1. Leggi tutta la issue e poi la guida ai contributi del progetto.
  2. Commenta sulla issue per dire che te ne occupi tu — evita che due persone facciano lo stesso lavoro.
  3. Fai un fork del repository e lavora su un branch.
  4. Apri una pull request che faccia riferimento al numero della issue.

Altre issue di Openpanel-dev/openpanel

Tutte le issue di Openpanel-dev/openpanel

Issue simili

Altre issue su TypeScript

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.