Formatting x-axis date labels

Charts

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:

Does your x-axis look like this?

When it should look like this:

Your x-axis should look like this

This could be happening for a few different reasons. Here are the most common solutions.

Solution

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.

Zero-fill the data

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.

Sort your dates

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.

Discrancies in data

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.


Related Charts Help Articles

See more