{"id":1788532,"date":"2022-12-13T05:00:12","date_gmt":"2022-12-13T13:00:12","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1788532"},"modified":"2022-12-12T09:59:27","modified_gmt":"2022-12-12T17:59:27","slug":"learning-to-love-the-reference-table","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table","title":{"rendered":"Learning to love the reference table"},"author":294792,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341],"tags":[466322,763062,280752,768152],"industry":[],"product":[36801],"class_list":["post-1788532","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-arcgis-insights","tag-data-table","tag-housing-affordability","tag-reference-table","product-insights"],"acf":{"short_description":"See how you can use the reference table to draw out visual cues and dive deeper into your housing data.","flexible_content":[{"acf_fc_layout":"content","content":"

Recently, I was asked to create a demo on using the reference table in Insights. A feature which I never thought would turn into one of my favorites. Having a geography and GIS background I\u2019ve always been drawn more to Insights\u2019 core spatial tools. Something I\u2019ve come to learn though is the combination of spatial and nonspatial tools working together, interacting together, allows for all visualizations to provide spatial context. The reference table working in tandem with a map allows for both the visual spatial cues and the explicit data context providing a well-rounded view of your data.<\/p>\n

Plus, with the reference table in Insights you can add visual cues right on the table to get the most out of your raw data. Let\u2019s look at an example to see if I can make you feel just as strongly about the possibilities of the reference table as I now do.<\/p>\n

As a young adult, still renting an apartment, with the roller coaster that has been the housing market the past couple years I was interested in looking at some housing data. Naturally, I turned to the web looking for things I should be conscious of when looking for a house and one thing I found was that you don\u2019t want your home to cost more than 2.6 times your yearly income. For simplicity I\u2019m just going to focus on this one aspect. View the final report<\/a> to get a sense for what\u2019s coming!<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1788542,"id":1788542,"title":"HousingReport","filename":"HousingReport.png","filesize":481853,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\/housingreport","alt":"Insights page showing the final report from this blog workflow. Displays a map, scatterplot, reference table and line graph","author":"294792","description":"","caption":"","name":"housingreport","status":"inherit","uploaded_to":1788532,"date":"2022-12-07 16:07:50","modified":"2022-12-07 16:08:48","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":1438,"height":987,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport.png","medium-width":380,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport.png","medium_large-width":768,"medium_large-height":527,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport.png","large-width":1438,"large-height":987,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport.png","1536x1536-width":1438,"1536x1536-height":987,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport.png","2048x2048-width":1438,"2048x2048-height":987,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport-677x465.png","card_image-width":677,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/HousingReport.png","wide_image-width":1438,"wide_image-height":987}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Preparing the data<\/h2>\n

I started looking for datasets I could use when a colleague pointed out I had everything I need right in Esri\u2019s data catalogue and can access that data right in Insights. I started with a USA county layer retrieved from Esri\u2019s available boundary data and then made use of Enrich Data. Enriching the counties with details on Median Home Value and Median Household Income for ages 25-34 in 2019, 2021, and 2026.<\/p>\n"},{"acf_fc_layout":"sidebar","content":"

Note:<\/strong> Data is regularly updated within the Data browser, new years may be available if trying to reproduce this.<\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"image","image":{"ID":1788552,"id":1788552,"title":"EnrichCountyData","filename":"EnrichCountyData.png","filesize":136690,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\/enrichcountydata","alt":"SHows the field names added using the Enrich tool","author":"294792","description":"","caption":"","name":"enrichcountydata","status":"inherit","uploaded_to":1788532,"date":"2022-12-07 16:10:13","modified":"2022-12-07 16:10:36","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":1165,"height":442,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData.png","medium-width":464,"medium-height":176,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData.png","medium_large-width":768,"medium_large-height":291,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData.png","large-width":1165,"large-height":442,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData.png","1536x1536-width":1165,"1536x1536-height":442,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData.png","2048x2048-width":1165,"2048x2048-height":442,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData-826x313.png","card_image-width":826,"card_image-height":313,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/EnrichCountyData.png","wide_image-width":1165,"wide_image-height":442}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

I wanted to compare the cost of homes to household income, so I calculated new fields for each year of data using the equation Median Home Value\/Median HH Income. There are many ways you can view this data in Insights. My first instinct is to put it on a map, so I\u2019ll create a map of the 2026 Median Home Value\/Income field. However, after doing so I realized I want to show more things at once and I don\u2019t want to add too many maps or have too many layers on one map. I could create a scatter plot matrix, or some bar charts, but if I want to see all the raw values, compare them, and see trends the reference table is going to cover most of that for me all in one visual.<\/p>\n

 <\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1788562,"id":1788562,"title":"CalculateFields","filename":"CalculateFields.png","filesize":77548,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\/calculatefields","alt":"Displays the newly calculated field names and the calculation used in the datatable","author":"294792","description":"","caption":"","name":"calculatefields","status":"inherit","uploaded_to":1788532,"date":"2022-12-07 16:11:12","modified":"2022-12-07 16:11:37","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":1177,"height":626,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields.png","medium-width":464,"medium-height":247,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields.png","medium_large-width":768,"medium_large-height":408,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields.png","large-width":1177,"large-height":626,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields.png","1536x1536-width":1177,"1536x1536-height":626,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields.png","2048x2048-width":1177,"2048x2048-height":626,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields-826x439.png","card_image-width":826,"card_image-height":439,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CalculateFields.png","wide_image-width":1177,"wide_image-height":626}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Creating and styling the reference table<\/h2>\n

Using the County<\/strong>,\u00a0 2019 HV\/Inc<\/strong> and \u00a02021 HV\/INC<\/strong> fields I create a reference table by dragging them to the Reference Table<\/strong> option in the Table<\/strong> drop zone. Personally, when I first look at this table my eyes instantly glaze over. Its just a bunch of numbers that are hard to focus on and pull information out of. Luckily this leads me to one of the main reasons I love this visualization \u2013 conditional formatting.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1788682,"id":1788682,"title":"CreateReferenceTable","filename":"CreateReferenceTable.gif","filesize":5162077,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\/createreferencetable","alt":"","author":"294792","description":"","caption":"","name":"createreferencetable","status":"inherit","uploaded_to":1788532,"date":"2022-12-07 19:18:55","modified":"2022-12-07 19:19:20","menu_order":0,"mime_type":"image\/gif","type":"image","subtype":"gif","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1278,"height":770,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable.gif","medium-width":433,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable.gif","medium_large-width":768,"medium_large-height":463,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable.gif","large-width":1278,"large-height":770,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable.gif","1536x1536-width":1278,"1536x1536-height":770,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable.gif","2048x2048-width":1278,"2048x2048-height":770,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable-772x465.gif","card_image-width":772,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/CreateReferenceTable.gif","wide_image-width":1278,"wide_image-height":770}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Conditional formatting<\/h2>\n

After selecting Table options<\/strong> in the header, I can select my numeric fields and choose conditional formatting.<\/p>\n

Hint: <\/strong>I can select these fields directly on the table itself OR using the menu in the Conditional formatting<\/strong> pane.<\/p>\n

Swapping the Visualization<\/strong> option to Rule based<\/strong> allows me to set the format rules to highlight all variables in my selected columns that are less than 2.6 times the median income.<\/p>\n

Hint: <\/strong>I can also use another field in my table for the rule as opposed to a set number.<\/p>\n

I can style the highlighted values in a way that makes sense to me \u2013 I\u2019ll go with green and bold to highlight these as positive areas that meet my criteria of counties where the average housing prices are affordable for the average household income.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1788732,"id":1788732,"title":"ConditionalFormatting","filename":"ConditionalFormatting.png","filesize":70716,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\/conditionalformatting-3","alt":"Table showing Conditional formatting window and settings","author":"294792","description":"","caption":"","name":"conditionalformatting-3","status":"inherit","uploaded_to":1788532,"date":"2022-12-07 19:53:16","modified":"2022-12-07 19:53:34","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":895,"height":633,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting.png","medium-width":369,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting.png","medium_large-width":768,"medium_large-height":543,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting.png","large-width":895,"large-height":633,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting.png","1536x1536-width":895,"1536x1536-height":633,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting.png","2048x2048-width":895,"2048x2048-height":633,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting-657x465.png","card_image-width":657,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ConditionalFormatting.png","wide_image-width":895,"wide_image-height":633}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

