Documentation Charts FAQs

X-axis date labels

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:

1) 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 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.

Zero fill the data

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 your raw data, open the chart ellipsis menu and select View Chart Data. This will open up a table view of your chart’s data on the dashboard. Alternatively, click on Edit Chart Data from the dashboard and switch your chart to a Table temporarily to view all of your data.

View raw chart data

4) Verify date format in SQL Mode

To recognize dates as dates, Chartio requires that they are formatted in a certain way. Ensure that your charts are using the correct date format in SQL Mode. For more information, please see our documentation on date formatting options in charts.

Look for discrepancies in your data