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

Abierto
  • ¿Algo no está bien?
#654 0 comentarios 0 reacciones 0 asignados Ver en GitHub

Los mantenedores suelen responder en 1 día

@officialasishkumar ya está trabajando en esto.

Desde el 7/11/2026.

  • #657 de @officialasishkumar — abierto

Evaluación

Dificultad
3/5
Tiempo estimado
1-2 días
Aptitud para principiantes
35/100
Tipo de issue
Error
Claridad
Bien especificado
Estado de actividad
Estancado
Stack tecnológico
typescript
Área
analytics

Línea de trabajo

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.

Escrito por el modelo de indexación a partir del texto del issue.

Descripción

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.

Lenguaje dominante
TypeScript
Estrellas
7.3k
Forks
539
Merge medio
1 d 20 h
PR fusionados (30 d)
80

Preparar el entorno

  • Incluye un Dockerfile o un archivo de Docker Compose
  • Sin plantilla de pull request
  • Sin guía de contribución

Primeros pasos

  1. Lee el issue completo y luego la guía de contribución del proyecto.
  2. Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
  3. Haz un fork del repositorio y trabaja en una rama.
  4. Abre un pull request que haga referencia al número del issue.

Más de Openpanel-dev/openpanel

Todos los issues de Openpanel-dev/openpanel

Issues similares

Más issues de TypeScript

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.