Wrong data on x-Axe. Missing last value.

[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

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.

[lovasoa]

Hello! Which version of SQLPage are you using? The latest versions included upgrades to apex charts, which fixed axis some axes tick computation errors.

[DiegoMartinaglia]

SQLPage v0.34.0

[DiegoMartinaglia]

Hello Lovasoa,
I can give you another example which shows the problem (hoping it helps). The data:

y	series	x
35	year-2023	2023-01-01
46	year-2023	2023-02-01
96	year-2023	2023-03-01
76	year-2023	2023-04-01
90	year-2023	2023-05-01
106	year-2023	2023-06-01
74	year-2023	2023-07-01
57	year-2023	2023-08-01
82	year-2023	2023-09-01
92	year-2023	2023-10-01
50	year-2023	2023-11-01
105	year-2023	2023-12-01
46	year-2023	2024-01-01
25	year-2024	2024-01-01
11	year-2023	2024-02-01
48	year-2024	2024-02-01
11	year-2023	2024-03-01
53	year-2024	2024-03-01
14	year-2023	2024-04-01
65	year-2024	2024-04-01
13	year-2023	2024-05-01
29	year-2024	2024-05-01
20	year-2023	2024-06-01
42	year-2024	2024-06-01
21	year-2023	2024-07-01
29	year-2024	2024-07-01
6	year-2023	2024-08-01
32	year-2024	2024-08-01
30	year-2024	2024-09-01
132	year-2024	2024-10-01
38	year-2024	2024-11-01
28	year-2024	2024-12-01
120	year-2024	2025-01-01
64	year-2024	2025-02-01
15	year-2024	2025-03-01

Both graph selected:

The graph = "year-2024" has data until 2025 but stops befor.
If I select only one graph, either year-2023 or year-2024, its working correctly.

Thanks

[lovasoa]

@DiegoMartinaglia thank you very much for reporting this, and sorry for the delay. I can confirm the issue and I reported it upstream: apexcharts/apexcharts.js#5015

[lovasoa]

I updated apexcharts, but the bug is still present in the latest version.

select 'chart' as component;
select 'a' as series, 1 as x, 1 as y union all
select 'a', 2, 2 union all
select 'b', 4, 4 union all
select 'b', 5, 5;