- \n
- Number of records as expected?<\/strong><\/li>\n<\/ul>\n
Quickly check that the number of records in your table matches what you\u2019re expecting on your map.\u00a0 This may sound obvious, but it\u2019s a split-second quality assurance check that can save you hours later by avoiding rework. Check this from the feature layer\u2019s Item Details Page\u2019s Data tab by viewing the number of features.<\/p>\n
<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257262,"id":257262,"title":"image1","filename":"image1.png","filesize":45399,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image1-2","alt":"Location of number of records (4798 Features in red box) on the Details Page's Data Tab of a feature layer.","author":"7121","description":"","caption":"","name":"image1-2","status":"inherit","uploaded_to":257232,"date":"2018-06-28 20:53:36","modified":"2019-04-11 16:23:02","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":778,"height":261,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","thumbnail-width":213,"thumbnail-height":71,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","medium-width":464,"medium-height":156,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","medium_large-width":768,"medium_large-height":258,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","large-width":778,"large-height":261,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","1536x1536-width":778,"1536x1536-height":261,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","2048x2048-width":778,"2048x2048-height":261,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","card_image-width":778,"card_image-height":261,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image1.png","wide_image-width":778,"wide_image-height":261}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
- \n
- Data Types are as desired?<\/strong><\/li>\n<\/ul>\n
The most interesting attribute in my layer of Medicare Hospital Spending per Patient<\/a> is a numeric value called Score.\u00a0 This variable represents the normalized hospital spending-per-beneificiary per medical episode for some common procedures and hospitalization episodes: heart attack, heart failure, pneumonia, and hip\/knee replacement.\u00a0 I need it to be a numeric field, but because there are some records with the values of \u201cNot Available\u201d it was imported as a string field.\u00a0 I can use an use the number() function in an Arcade Expression<\/a> to temporarily convert the string to a number, but I’d like to hardcode the numeric field into my layer, so that if it gets exported into another format, it will be there.<\/p>\n
To do this, I open the layer in the Map Viewer and apply a Filter.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257282,"id":257282,"title":"image3","filename":"image3.png","filesize":6304,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image3-2","alt":"Location (red box) of icon to apply a filter in the Map Viewer.","author":"7121","description":"","caption":"","name":"image3-2","status":"inherit","uploaded_to":257232,"date":"2018-06-28 20:56:11","modified":"2019-04-11 16:52:21","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":348,"height":58,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","thumbnail-width":213,"thumbnail-height":36,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","medium-width":348,"medium-height":58,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","medium_large-width":348,"medium_large-height":58,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","large-width":348,"large-height":58,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","1536x1536-width":348,"1536x1536-height":58,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","2048x2048-width":348,"2048x2048-height":58,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","card_image-width":348,"card_image-height":58,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image3.png","wide_image-width":348,"wide_image-height":58}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Then I use the dropdowns to subset the data so that I am only working with records that have valid scores:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257292,"id":257292,"title":"image4","filename":"image4.png","filesize":25338,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image4-2","alt":"Dropdown menus for filtering within the feature layer \u201cMedicare Hospital Spending per Patient, 2016.\u201d","author":"7121","description":"","caption":"","name":"image4-2","status":"inherit","uploaded_to":257232,"date":"2018-06-28 20:57:21","modified":"2019-04-11 16:23:58","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":630,"height":324,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","thumbnail-width":213,"thumbnail-height":110,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","medium-width":464,"medium-height":239,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","medium_large-width":630,"medium_large-height":324,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","large-width":630,"large-height":324,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","1536x1536-width":630,"1536x1536-height":324,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","2048x2048-width":630,"2048x2048-height":324,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","card_image-width":630,"card_image-height":324,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image4.png","wide_image-width":630,"wide_image-height":324}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
I now see fewer points on the map, and fewer records when viewing the table within Map Viewer:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257302,"id":257302,"title":"image5","filename":"image5.png","filesize":30698,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image5-3","alt":"Screenshot of the attribute table within Map Viewer. Shows fewer Features (3148 in red box, down from 4798).","author":"7121","description":"","caption":"","name":"image5-3","status":"inherit","uploaded_to":257232,"date":"2018-06-28 20:58:16","modified":"2019-04-11 16:24:24","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1476,"height":182,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","thumbnail-width":213,"thumbnail-height":26,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","medium-width":464,"medium-height":57,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","medium_large-width":768,"medium_large-height":95,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","large-width":1476,"large-height":182,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","1536x1536-width":1476,"1536x1536-height":182,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","2048x2048-width":1476,"2048x2048-height":182,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","card_image-width":826,"card_image-height":102,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image5.png","wide_image-width":1476,"wide_image-height":182}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Even with the filter applied, this attribute is still recognized as a string field, so I\u2019m unable to do the Smart Mapping I want on the score.\u00a0 I\u2019ll fix this by going back to the Table View within the Map Viewer, and selecting the hamburger Options menu in the top right of the table, and then Add Field (this appears because this layer is hosted by me):<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257312,"id":257312,"title":"image6","filename":"image6.png","filesize":10751,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image6-2","alt":"Add Field dialogue panel shown when selecting Add Field from the Options menu.","author":"7121","description":"","caption":"","name":"image6-2","status":"inherit","uploaded_to":257232,"date":"2018-06-28 20:59:06","modified":"2019-04-11 16:24:51","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":395,"height":312,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","thumbnail-width":213,"thumbnail-height":168,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","medium-width":330,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","medium_large-width":395,"medium_large-height":312,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","large-width":395,"large-height":312,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","1536x1536-width":395,"1536x1536-height":312,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","2048x2048-width":395,"2048x2048-height":312,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","card_image-width":395,"card_image-height":312,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image6.png","wide_image-width":395,"wide_image-height":312}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Scroll to the right of your table, and you will see your newly added field.\u00a0 Now we can calculate it!\u00a0 Click on the field heading, and select Calculate.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257342,"id":257342,"title":"image7","filename":"image7.png","filesize":6081,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image7","alt":"Location of the Calculate option when clicking on the field heading.","author":"7121","description":"","caption":"","name":"image7","status":"inherit","uploaded_to":257232,"date":"2018-06-28 20:59:55","modified":"2019-04-11 16:25:06","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":173,"height":148,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","thumbnail-width":173,"thumbnail-height":148,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","medium-width":173,"medium-height":148,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","medium_large-width":173,"medium_large-height":148,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","large-width":173,"large-height":148,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","1536x1536-width":173,"1536x1536-height":148,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","2048x2048-width":173,"2048x2048-height":148,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","card_image-width":173,"card_image-height":148,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image7.png","wide_image-width":173,"wide_image-height":148}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
The expression is very simple here now that the \u201cNot Available\u201d values are filtered out.\u00a0 It\u2019s Numeric_Score = Score.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257352,"id":257352,"title":"image8","filename":"image8.png","filesize":26519,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image8","alt":"Calculate Field dialogue panel. Numeric_Score is set equal to Score.","author":"7121","description":"","caption":"","name":"image8","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:00:47","modified":"2019-04-11 16:25:29","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":558,"height":582,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","thumbnail-width":192,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","medium-width":250,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","medium_large-width":558,"medium_large-height":582,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","large-width":558,"large-height":582,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","1536x1536-width":558,"1536x1536-height":582,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","2048x2048-width":558,"2048x2048-height":582,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","card_image-width":446,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image8.png","wide_image-width":558,"wide_image-height":582}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Now you should see your new column populated with the valid scores from the original field.\u00a0 We can now turn off our original Score field.\u00a0 While viewing the table within the Map Viewer, select Options, Show\/Hide Columns and uncheck the original \u201cScore\u201d field.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257362,"id":257362,"title":"image9","filename":"image9.png","filesize":138801,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image9","alt":"Map Viewer with attribute table open: the original \u201cScore\u201d field unchecked via the Show\/Hide Columns option at bottom right.","author":"7121","description":"","caption":"","name":"image9","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:01:55","modified":"2019-04-11 16:26:08","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1467,"height":668,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","thumbnail-width":213,"thumbnail-height":97,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","medium-width":464,"medium-height":211,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","medium_large-width":768,"medium_large-height":350,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","large-width":1467,"large-height":668,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","1536x1536-width":1467,"1536x1536-height":668,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","2048x2048-width":1467,"2048x2048-height":668,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","card_image-width":826,"card_image-height":376,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image9.png","wide_image-width":1467,"wide_image-height":668}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Now I\u2019m able to use my Numeric Score field for the Smart Mapping I want to do!<\/p>\n
- \n
- Sorting is as expected?<\/strong><\/li>\n<\/ul>\n
When you sort your data by a variable or attribute, are the top records (e.g., store locations, cities, hospitals, campuses) the ones that you would expect?\u00a0 Are there any null values or other odd values that would be revealed by a quick sort?\u00a0 I can sort while viewing the table within the Map Viewer, or I can do this back in the Item Details Page’s Data tab, as I did below:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257392,"id":257392,"title":"image12","filename":"image12.png","filesize":110836,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image12","alt":"Details Page\u2019s Data tab, with the Detailed View selected for the field Numeric Score.","author":"7121","description":"","caption":"","name":"image12","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:05:09","modified":"2019-04-11 16:28:21","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1496,"height":458,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","thumbnail-width":213,"thumbnail-height":65,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","medium-width":464,"medium-height":142,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","medium_large-width":768,"medium_large-height":235,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","large-width":1496,"large-height":458,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","1536x1536-width":1496,"1536x1536-height":458,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","2048x2048-width":1496,"2048x2048-height":458,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","card_image-width":826,"card_image-height":253,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","wide_image-width":1496,"wide_image-height":458}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
- \n
- Do max and min values look right? Does the average value look right?<\/strong><\/li>\n<\/ul>\n
Now that I\u2019m working with a numeric field, the Statistics option will appear when we click on the field header in the Map Viewer.\u00a0 (The Statistics option does not appear for string fields.)<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257372,"id":257372,"title":"image10","filename":"image10.png","filesize":6316,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image10","alt":"Statistics option that appears when clicking on field header in the Map Viewer.","author":"7121","description":"","caption":"","name":"image10","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:03:07","modified":"2019-04-11 16:27:28","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":170,"height":164,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","thumbnail-width":170,"thumbnail-height":164,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","medium-width":170,"medium-height":164,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","medium_large-width":170,"medium_large-height":164,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","large-width":170,"large-height":164,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","1536x1536-width":170,"1536x1536-height":164,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","2048x2048-width":170,"2048x2048-height":164,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","card_image-width":170,"card_image-height":164,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image10.png","wide_image-width":170,"wide_image-height":164}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
When clicking on Statistics, the descriptive statistics appear.\u00a0 Let\u2019s check that this looks right.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257382,"id":257382,"title":"image11","filename":"image11.png","filesize":10871,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image11","alt":"Descriptive statistics for the field \u201cNumeric Score\u201d, including number and sum of values, minimum, maximum, average, and standard deviation.","author":"7121","description":"","caption":"","name":"image11","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:04:01","modified":"2019-04-11 16:27:43","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":304,"height":295,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","thumbnail-width":206,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","medium-width":269,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","medium_large-width":304,"medium_large-height":295,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","large-width":304,"large-height":295,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","1536x1536-width":304,"1536x1536-height":295,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","2048x2048-width":304,"2048x2048-height":295,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","card_image-width":304,"card_image-height":295,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image11.png","wide_image-width":304,"wide_image-height":295}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
The average in our case should be 1 (or very close to it), since it\u2019s a normalized score comparing hospitals on their Medicare spending per patient.\u00a0 The value here is .9844, close enough for our purposes.<\/p>\n
Some \u201cscore\u201d type variables have a very well-known maximum, such as test scores, credit scores, or GPAs.\u00a0 Less obvious is that these scores also have a minimum, usually of zero.\u00a0 That means that any -999 values (often indicating null values instead of a \u201cNot Available\u201d string that alters the field type) need to be filtered out before taking an average, or before applying cartography styles to our map.\u00a0 Check that you see a minimum of zero and not -999.\u00a0 If you didn\u2019t catch this before bringing your table into ArcGIS Online, that\u2019s okay.\u00a0 That\u2019s what the filter button is for!<\/p>\n
- \n
- Anything out of range? <\/strong><\/li>\n<\/ul>\n
Can a place really have 370 days of sunshine per year?\u00a0 Nope, because 370 > 365, which is the maximum number of days per year.\u00a0 If you have any variables that are time-related (hours per week, days per year) then you have some \u201cacceptable ranges\u201d that you can quickly check that your data values fall within the range you expect before you do any further analysis or Smart Mapping.<\/p>\n
Ranges don\u2019t necessarily have to be time-related.\u00a0 Age-related ranges are another common type.\u00a0 The range used for the working age population is usually age 16-70.\u00a0 Voting Age Population is often defined as 18+.\u00a0 Childbearing age (for women) is often defined as 15-49.<\/p>\n
Ranges can also be something else besides time or age: full-time college students, for example, almost always have a unit-load between 12 and 20 units per term.<\/p>\n
To check the ranges of multiple fields quickly, work in the Item Details Page\u2019s Data Tab, and select Show Detailed View on a particular field:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257392,"id":257392,"title":"image12","filename":"image12.png","filesize":110836,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image12","alt":"Details Page\u2019s Data tab, with the Detailed View selected for the field Numeric Score.","author":"7121","description":"","caption":"","name":"image12","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:05:09","modified":"2019-04-11 16:28:21","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1496,"height":458,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","thumbnail-width":213,"thumbnail-height":65,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","medium-width":464,"medium-height":142,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","medium_large-width":768,"medium_large-height":235,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","large-width":1496,"large-height":458,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","1536x1536-width":1496,"1536x1536-height":458,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","2048x2048-width":1496,"2048x2048-height":458,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","card_image-width":826,"card_image-height":253,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image12.png","wide_image-width":1496,"wide_image-height":458}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
This will take you to a histogram of the values, as well as the settings of that field:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257402,"id":257402,"title":"image13","filename":"image13.png","filesize":47216,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image13","alt":"Histogram of values for the field Numeric Score.","author":"7121","description":"","caption":"","name":"image13","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:06:08","modified":"2019-04-11 16:29:19","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1462,"height":814,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","thumbnail-width":213,"thumbnail-height":119,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","medium-width":464,"medium-height":258,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","medium_large-width":768,"medium_large-height":428,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","large-width":1462,"large-height":814,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","1536x1536-width":1462,"1536x1536-height":814,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","2048x2048-width":1462,"2048x2048-height":814,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","card_image-width":826,"card_image-height":460,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image13.png","wide_image-width":1462,"wide_image-height":814}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
From here, you can select different fields by using the hamburger menu button on the column on the left:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257422,"id":257422,"title":"image14","filename":"image14.png","filesize":53679,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image14","alt":"Location of hamburger menu button (red arrow at top left) to select different fields for the Detailed View.","author":"7121","description":"","caption":"","name":"image14","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:07:23","modified":"2019-04-11 16:29:33","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1462,"height":802,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","thumbnail-width":213,"thumbnail-height":117,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","medium-width":464,"medium-height":255,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","medium_large-width":768,"medium_large-height":421,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","large-width":1462,"large-height":802,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","1536x1536-width":1462,"1536x1536-height":802,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","2048x2048-width":1462,"2048x2048-height":802,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","card_image-width":826,"card_image-height":453,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image14.png","wide_image-width":1462,"wide_image-height":802}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Much faster than working in the Map Viewer!<\/p>\n
Keep in mind that these ranges can be different for different subgroups (subsets of the full amount of records).\u00a0 For example, perhaps unit-load ranges differ for semester campuses and quarter programs.\u00a0 Or the body fat percentage ranges that are completely different for men and women.\u00a0 You can check that your values are within these acceptable ranges by applying and removing additional filters, then viewing the summary statistics within the Map Viewer.<\/p>\n
- \n
- Does the change from year to year look believable?<\/strong><\/li>\n<\/ul>\n
If you have multiple years of data, a quick test to check the quality of the data is to add a new field, or use an Arcade Expression,\u00a0to calculate the change<\/a> from year to year.\u00a0 Profits, campus enrollment, or disease survival rates almost never increase by 400% in one year.\u00a0 If it looks too good to be true, it just might be miscalculated, or it might point to a larger data quality issue.<\/p>\n
- \n
- Sum (all parts) = whole?<\/strong><\/li>\n<\/ul>\n
Do all your parts add up to the whole?\u00a0 Parts can be either geography levels, or subgroups that are mutually exclusive and completely exhaustive.<\/p>\n
Geography check:<\/em><\/p>\n
Does the sum of population in all counties add up to the state populations?\u00a0 We can spot check a few states by quickly applying and removing filters to show only one state at a time, and then using the Statistics option from the Table View to check the sum.<\/p>\n
Subgroups check:<\/em><\/p>\n
Does the sum of all your subgroups add up to the total? \u00a0For example, do all your counts for servicemembers in each branch of the military (Air Force, Army, Coast Guard, Marines, Navy) add up to your counts for total servicemembers in each state?\u00a0 Do all categorical percentages sum to 100 percent?\u00a0 Does your male and female population add up to your total population for each county?\u00a0 Doing this type of check in a systematic way by writing an Arcade Expression will help you identify problem states, counties, or tracts in a matter of seconds. Here\u2019s an example using the Generalized USA Counties layer<\/a> from ArcGIS Living Atlas \u2013 let\u2019s check that the male and female population adds up to total population for each county.\u00a0 My favorite Arcade function for doing these types of checks is the iif() function<\/a>.\u00a0 It\u2019s very similar to an IF statement in Excel.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":257432,"id":257432,"title":"image15","filename":"image15.png","filesize":61330,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\/image15","alt":"Arcade expression (1 line) showing the iif() function for the field \u201cProblem Country Flag\u201d","author":"7121","description":"","caption":"","name":"image15","status":"inherit","uploaded_to":257232,"date":"2018-06-28 21:09:17","modified":"2019-04-11 16:30:02","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1460,"height":851,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","thumbnail-width":213,"thumbnail-height":124,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","medium-width":448,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","medium_large-width":768,"medium_large-height":448,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","large-width":1460,"large-height":851,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","1536x1536-width":1460,"1536x1536-height":851,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","2048x2048-width":1460,"2048x2048-height":851,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","card_image-width":798,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/06\/image15.png","wide_image-width":1460,"wide_image-height":851}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Click Test to check for syntax errors, and then click OK at the bottom.\u00a0 Fortunately, I did not find any problem counties in this layer, but if we had any, all our problem counties would be identified (and mapped!) for further investigation.\u00a0 Keep in mind that parts will only add up to the whole if your categories are mutually exclusive and completely exhaustive, meaning each person is in one and only one subgroup.<\/p>\n
Adding to the checklist<\/strong><\/p>\n
What are some tips you\u2019ve picked up over the years to check data quality?\u00a0 What quick fixes do you do to tabular data in ArcGIS Online?\u00a0 Feel free to add to the ideas presented here to create your own personal checklist for evaluating and prepping tabular data.<\/p>\n"}],"authors":[{"ID":7121,"user_firstname":"Diana","user_lastname":"Lavery","nickname":"Diana Lavery","user_nicename":"dianaclavery_global","display_name":"Diana Lavery","user_email":"DLavery@esri.com","user_url":"","user_registered":"2018-03-02 00:19:20","user_description":"(she\/her\/hers) Diana loves working with data. She has over 15 years experience as a practitioner of demography, sociology, economics, policy analysis, and GIS. Diana holds a BA in quantitative economics and an MA in applied demography. She is a senior GIS engineer on ArcGIS Living Atlas of the World's Policy Maps team. Diana enjoys strong coffee and clean datasets, usually simultaneously.","user_avatar":"
"}],"related_articles":"","card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/07\/checklist_tabular_data.png","wide_image":false},"yoast_head":"\nEvaluate and Prep Your Tabular Data in ArcGIS Online<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Evaluate and Prep Your Tabular Data in ArcGIS Online\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-03T18:01:47+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\"},\"author\":{\"name\":\"Diana Lavery\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/1f2b2b13a804cac814ed4245368e9eb9\"},\"headline\":\"Evaluate and Prep Your Tabular Data in ArcGIS Online\",\"datePublished\":\"2018-07-02T15:53:50+00:00\",\"dateModified\":\"2020-01-03T18:01:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\"},\"wordCount\":9,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS Content\",\"data management\",\"editing\",\"hosted feature layers\"],\"articleSection\":[\"Data Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\",\"name\":\"Evaluate and Prep Your Tabular Data in ArcGIS Online\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2018-07-02T15:53:50+00:00\",\"dateModified\":\"2020-01-03T18:01:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Evaluate and Prep Your Tabular Data in ArcGIS Online\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/1f2b2b13a804cac814ed4245368e9eb9\",\"name\":\"Diana Lavery\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg\",\"caption\":\"Diana Lavery\"},\"description\":\"(she\/her\/hers) Diana loves working with data. She has over 15 years experience as a practitioner of demography, sociology, economics, policy analysis, and GIS. Diana holds a BA in quantitative economics and an MA in applied demography. She is a senior GIS engineer on ArcGIS Living Atlas of the World's Policy Maps team. Diana enjoys strong coffee and clean datasets, usually simultaneously.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/dianaclavery_global\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Evaluate and Prep Your Tabular Data in ArcGIS Online","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online","og_locale":"en_US","og_type":"article","og_title":"Evaluate and Prep Your Tabular Data in ArcGIS Online","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2020-01-03T18:01:47+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online"},"author":{"name":"Diana Lavery","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/1f2b2b13a804cac814ed4245368e9eb9"},"headline":"Evaluate and Prep Your Tabular Data in ArcGIS Online","datePublished":"2018-07-02T15:53:50+00:00","dateModified":"2020-01-03T18:01:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online"},"wordCount":9,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS Content","data management","editing","hosted feature layers"],"articleSection":["Data Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online","name":"Evaluate and Prep Your Tabular Data in ArcGIS Online","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2018-07-02T15:53:50+00:00","dateModified":"2020-01-03T18:01:47+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-online\/data-management\/evaluate-and-prep-your-tabular-data-in-arcgis-online#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Evaluate and Prep Your Tabular Data in ArcGIS Online"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/1f2b2b13a804cac814ed4245368e9eb9","name":"Diana Lavery","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/04\/diana-lavery-3z7a9428-213x200.jpg","caption":"Diana Lavery"},"description":"(she\/her\/hers) Diana loves working with data. She has over 15 years experience as a practitioner of demography, sociology, economics, policy analysis, and GIS. Diana holds a BA in quantitative economics and an MA in applied demography. She is a senior GIS engineer on ArcGIS Living Atlas of the World's Policy Maps team. Diana enjoys strong coffee and clean datasets, usually simultaneously.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/dianaclavery_global"}]}},"text_date":"July 2, 2018","author_name":"Diana Lavery","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/dianaclavery_global","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/Newsroom-Keyart-Wide-1920-x-1080.jpg","primary_product":"ArcGIS Online","tag_data":[{"term_id":22951,"name":"ArcGIS Content","slug":"arcgis-content","term_group":0,"term_taxonomy_id":22951,"taxonomy":"post_tag","description":"","parent":0,"count":331,"filter":"raw"},{"term_id":86442,"name":"data management","slug":"data-management","term_group":0,"term_taxonomy_id":86442,"taxonomy":"post_tag","description":"","parent":0,"count":67,"filter":"raw"},{"term_id":27971,"name":"editing","slug":"editing","term_group":0,"term_taxonomy_id":27971,"taxonomy":"post_tag","description":"","parent":0,"count":166,"filter":"raw"},{"term_id":33141,"name":"hosted feature layers","slug":"hosted-feature-layers","term_group":0,"term_taxonomy_id":33141,"taxonomy":"post_tag","description":"","parent":0,"count":8,"filter":"raw"}],"category_data":[{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":920,"filter":"raw"}],"product_data":[{"term_id":36551,"name":"ArcGIS Online","slug":"arcgis-online","term_group":0,"term_taxonomy_id":36551,"taxonomy":"product","description":"","parent":0,"count":2419,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-online","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/257232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/7121"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=257232"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/257232\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=257232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=257232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=257232"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=257232"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=257232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Sum (all parts) = whole?<\/strong><\/li>\n<\/ul>\n
- Does the change from year to year look believable?<\/strong><\/li>\n<\/ul>\n
- Anything out of range? <\/strong><\/li>\n<\/ul>\n
- Do max and min values look right? Does the average value look right?<\/strong><\/li>\n<\/ul>\n
- Sorting is as expected?<\/strong><\/li>\n<\/ul>\n
- Data Types are as desired?<\/strong><\/li>\n<\/ul>\n