When this styling is applied, the reference table instantly goes from chaos on my eyes to something that draws me towards relevant values and shows me how things have changed from 2019 to 2021.<\/p>\n

Visualizing the trends<\/h2>\n

Speaking of the trend, we can further visualize and show the change across time using sparklines. Here I select Sparklines<\/strong> from the Table options<\/strong>, my two fields from the table, and add a field not yet shown on my table (2026 HV\/Inc). These columns contain values for individual years which allows me to use the sparklines to show the trend over time and a prediction into the future. I can use data points to again draw the reader to the pattern I want to call out, in this case I\u2019ll call out the high values.<\/p>\n

Interestingly we see that not all the highs are predicted to be in the future, some in fact were in the past. This may lead to a future analysis of why these areas are closing the gap between home value and income.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1788822,"id":1788822,"title":"SparklinesTrend","filename":"SparklinesTrend-1.png","filesize":87531,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\/sparklinestrend-2","alt":"Shows table with sparklines column and the sparklines styling window","author":"294792","description":"","caption":"","name":"sparklinestrend-2","status":"inherit","uploaded_to":1788532,"date":"2022-12-07 21:33:52","modified":"2022-12-07 21:34:22","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":891,"height":653,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1.png","medium-width":356,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1.png","medium_large-width":768,"medium_large-height":563,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1.png","large-width":891,"large-height":653,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1.png","1536x1536-width":891,"1536x1536-height":653,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1.png","2048x2048-width":891,"2048x2048-height":653,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1-634x465.png","card_image-width":634,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/SparklinesTrend-1.png","wide_image-width":891,"wide_image-height":653}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Adding more context<\/h2>\n

Now that we\u2019ve looked at the areas that meet our criteria and looked at the trends over time I\u2019ve realized I want to show the 2026 Median home value prediction in the reference table as well. I can easily add this by selecting the field in the data pane and dragging it to the reference table.<\/p>\n

Again, all I see are too many numbers that are hard to pick out. With this I\u2019ll use another conditional formatting option: data bars. Once applied this gives me a visual of how each row compares to the other rows in the column, the highest value will have a bar that fills the whole column. This allows me to easily visualize where my high and low home values are.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1788812,"id":1788812,"title":"DataBarsImage","filename":"DataBarsImage-1.png","filesize":90067,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\/databarsimage-2","alt":"Shows a table with the Median Income column styled with Data bars and the conditional formatting styling window","author":"294792","description":"","caption":"","name":"databarsimage-2","status":"inherit","uploaded_to":1788532,"date":"2022-12-07 21:32:30","modified":"2022-12-07 21:33: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":891,"height":628,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1.png","medium-width":370,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1.png","medium_large-width":768,"medium_large-height":541,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1.png","large-width":891,"large-height":628,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1.png","1536x1536-width":891,"1536x1536-height":628,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1.png","2048x2048-width":891,"2048x2048-height":628,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1-660x465.png","card_image-width":660,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/DataBarsImage-1.png","wide_image-width":891,"wide_image-height":628}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

What we learned<\/h2>\n

In addition to the table I have a map styled show the 2026 Home value over income to give some visual context and added a predefined filter on the state field to narrow down the findings. With just these three components \u2013 the map, reference table and predefined filter we get so much information AND they work in collaboration. The interactivity between the cards allows for an even deeper analysis of the data, tying the spatial and nonspatial context together. We see the spatial trends and how areas near each other compare, the future trends of home value\/income, the areas that meet our criteria for house affordability and where we are seeing the highest median home values in 2026. Check out\u00a0the final report<\/a> and use it to see how different areas in the USA compare.<\/p>\n

I hope this helped you to see how much value you can get out of the reference table. Keep in mind there\u2019s even more the reference table has to offer. From different sparklines visuals such as columns and win loss, to column and table formatting to make your reference table look and act in exactly the way you need. I look forward to seeing what you can do with it!<\/p>\n

