Skip to content

Wrong data on x-Axe. Missing last value. #883

Open
@DiegoMartinaglia

Description

@DiegoMartinaglia

Introduction

To Reproduce

When showing the following chart:

select
    'chart'   as component,
    'Revenue' as title,
    0         as ymin,
    TRUE      as toolbar;
select
    'Chicago Store' as series,
    2021            as x,
    35              as value;
select
    'Chicago Store' as series,
    2022            as x,
    15              as value;
select
    'Chicago Store' as series,
    2023            as x,
    45              as value;
select
    'New York Store' as series,
    2021             as x,
    30               as value;
select
    'New York Store' as series,
    2022             as x,
    55               as value;
select
    'New York Store' as series,
    2023             as x,
    19               as value;
select
    'New York Store' as series,
    2024             as x,
    11               as value;
select
    'New York Store' as series,
    2025             as x,
    22              as value;

Actual behavior

The value 2025 is not shown on the x-Axe. Instead is shown the value of 2024 at the position where 2025 should be. I think there is some problem with the distribution over the x-Axis.

Screenshots

Image

Image

Expected behavior

The value 2025 should be shown and the value of 2024 should be befor.

Version information

  • OS:
  • Database [e.g. SQLite, Postgres]
  • SQLPage Version : v0.34.0

Additional context

Add any other context about the problem here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions