Forum Academy Marketplace Showcase Pricing Features

Issue with grouping by date - Chart JS

Hello!

I’m trying to group by “date” data I’m pulling via API choosing the type of grouping “exact”, but the chart is adding one X value between each date which is not in the JSON file:

JSON file looks like this:

{
“All_Inbox”: [
{
“date”: “2022/10/18”,
[…]
},
{
“date”: “2022/10/19”,
[…]
},
{
“date”: “2022/10/20”,
[…]
},
{
“date”: “2022/10/21”,
[…]
},

However the chart shows:

X1: 2022/10/19
X2: 2022 12:00 am
X3: 2022/10/20
X4: 2022 12:00 am
X5: 2022/10/21
X6: 2022 12:00 am
X7: 2022/10/22

X Axis Value:

Y Axis Value:

Result:
3

Please let me know if I have a setting issue or if there is an issue with the way I’m pulling the data.

Thank you!!

In case it helps someone, I found the answer. The X value import date and time so if the import is 2022/11/29 05:35:00 a.m then is will do X1: 2022/11/29 X2: 05:35:00 a.m

So you need to format X in the process:

スクリーンショット 2022-11-29 053705