{"id":1687652,"date":"2022-08-17T06:21:45","date_gmt":"2022-08-17T13:21:45","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1687652"},"modified":"2022-08-17T07:41:45","modified_gmt":"2022-08-17T14:41:45","slug":"two-ways-to-make-a-grouped-list-for-your-dashboards","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards","title":{"rendered":"Two ways to make a grouped list for your dashboards"},"author":10072,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[22941],"tags":[32551,761132,766932,766922,28811],"industry":[],"product":[36591,36671],"class_list":["post-1687652","blog","type-blog","status-publish","format-standard","hentry","category-mapping","tag-arcade","tag-data-expressions","tag-grouped-values","tag-list","tag-table","product-apps","product-ops-dashboard"],"acf":{"short_description":"Check out two tricks for getting a grouped value list in your dashboard. ","flexible_content":[{"acf_fc_layout":"content","content":"

Adding a <\/span>list<\/span><\/a> to your dashboard is a great way to show features or rows from a layer. Lists can show field values, unique text, images, and more – but using the out-of-the box configuration, lists cannot be configured to use grouped values (like charts can). <\/span>\u00a0<\/span><\/p>\n

For example, I have data for homeless shelters around the city of Toronto. I want a list of the organizations that I can use to filter the map by, but since multiple shelters are run by the same organization, they repeat in the list. <\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1687662,"id":1687662,"title":"raw list","filename":"raw-list.png","filesize":25101,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\/raw-list","alt":"ungrouped list of homeless shelters in Toronto","author":"10072","description":"","caption":"","name":"raw-list","status":"inherit","uploaded_to":1687652,"date":"2022-08-16 18:23:07","modified":"2022-08-16 18:23:46","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":970,"height":845,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list.png","medium-width":300,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list.png","medium_large-width":768,"medium_large-height":669,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list.png","large-width":970,"large-height":845,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list.png","1536x1536-width":970,"1536x1536-height":845,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list.png","2048x2048-width":970,"2048x2048-height":845,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list-534x465.png","card_image-width":534,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/raw-list.png","wide_image-width":970,"wide_image-height":845}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

There are two ways that I can get a list with all the organizations grouped. <\/span>\u00a0<\/span><\/p>\n

Using a table<\/span>\u00a0<\/span><\/h2>\n

The quickest way to make a grouped value list for your dashboard is to make a single column <\/span>table<\/span><\/a>. Add a table to your dashboard and choose the <\/span>Grouped values<\/span><\/b> table type<\/span><\/a>, then choose the category field you want to group by (in this case, the organization name). <\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1687702,"id":1687702,"title":"grouped value table","filename":"grouped-value-table.png","filesize":23736,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\/grouped-value-table","alt":"single column table of shelter organizations","author":"10072","description":"","caption":"","name":"grouped-value-table","status":"inherit","uploaded_to":1687652,"date":"2022-08-16 18:30:19","modified":"2022-08-16 18:30:44","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":1005,"height":822,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table.png","medium-width":319,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table.png","medium_large-width":768,"medium_large-height":628,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table.png","large-width":1005,"large-height":822,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table.png","1536x1536-width":1005,"1536x1536-height":822,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table.png","2048x2048-width":1005,"2048x2048-height":822,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table-569x465.png","card_image-width":569,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/grouped-value-table.png","wide_image-width":1005,"wide_image-height":822}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Don\u2019t add any value fields \u2013 and there you have it,\u00a0a grouped value list.<\/span>\u00a0<\/span><\/p>\n

You can then use the table\u2019s configuration options to determine how your new \u2018list\u2019 looks and enable a filter action<\/a> targeting the map. <\/span>\u00a0<\/span><\/p>\n

Using a data expression<\/span><\/h2>\n

Another option for creating a grouped value list is to <\/span>create a new data expression<\/span><\/a> that is then used as the data source for your list. The data expression uses the <\/span>GroupBy<\/span><\/a> function to calculate multiple statistics based on a chosen category field.<\/span>\u00a0<\/span><\/p>\n

So, for my same layer, I can create the following data expression:<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"","image_reference":false,"layout":"code_snippet","image_reference_figure":"","snippet":"var portal = Portal('https:\/\/www.arcgis.com\/'); \r\nvar fs = FeatureSetByPortalItem( \r\n portal, \r\n 'fba03aff39264b8bb28c6afc855a738f', \r\n 0, \r\n [ \r\n \u2018ORGANIZATION_NAME', \r\n \u2018OCCUPANCY', \r\n 'CAPACITY', \r\n ], \r\n False \/\/don\u2019t include geometry \r\n); \r\n\r\nreturn GroupBy(fs, ['ORGANIZATION_NAME'], \r\n[{name: 'Max Capacity', expression: 'CAPACITY', statistic: 'MAX'}, \r\n{name: 'Average Occupancy', expression: 'OCCUPANCY', statistic: 'AVG'}]) ","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

The expression is taking the same feature layer (referenced by the itemID) and the fields from the layer that I want (occupancy, organization name, and capacity), and returning a <\/span>FeatureSet<\/span><\/a> that is grouped by the organization name field in my layer and returning a few statistics as well (the maximum capacity, and the average occupancy). <\/span>\u00a0<\/span><\/p>\n

I can then use the data expression as the data source for my list.<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1687742,"id":1687742,"title":"select layer","filename":"select-layer.png","filesize":8165,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\/select-layer","alt":"data expression on select a layer screen","author":"10072","description":"","caption":"","name":"select-layer","status":"inherit","uploaded_to":1687652,"date":"2022-08-16 18:32:35","modified":"2022-08-16 18:32:50","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":1016,"height":415,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer.png","medium-width":464,"medium-height":190,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer.png","medium_large-width":768,"medium_large-height":314,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer.png","large-width":1016,"large-height":415,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer.png","1536x1536-width":1016,"1536x1536-height":415,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer.png","2048x2048-width":1016,"2048x2048-height":415,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer-826x337.png","card_image-width":826,"card_image-height":337,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/select-layer.png","wide_image-width":1016,"wide_image-height":415}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Then, in my list configuration, I can use the ORGANIZATION_NAME<\/code> field from my FeatureSet in the <\/span>Line item template<\/span><\/b>. <\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1687752,"id":1687752,"title":"list config","filename":"list-config.png","filesize":25958,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\/list-config-7","alt":"list configuration options","author":"10072","description":"","caption":"","name":"list-config-7","status":"inherit","uploaded_to":1687652,"date":"2022-08-16 18:33:49","modified":"2022-08-16 18:34:12","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":977,"height":816,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config.png","medium-width":312,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config.png","medium_large-width":768,"medium_large-height":641,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config.png","large-width":977,"large-height":816,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config.png","1536x1536-width":977,"1536x1536-height":816,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config.png","2048x2048-width":977,"2048x2048-height":816,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config-557x465.png","card_image-width":557,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/list-config.png","wide_image-width":977,"wide_image-height":816}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

The list can then be used to filter the map. All that I need to do is choose the field from my list\u2019s data source (the <\/span>FeatureSet<\/span> created with the data expressions) and the matching field in my map\u2019s layer.<\/span><\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1687762,"id":1687762,"title":"action mapping","filename":"action-mapping.png","filesize":24996,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\/action-mapping","alt":"field mapping in list action configuration","author":"10072","description":"","caption":"","name":"action-mapping","status":"inherit","uploaded_to":1687652,"date":"2022-08-16 18:34:32","modified":"2022-08-16 18:35: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":948,"height":757,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping.png","medium-width":327,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping.png","medium_large-width":768,"medium_large-height":613,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping.png","large-width":948,"large-height":757,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping.png","1536x1536-width":948,"1536x1536-height":757,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping.png","2048x2048-width":948,"2048x2048-height":757,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping-582x465.png","card_image-width":582,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/action-mapping.png","wide_image-width":948,"wide_image-height":757}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

There you have it \u2013 two ways to create a grouped value list. Try these strategies with your own data and dashboards.\u00a0As always, we love seeing the creative workflows you use for your dashboards. If you can, share them with us on Twitter and LinkedIn using #ArcGISDashboards. \u00a0<\/span>\u00a0<\/span><\/p>\n"}],"authors":[{"ID":10072,"user_firstname":"Noora","user_lastname":"Golabi","nickname":"ngolabi","user_nicename":"ngolabi","display_name":"Noora Golabi","user_email":"ngolabi@esri.com","user_url":"","user_registered":"2019-10-21 16:04:20","user_description":"Noora is a product writer with a background in Geography and GIS. Working from Ottawa, Canada, she focuses on writing documentation and creating resources for users. In her free time, she's often baking, exploring the outdoors, and spending time with her dog.","user_avatar":""}],"related_articles":"","card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/pankaj-patel-eygpU6KfOBk-unsplash.jpg","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/pankaj-patel-eygpU6KfOBk-unsplash_banner.jpg"},"yoast_head":"\nTwo ways to make a grouped list for your dashboards<\/title>\n<meta name=\"description\" content=\"Use a single column grouped value table or an arcade data expressions to create a grouped value list for your dashboards.\" \/>\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\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Two ways to make a grouped list for your dashboards\" \/>\n<meta property=\"og:description\" content=\"Use a single column grouped value table or an arcade data expressions to create a grouped value list for your dashboards.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\" \/>\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=\"2022-08-17T14:41:45+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\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\"},\"author\":{\"name\":\"Noora Golabi\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/d6d26bb8da3387354ff0b0189d79f68d\"},\"headline\":\"Two ways to make a grouped list for your dashboards\",\"datePublished\":\"2022-08-17T13:21:45+00:00\",\"dateModified\":\"2022-08-17T14:41:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\"},\"wordCount\":10,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"arcade\",\"Data Expressions\",\"grouped values\",\"list\",\"table\"],\"articleSection\":[\"Mapping\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\",\"name\":\"Two ways to make a grouped list for your dashboards\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2022-08-17T13:21:45+00:00\",\"dateModified\":\"2022-08-17T14:41:45+00:00\",\"description\":\"Use a single column grouped value table or an arcade data expressions to create a grouped value list for your dashboards.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Two ways to make a grouped list for your dashboards\"}]},{\"@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\/d6d26bb8da3387354ff0b0189d79f68d\",\"name\":\"Noora Golabi\",\"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\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg\",\"caption\":\"Noora Golabi\"},\"description\":\"Noora is a product writer with a background in Geography and GIS. Working from Ottawa, Canada, she focuses on writing documentation and creating resources for users. In her free time, she's often baking, exploring the outdoors, and spending time with her dog.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/ngolabi\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Two ways to make a grouped list for your dashboards","description":"Use a single column grouped value table or an arcade data expressions to create a grouped value list for your dashboards.","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\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards","og_locale":"en_US","og_type":"article","og_title":"Two ways to make a grouped list for your dashboards","og_description":"Use a single column grouped value table or an arcade data expressions to create a grouped value list for your dashboards.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2022-08-17T14:41:45+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\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards"},"author":{"name":"Noora Golabi","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/d6d26bb8da3387354ff0b0189d79f68d"},"headline":"Two ways to make a grouped list for your dashboards","datePublished":"2022-08-17T13:21:45+00:00","dateModified":"2022-08-17T14:41:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards"},"wordCount":10,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["arcade","Data Expressions","grouped values","list","table"],"articleSection":["Mapping"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards","name":"Two ways to make a grouped list for your dashboards","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2022-08-17T13:21:45+00:00","dateModified":"2022-08-17T14:41:45+00:00","description":"Use a single column grouped value table or an arcade data expressions to create a grouped value list for your dashboards.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/mapping\/two-ways-to-make-a-grouped-list-for-your-dashboards#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Two ways to make a grouped list for your dashboards"}]},{"@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\/d6d26bb8da3387354ff0b0189d79f68d","name":"Noora Golabi","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\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg","caption":"Noora Golabi"},"description":"Noora is a product writer with a background in Geography and GIS. Working from Ottawa, Canada, she focuses on writing documentation and creating resources for users. In her free time, she's often baking, exploring the outdoors, and spending time with her dog.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/ngolabi"}]}},"text_date":"August 17, 2022","author_name":"Noora Golabi","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/ngolabi","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/pankaj-patel-eygpU6KfOBk-unsplash_banner.jpg","primary_product":"ArcGIS Dashboards","tag_data":[{"term_id":32551,"name":"arcade","slug":"arcade","term_group":0,"term_taxonomy_id":32551,"taxonomy":"post_tag","description":"","parent":0,"count":113,"filter":"raw"},{"term_id":761132,"name":"Data Expressions","slug":"data-expressions","term_group":0,"term_taxonomy_id":761132,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":766932,"name":"grouped values","slug":"grouped-values","term_group":0,"term_taxonomy_id":766932,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":766922,"name":"list","slug":"list","term_group":0,"term_taxonomy_id":766922,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":28811,"name":"table","slug":"table","term_group":0,"term_taxonomy_id":28811,"taxonomy":"post_tag","description":"","parent":0,"count":7,"filter":"raw"}],"category_data":[{"term_id":22941,"name":"Mapping","slug":"mapping","term_group":0,"term_taxonomy_id":22941,"taxonomy":"category","description":"","parent":0,"count":2699,"filter":"raw"}],"product_data":[{"term_id":36591,"name":"Apps","slug":"apps","term_group":0,"term_taxonomy_id":36591,"taxonomy":"product","description":"","parent":0,"count":649,"filter":"raw"},{"term_id":36671,"name":"ArcGIS Dashboards","slug":"ops-dashboard","term_group":0,"term_taxonomy_id":36671,"taxonomy":"product","description":"","parent":36591,"count":196,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=ops-dashboard","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1687652","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\/10072"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1687652"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1687652\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1687652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1687652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1687652"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1687652"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1687652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}