Skip to content

[Bug]: Incorrect LineChart x-axis when single datapoint selected #3247

@bcapitanu-asapp

Description

@bcapitanu-asapp

Describe the bug

For a day-level LineChart time-series with a date range selector, when selecting a single day the x-axis changes to "years".

Image

Steps to Reproduce

Use the following page and select a single day in the date range selector. Notice the x-axis.

---
title: linechart x-axis bug demo
---

```sql random_data
SELECT DATE '2025-01-01' AS dt, 17  AS value, 0.17 AS rate
UNION ALL
SELECT DATE '2025-01-02' AS dt, 83  AS value, 0.83 AS rate
UNION ALL
SELECT DATE '2025-01-03' AS dt, 42  AS value, 0.42 AS rate
UNION ALL
SELECT DATE '2025-01-04' AS dt, 96  AS value, 0.96 AS rate
UNION ALL
SELECT DATE '2025-01-05' AS dt, 29  AS value, 0.29 AS rate
```

```sql date_range_data
SELECT MIN(dt::DATE)::VARCHAR AS date
FROM ${random_data}

UNION ALL

SELECT MAX(dt::DATE)::VARCHAR AS date
FROM ${random_data}
```

<DateRange
    name=selected_date_range
    data={date_range_data}
    dates=date
    defaultValue={'All Time'}
/>

```sql line_chart_data
SELECT *
FROM ${random_data}
WHERE dt BETWEEN '${inputs.selected_date_range.start}' AND '${inputs.selected_date_range.end}'
```

<LineChart
    data={line_chart_data}
    title="Random Data Over 5 Days"
    x=dt
    y=value
    y2=rate
    y2SeriesType=bar
/>

Logs

N/A

System Info

System:
    OS: macOS 15.7.2
    CPU: (10) arm64 Apple M1 Pro
    Memory: 131.53 MB / 32.00 GB
    Shell: 5.9 - /opt/homebrew/bin/zsh
  Binaries:
    Node: 22.17.0 - /Users/capitanu/.nvm/versions/node/v22.17.0/bin/node
    npm: 10.9.2 - /Users/capitanu/.nvm/versions/node/v22.17.0/bin/npm
    pnpm: 10.21.0 - /opt/homebrew/bin/pnpm
  Browsers:
    Chrome: 142.0.7444.162
    Safari: 26.1
  npmPackages:
    @evidence-dev/bigquery: ^2.0.10 => 2.0.10
    @evidence-dev/component-utilities: ^4.0.10 => 4.0.10
    @evidence-dev/core-components: ^5.3.1 => 5.3.1
    @evidence-dev/csv: ^1.0.14 => 1.0.14
    @evidence-dev/databricks: ^1.0.8 => 1.0.8
    @evidence-dev/duckdb: ^1.0.13 => 1.0.13
    @evidence-dev/evidence: ^40.1.5 => 40.1.5
    @evidence-dev/motherduck: ^1.0.4 => 1.0.4
    @evidence-dev/mssql: ^1.1.2 => 1.1.2
    @evidence-dev/mysql: ^1.1.4 => 1.1.4
    @evidence-dev/postgres: ^1.0.7 => 1.0.8
    @evidence-dev/sdk: ^3.0.10 => 3.0.10
    @evidence-dev/snowflake: ^1.2.2 => 1.2.2
    @evidence-dev/source-javascript: ^0.0.3 => 0.0.3
    @evidence-dev/sqlite: ^2.0.7 => 2.0.7
    @evidence-dev/tailwind: ^3.1.1 => 3.1.1
    @evidence-dev/trino: ^1.0.9 => 1.0.9

Severity

serious, but I can work around it

Additional Information, or Workarounds

Would expect the x-axis to reflect the selected day.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingto-reviewEvidence team to review

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions