{"id":1172052,"date":"2021-04-01T01:00:41","date_gmt":"2021-04-01T08:00:41","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1172052"},"modified":"2021-04-15T13:24:30","modified_gmt":"2021-04-15T20:24:30","slug":"how-to-make-that-app","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/how-to-make-that-app","title":{"rendered":"How to make that app: Census Agriculture Dashboard"},"author":7031,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[22941],"tags":[573561,42641,40161],"industry":[],"product":[36671,36551],"class_list":["post-1172052","blog","type-blog","status-publish","format-standard","hentry","category-mapping","tag-arcgis-dashboards","tag-arcgis-online","tag-living-atlas-of-the-world","product-ops-dashboard","product-arcgis-online"],"acf":{"short_description":"This blog will discuss how to create the Census Agriculture dashboard as seen in the 'Our Four Favorite Ways to Map American Agriculture' blog.","flexible_content":[{"acf_fc_layout":"content","content":"

In the blog, \u201cOur Four Favorite Ways to Map American Agriculture<\/a>\u201d, four ArcGIS Living Atlas colleagues discuss different methods to map agricultural data. This blog will discuss how to create the dashboard Top Counties Receiving Federal Agriculture Payments<\/a>.<\/p>\n

Every five years, the U.S. Department of Agriculture completes a census of all U.S. farms, ranches, and their operators with the most recent census conducted in 2017<\/a>. This gives us an in-depth look at the agricultural industry, including how the government distributed $8,943,574,000 in federal payments<\/a> to farms across the country.<\/p>\n

The dashboard takes a simple map showing Federal Payments – Receipts in US Dollars<\/a> and displays on-the-fly statistics about the layer using chart and list widgets so we can visualize where the money is being spent. The list widget on the upper left displays the top 50 largest federal payments. Selecting a county from the list will zoom into the county on the map and display the pop-up, which contains a breakdown of federal payments toward agriculture. The map also contains USA Cropland<\/a>, so when zoomed into a county, we can see what crops are grown in that area.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1156152,"id":1156152,"title":"legend_dash_crop","filename":"legend_dash_crop.jpg","filesize":360902,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-living-atlas\/mapping\/our-four-favorite-ways-to-map-american-agriculture\/legend_dash_crop","alt":"","author":"7031","description":"","caption":"","name":"legend_dash_crop","status":"inherit","uploaded_to":1147212,"date":"2021-03-04 17:30:38","modified":"2021-03-04 17:30:38","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1920,"height":1080,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop.jpg","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop.jpg","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop.jpg","large-width":1920,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop-1536x864.jpg","1536x1536-width":1536,"1536x1536-height":864,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop.jpg","2048x2048-width":1920,"2048x2048-height":1080,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop-826x465.jpg","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/legend_dash_crop.jpg","wide_image-width":1920,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Below the list widget is a serial bar chart depicting total federal payments by state. The chart is also interactive. By selecting the bar for Texas, both the map and the list filter to show only Texas features. Start exploring below!<\/p>\n"},{"acf_fc_layout":"storymap","title":"","description":"","static":false,"storymap_url":"https:\/\/www.arcgis.com\/apps\/dashboards\/7072acbcd70d4f10a69929f7e4f0b2a8<\/a>"},{"acf_fc_layout":"content","content":"

<\/h1>\n

How to make this dashboard?<\/h1>\n

There are five overall steps to create the census agriculture dashboard. You can also follow along by creating your own copy<\/a>.<\/p>\n

Step 1: Open Dashboards<\/h1>\n

First, let\u2019s get some pre-requisites out of the way. ArcGIS Dashboards requires maps to be added from \u2018My Content\u2019 or via shared groups. To use the Federal Payments map<\/a>, save a copy to \u2018My Content\u2019 as detailed in this documentation<\/a>. Now we are ready to begin. Open ArcGIS Dashboards from \u2018My Content\u2019 using the App selector in the upper right-hand corner, select Dashboards<\/a>, and ‘create dashboard’.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1200912,"id":1200912,"title":"open_dash_gif_nobeta","filename":"open_dash_gif_nobeta.gif","filesize":383342,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta.gif","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/how-to-make-that-app\/open_dash_gif_nobeta","alt":"","author":"7031","description":"","caption":"","name":"open_dash_gif_nobeta","status":"inherit","uploaded_to":1172052,"date":"2021-04-15 20:23:19","modified":"2021-04-15 20:23:19","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":1920,"height":1080,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta-213x200.gif","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta.gif","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta.gif","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta.gif","large-width":1920,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta-1536x864.gif","1536x1536-width":1536,"1536x1536-height":864,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta.gif","2048x2048-width":1920,"2048x2048-height":1080,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta-826x465.gif","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/open_dash_gif_nobeta.gif","wide_image-width":1920,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Step 2: Add the map<\/h1>\n

To begin, add the map widget. This provides a good starting point for the dashboard because any layers included in the map will be readily available as data sources for additional widgets. To add our Federal Payments map, select the \u2018+\u2019 then Map, and choose the map from \u2018My Content\u2019. Turn on any capabilities you want the interface to have such as legend, bookmarks, or zoom, and select \u2018Done\u2019.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1172302,"id":1172302,"title":"map_widget","filename":"map_widget.png","filesize":48101,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/how-to-make-that-app\/map_widget","alt":"","author":"7031","description":"","caption":"","name":"map_widget","status":"inherit","uploaded_to":1172052,"date":"2021-03-24 23:08:53","modified":"2021-03-24 23:08:53","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":1920,"height":1080,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget.png","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget.png","large-width":1920,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget-1536x864.png","1536x1536-width":1536,"1536x1536-height":864,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget.png","2048x2048-width":1920,"2048x2048-height":1080,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget-826x465.png","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/map_widget.png","wide_image-width":1920,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/arcgis-content.maps.arcgis.com\/sharing\/rest\/content\/items\/ca2a13abd602468981aafb0f12560810\/data"},{"acf_fc_layout":"content","content":"

Step 3: Add the list<\/h1>\n

Next, let\u2019s add the ordered list widget by selecting List from the dropdown and \u2018USDA Census of Agriculture 2017 – Federal Payments\u2019 as the layer. The list simply shows which counties have received the largest federal payments. For conciseness, the maximum features displayed is set to 50. Set the \u2018Sort by\u2019 field to GOVT PROGRAMS, FEDERAL – RECEIPTS, MEASURED IN $<\/strong> in descending order.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1172832,"id":1172832,"title":"list1_widget","filename":"list1_widget.png","filesize":27505,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/how-to-make-that-app\/list1_widget","alt":"","author":"7031","description":"","caption":"","name":"list1_widget","status":"inherit","uploaded_to":1172052,"date":"2021-03-25 15:51:52","modified":"2021-03-25 15:51:52","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":1920,"height":1080,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget.png","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget.png","large-width":1920,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget-1536x864.png","1536x1536-width":1536,"1536x1536-height":864,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget.png","2048x2048-width":1920,"2048x2048-height":1080,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget-826x465.png","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list1_widget.png","wide_image-width":1920,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/arcgis-content.maps.arcgis.com\/sharing\/rest\/content\/items\/483d2879055e4ed9a8b5447cb90e387a\/data"},{"acf_fc_layout":"content","content":"

You\u2019ll notice the list adjusts on-the-fly but does not show the actual payment amount instead defaulting to Object ID. This can be remedied by adjusting the \u2018Line Item Template\u2019 section on the List tab. Change the template to: ‘{county_name} County, {state_name} ${GOVT_PROGRAMS_FEDERAL_RECEIPTS_}<\/strong>‘. Now the list has meaning, and we can verify that our settings are correct.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1172522,"id":1172522,"title":"list_widget","filename":"list_widget-1.png","filesize":50636,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/how-to-make-that-app\/list_widget-2","alt":"","author":"7031","description":"","caption":"","name":"list_widget-2","status":"inherit","uploaded_to":1172052,"date":"2021-03-25 00:07:31","modified":"2021-03-25 00:07:31","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":1920,"height":1080,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1.png","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1.png","large-width":1920,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1-1536x864.png","1536x1536-width":1536,"1536x1536-height":864,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1.png","2048x2048-width":1920,"2048x2048-height":1080,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1-826x465.png","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/list_widget-1.png","wide_image-width":1920,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/arcgis-content.maps.arcgis.com\/sharing\/rest\/content\/items\/e61ec3f6d5ce4d29a3c0cf6a4e49d86b\/data"},{"acf_fc_layout":"content","content":"

Lastly, it is important to set the list actions. This makes the widget interactive with the map in the dashboard. On the \u2018Actions\u2019 tab, set the Zoom, Flash, Show Pop-up action on the Agriculture Federal Payments layer. Click \u2018Done\u2019 on the lower right and select an item in the list to test the functionality and explore the map.<\/p>\n

Step 4: Add the serial chart<\/h1>\n

Last but not least \u2013 the serial chart. The purpose of this chart is to sum county values by their state, grouping the values together. With this theory in mind, use \u2018Grouped Values\u2019 for the \u2018Category From\u2018 input and State_Name as the \u2018Category Field\u2019. The statistic we want to sum is again the GOVT PROGRAMS, FEDERAL – RECEIPTS, MEASURED IN $<\/strong> field, third on the list. This gives us the total federal payments for each state. For clarity, I chose a maximum of 10 categories sorted in descending order by the statistic (i.e. sum) to show only the top ten states receiving the largest payments.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1172862,"id":1172862,"title":"serial_widget","filename":"serial_widget-1.png","filesize":34322,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/how-to-make-that-app\/serial_widget-2","alt":"","author":"7031","description":"","caption":"","name":"serial_widget-2","status":"inherit","uploaded_to":1172052,"date":"2021-03-25 15:56:04","modified":"2021-03-25 15:56:04","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":1920,"height":1080,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1.png","medium_large-width":768,"medium_large-height":432,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1.png","large-width":1920,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1-1536x864.png","1536x1536-width":1536,"1536x1536-height":864,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1.png","2048x2048-width":1920,"2048x2048-height":1080,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1-826x465.png","card_image-width":826,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/serial_widget-1.png","wide_image-width":1920,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/arcgis-content.maps.arcgis.com\/sharing\/rest\/content\/items\/4daacdb9281a4622baf141cfc9246de4\/data"},{"acf_fc_layout":"content","content":"

Time to set actions and make the chart interactive. Using the default \u2018Single\u2019 selection mode, set a Filter on both the layer and List. Close the widget configuration and test that the filter is working properly.<\/p>\n

Step 5: Design<\/h1>\n

Functionally, the Top Counties Receiving Federal Agriculture Payments dashboard is complete. However, you will probably notice that your dashboard does not look quite the same as the original. Dashboard has many additional design configurations such as light or dark mode and background colors. Each widget configuration has additional settings to adjust font, colors, titles, descriptions, and more. Widgets can also be size adjusted, stacked, or docked into different positions.<\/p>\n

Make the dashboard your own and explore the multitude of design settings. You may wish to make the dashboard compliment the map as in this example, or maybe match the theme to your organization\u2019s preferred color scheme. Check out this gallery<\/a> for more inspiration.<\/p>\n

More information<\/h1>\n