Occasionally when you finish uploading data to Auto Insights, Discover may show this message:

Possible causes

1. Date format error

Sometimes, Discover can show this error if there are problems with the date format in your dataset. An easy fix is to re-format your date as YYYY-MM-DD.

  • How to change the date format in a .csv file

Note: Make sure you save and close your file after making your change! If you re-open your .csv file after you've changed the date format, you will notice the date will revert to the default date format (in Australia, d/m/yy) so you'll need to convert it back to yyyy-mm-dd before you close it.

  • How to change the date format in SQL

For a comprehensive guide on how to convert dates in SQL, please refer to this article.

2. Segment as a measure

Setting a non-numeric segment as a measure during the upload process can cause errors on Discover. Make sure all segments, like category names, are set as segments in the Column Attributes menu.

3. Default time scale matches the granularity of your data

It's important to make sure that the default time scale that you select in the Admin Portal matches the granularity of your data. You can check the granularity of your dates in the source data before you upload it to Auto Insights. Auto Insights provides you with an indication of the date ranges and suggests the most appropriate granularity based on what it has observed during the data upload process. If you set your default time scale to daily when you have monthly data, this can cause problems in Discover.

If you have any questions, please contact us at support@hyperanna.com.

Did this answer your question?