Skip to content

Histogram event count doesn't match table row count for small time ranges #2255

Closed

Description

@Rajin9601

When selecting a very small time range in the search page (e.g. 2 seconds: 13:29:54 ~ 13:29:56), the histogram displays a total count (e.g. 39) that doesn't match the number of rows shown in the results table (e.g. 3).

Steps to reproduce

  1. Open the Search page
  2. Select a very short custom time range (e.g. 2 seconds)
  3. Observe the histogram total count vs. the number of rows in the table
Image

Expected behavior

The histogram count and the table row count should reflect the same time window and show the same number of events.

Actual behavior

The histogram shows a larger count than the table rows. For example, querying 13:29:54 ~ 13:29:56 shows 39 events in the histogram but only 3 rows in the table.

Root cause

The auto-detected granularity has a minimum of 15 seconds. For any time range shorter than ~1200 seconds, the granularity resolves to 15 second. When the histogram date range is aligned to the nearest 15-second interval boundaries, the query window expands from the user's 2-second selection to a full 15-second window (e.g. 13:29:45 ~ 13:30:00).

  • Histogram query range: 13:29:45 ~ 13:30:00 (expanded, 15s window) → 39 events
  • Table query range: 13:29:54 ~ 13:29:56 (original user selection) → 3 rows

Activity

  1. brandon-pereira commented on May 11, 2026

    @brandon-pereira
    Member

    Good find - can confirm on my end as well. Please feel free to open a fix if you are able 😄

  2. added a commit that references this issue on May 11, 2026
    6dc5d01
  3. reopened this on May 11, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    FrontendCreated by Linear-GitHub Sync

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions