Occasionally when you finish uploading data to Anna, Discover may show this message:
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 Anna. Anna provides you with an indication of the date ranges and suggests the most appropriate granularity based on what she 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 firstname.lastname@example.org.