If Chartio isn’t recognizing your dates as a time series, it won’t know that it can group the date values to display the series better.
Read on if your x-axis looks like this:
When it should look like this:
This could be happening for a few different reasons. Here are the most common solutions.
1. First, try zero-filling the data.
This is the most common fix. If there are dates missing from your date series, zero-fill will fill in the missing dates so Chartio can recognize the dates as a series. Add a Zero Fill Data step in the Data Pipeline.
2. Sort your dates.
If your dates are out of order, Chartio can’t group them as a series. Try sorting your dates. Click the date column name to open its settings pop-up, and select Ascending from the Sort dropdown.
3. Look for discrepancies in your data.
It’s possible there is a null value in your dates, or your dates are not formatted correctly. View the raw data being returned to look for any discrepancies. If applicable, filter out for null dates or format your dates in SQL Mode according to your database’s syntax. To view raw data, click the View Data button in the Data Pipeline.
4. Ensure correct date format in SQL Mode
To recognize dates as dates, Chartio requires that they are formatted in a certain way. For more information, please see our documentation on date formatting in charts.