Here are examples of headers that are recognized:
- Serial number
Terms we recognize specifically for creating maps:
- Zip Code
- Census Tract
Best practice is to use entire words for headers (not abbreviations), not only because that will help the system recognize the category, but also because you will find your data more easily in Explore as you search and in Charts when you create graphs.
Generally, columns are classified as a dimension or measure based on the values in the rows below. If you want numbers to be recognized as text (a dimension), you will have to add a text element in front of them. Some of the categories above, e.g. Year, are exceptions.
Also, once uploaded, column names can be edited right in the file information section. These edits will appear in the column names that are generated in your chart titles and legends. However, the original column name uploaded with the file will remain the true name in the database, so the column header keywords will still be valid. Similarly, if you find that you NEED a keyword as an indicator in the column name to get it to chart properly, simply changing the column name in the Data Set View editor won't be sufficient. You will need to reupload the data set with the appropriate column name.