The x-axis in chart widget is not displayed properly

[woeful aspen]

Hi! I was wondering if I am doing something wrong, but the x-axis in my chart widget is not displayed properly since the "date" column data is not mapped on it, as it should. I attached the screenshot of how it looks like. Unfortunately, as you might see it, the "date" axis is not labeled at all, except for the label of the axis itself. I was thinking that it might be because the date column in my MySQL database is not formatted properly, for example data is stored in "YYYYMMDD" string format. Could that be a reason for that, and if so which template for the JSObject would you recommend to use for the conversion of the date from string to the proper date format? Thanks in advance!

[tight burrow]

Hey There,

We've registered your query, and our team will get back to you soon.

Regards,
Team Appsmith

[woeful aspen]

Also, I was initially using the line graph for this chart, I was wondering if it would be possible to display the line only without dots? It seems that the style of the line graph is kind of fixed, but I believe that there should be a way to do it regardless

[tight burrow]

Hi there!
Regarding the Date/x-axis error, can you share a screenshot of how you're
populating the data?

About the line chart, this is not possible at this juncture. Although could you
please help us file a feature request using the following link?-
https://github.com/appsmithorg/appsmith/issues/new/choose

Please include your use case and how it will be helpful for you.

[woeful aspen]

@tight burrow sure, here is the screenshot. That's how I populate the data. I will definitely submit a feature request on GitHub

[woeful aspen]

@tight burrow, I just submitted the feat request on GitHub, hope that it would be available soon🙂

[tight burrow]

#991654645204275280 message
This should help you fix the issue.

Regarding the feature request, thank you for filing one.
Hopefully, it's available soon enough for you!

[woeful aspen]

Great! Thanks a lot for that. Just before we close the topic, is there a way not to display all the dates, but rather keep the "navigational" dates? I have mapped the data using the moment() function, and it turns out the function is not smart enough to keep only dates essential to the navigation through the dates. Here is what I got. As you might notice it's a little redundant at this point. Thanks in advance!

[tight burrow]

I really can't think of a way as of right now but, I'll check with the team and
relay any helpful I get back to you!