Repository navigation
Wrong data on x-Axe. Missing last value. #883
Description
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.
Activity
[-]Wrong data on y scale[/-][+]Wrong data on x-Axe. Missing last value.[/+]lovasoa commentedon Apr 8, 2025
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 commentedon Apr 8, 2025
SQLPage v0.34.0
DiegoMartinaglia commentedon Apr 14, 2025
Hello Lovasoa,
I can give you another example which shows the problem (hoping it helps). The data:
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 commentedon Apr 21, 2025
@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 commentedon May 19, 2025
I updated apexcharts, but the bug is still present in the latest version.
81reap commentedon Aug 13, 2026
this could possibly be solved by #1370 and #1371
lovasoa commentedon Aug 23, 2026
@81reap can you confirm this is solved ?
81reap commentedon Aug 23, 2026
@lovasoa the charts are aligned now so I think this issue is solved (tested on the tip of origin/main).
my CosmicDE is having issues screenshotting the hover state but the tool tip is missing a title (eg :: the
5in #883 (comment) or2022&2025in #883 (comment))edit :: I have raised a fix for the tooltip title here #1401
Test 1
Test 2
Test 3