If you’re interested in learning more about the reference table check out the 5 Tips for Working with Reference Tables<\/a><\/p>\n"}],"authors":[{"ID":294792,"user_firstname":"Kate","user_lastname":"Maclachlan","nickname":"Kate Maclachlan","user_nicename":"k-maclachlan","display_name":"Kate MacLachlan","user_email":"k.maclachlan@esri.com","user_url":"","user_registered":"2021-12-03 18:37:13","user_description":"Kate is a product engineer on the ArcGIS Insights team with a background in geography and GIS. In the summer she can be found sailing the Ottawa river or hiking with her dog Reggie.","user_avatar":""}],"related_articles":[{"ID":970802,"post_author":"6771","post_date":"2020-08-10 12:53:33","post_date_gmt":"2020-08-10 19:53:33","post_content":"","post_title":"Create a report in ArcGIS Insights","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"create-report-insights","to_ping":"","pinged":"","post_modified":"2020-08-10 12:53:33","post_modified_gmt":"2020-08-10 19:53:33","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=970802","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1542432,"post_author":"305842","post_date":"2022-04-11 09:23:30","post_date_gmt":"2022-04-11 16:23:30","post_content":"","post_title":"Use ArcGIS Insights to Visualize American Community Survey Data","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"use-arcgis-insights-to-visualize-american-community-survey-data","to_ping":"","pinged":"","post_modified":"2022-04-13 06:28:33","post_modified_gmt":"2022-04-13 13:28:33","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1542432","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ReferenceTableCard.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ReferenceTableBanner.png"},"yoast_head":"\nLearning to love the reference table<\/title>\n<meta name=\"description\" content=\"See how you can use the reference table in ArcGIS Insights to draw out visual cues and dive deeper into your housing data.\" \/>\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\/insights\/analytics\/learning-to-love-the-reference-table\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learning to love the reference table\" \/>\n<meta property=\"og:description\" content=\"See how you can use the reference table in ArcGIS Insights to draw out visual cues and dive deeper into your housing data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\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\/insights\/analytics\/learning-to-love-the-reference-table#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\"},\"author\":{\"name\":\"Kate MacLachlan\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/50f0e3508a5e368f9c42262570d0a466\"},\"headline\":\"Learning to love the reference table\",\"datePublished\":\"2022-12-13T13:00:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\"},\"wordCount\":6,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS Insights\",\"data table\",\"housing affordability\",\"reference table\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\",\"name\":\"Learning to love the reference table\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2022-12-13T13:00:12+00:00\",\"description\":\"See how you can use the reference table in ArcGIS Insights to draw out visual cues and dive deeper into your housing data.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learning to love the reference table\"}]},{\"@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\/50f0e3508a5e368f9c42262570d0a466\",\"name\":\"Kate MacLachlan\",\"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\/2022\/01\/KateMacLachlan_HeadShot_UC-465x465.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/KateMacLachlan_HeadShot_UC-465x465.jpg\",\"caption\":\"Kate MacLachlan\"},\"description\":\"Kate is a product engineer on the ArcGIS Insights team with a background in geography and GIS. In the summer she can be found sailing the Ottawa river or hiking with her dog Reggie.\",\"sameAs\":[\"linkedin.com\/in\/kate-maclachlan\"],\"jobTitle\":\"product engineer\",\"url\":\"\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Learning to love the reference table","description":"See how you can use the reference table in ArcGIS Insights to draw out visual cues and dive deeper into your housing data.","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\/insights\/analytics\/learning-to-love-the-reference-table","og_locale":"en_US","og_type":"article","og_title":"Learning to love the reference table","og_description":"See how you can use the reference table in ArcGIS Insights to draw out visual cues and dive deeper into your housing data.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","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\/insights\/analytics\/learning-to-love-the-reference-table#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table"},"author":{"name":"Kate MacLachlan","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/50f0e3508a5e368f9c42262570d0a466"},"headline":"Learning to love the reference table","datePublished":"2022-12-13T13:00:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table"},"wordCount":6,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS Insights","data table","housing affordability","reference table"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table","name":"Learning to love the reference table","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2022-12-13T13:00:12+00:00","description":"See how you can use the reference table in ArcGIS Insights to draw out visual cues and dive deeper into your housing data.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/insights\/analytics\/learning-to-love-the-reference-table#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Learning to love the reference table"}]},{"@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\/50f0e3508a5e368f9c42262570d0a466","name":"Kate MacLachlan","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\/2022\/01\/KateMacLachlan_HeadShot_UC-465x465.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/01\/KateMacLachlan_HeadShot_UC-465x465.jpg","caption":"Kate MacLachlan"},"description":"Kate is a product engineer on the ArcGIS Insights team with a background in geography and GIS. In the summer she can be found sailing the Ottawa river or hiking with her dog Reggie.","sameAs":["linkedin.com\/in\/kate-maclachlan"],"jobTitle":"product engineer","url":""}]}},"text_date":"December 13, 2022","author_name":"Kate MacLachlan","author_page":false,"custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/ReferenceTableBanner.png","primary_product":"ArcGIS Insights","tag_data":[{"term_id":466322,"name":"ArcGIS Insights","slug":"arcgis-insights","term_group":0,"term_taxonomy_id":466322,"taxonomy":"post_tag","description":"","parent":0,"count":24,"filter":"raw"},{"term_id":763062,"name":"data table","slug":"data-table","term_group":0,"term_taxonomy_id":763062,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":280752,"name":"housing affordability","slug":"housing-affordability","term_group":0,"term_taxonomy_id":280752,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":768152,"name":"reference table","slug":"reference-table","term_group":0,"term_taxonomy_id":768152,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1329,"filter":"raw"}],"product_data":[{"term_id":36801,"name":"ArcGIS Insights","slug":"insights","term_group":0,"term_taxonomy_id":36801,"taxonomy":"product","description":"","parent":36591,"count":119,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=insights","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1788532","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\/294792"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1788532"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1788532\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1788532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1788532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1788532"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1788532"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1788532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}