{"id":1285722,"date":"2021-07-08T09:59:35","date_gmt":"2021-07-08T16:59:35","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1285722"},"modified":"2021-07-09T16:44:19","modified_gmt":"2021-07-09T23:44:19","slug":"enhancing-dashboard-elements-using-data-expressions-part-2","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2","title":{"rendered":"Enhancing dashboard elements using data expressions – Part 2"},"author":218642,"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":[761142,673891,573561,761132],"industry":[],"product":[36671],"class_list":["post-1285722","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-advanced-formatting","tag-arcgis-arcade","tag-arcgis-dashboards","tag-data-expressions","product-ops-dashboard"],"acf":{"short_description":"Follow along part 2 to learn how to take your data visualization to the next step using Arcade in data expressions and advanced formatting.","flexible_content":[{"acf_fc_layout":"content","content":"

In part 1<\/a>, we looked at how to leverage data expressions to combine three serial charts, each powered by a different data layer, into a single chart element. Now, let’s look at how to enhance a list by displaying data that just makes sense.<\/p>\n

Display current data and weekly trends using a list<\/h1>\n

Have you ever tried to create a list element using a\u00a0spatiotemporal\u00a0dataset and ended up with a list with repeating list items?<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1286282,"id":1286282,"title":"List configuration - Before","filename":"list-config-1-e1625692225160.png","filesize":203364,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\/list-config-1-2","alt":"List configuration - Before","author":"218642","description":"","caption":"","name":"list-config-1-2","status":"inherit","uploaded_to":1285722,"date":"2021-07-07 21:09:52","modified":"2021-07-07 21:10: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":2104,"height":1651,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-333x261.png","medium-width":333,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-768x603.png","medium_large-width":768,"medium_large-height":603,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-1376x1080.png","large-width":1376,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-1536x1205.png","1536x1536-width":1536,"1536x1536-height":1205,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-2048x1607.png","2048x2048-width":2048,"2048x2048-height":1607,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-593x465.png","card_image-width":593,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-1-e1625692225160-1376x1080.png","wide_image-width":1376,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

The data table that is driving the element above looks something like this:<\/span><\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1286292,"id":1286292,"title":"Data structure of list element - Before","filename":"Group-3.png","filesize":10282,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\/group-3-3","alt":"Data structure of list element - Before","author":"218642","description":"","caption":"","name":"group-3-3","status":"inherit","uploaded_to":1285722,"date":"2021-07-07 21:11:04","modified":"2021-07-07 21:11:26","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":684,"height":368,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","medium-width":464,"medium-height":250,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","medium_large-width":684,"medium_large-height":368,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","large-width":684,"large-height":368,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","1536x1536-width":684,"1536x1536-height":368,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","2048x2048-width":684,"2048x2048-height":368,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","card_image-width":684,"card_image-height":368,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Group-3.png","wide_image-width":684,"wide_image-height":368}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

What we want is a list that summarizes the vaccination status for each state, rather than one that simply displays the raw data. <\/span>By leveraging data expressions and advanced formatting<\/a>, <\/span>we can display useful metrics such as the latest vaccination status and weekly vaccination trends for each state.<\/span><\/span><\/p>\n

Access layer item as a FeatureSet <\/span>\u00a0<\/span><\/h2>\n

Like any data expression, we can access the portal item as a FeatureSet<\/a> using the <\/span>FeatureSetByPortalItem<\/a>\u00a0function.<\/span><\/p>\n

\/\/ Access data layer as a FeatureSet from the portal \r\nvar portal = Portal(\"https:\/\/www.arcgis.com\/\"); \r\nvar fs = FeatureSetByPortalItem(portal,\"570d812fd23a4fc981e028e9f1ed7275\",0,[\"date\",\"location\",\"daily_vaccinations\",\"people_vaccinated_per_hundred\",\"people_fully_vaccinated_per_hun\",],false); <\/code><\/pre>\n"},{"acf_fc_layout":"content","content":"
Then, we can create an empty dictionary<\/a> with defined field names and types to store feature attributes for our restructured FeatureSet.\u00a0<\/span><\/p>\n
\/\/ Create empty dictionary  \r\nvar dict = { \r\n  fields: [ \r\n    { name: \"location\", type: \"esriFieldTypeString\" }, \r\n    { name: \"current\", type: \"esriFieldTypeString\" }, \r\n    { name: \"week_ago\", type: \"esriFieldTypeString\" }, \r\n    { name: \"people_vaccinated_per_hundred\", type: \"esriFieldTypeDouble\" }, \r\n    { name: \"people_fully_vaccinated_per_hun\", type: \"esriFieldTypeDouble\" }, \r\n    { name: \"list_custom_order\", type: \"esriFieldTypeInteger\" } \r\n  ], \r\n  geometryType: \"\", \r\n  features: [], \r\n}; \r\n<\/code><\/pre>\n"},{"acf_fc_layout":"content","content":"
Now, we<\/span>\u00a0can utilize a series of\u00a0<\/span><\/span>Arcade functions<\/span><\/span><\/a> to query our data to compare the vaccination status according to the latest updates and from one week ago.\u00a0<\/span><\/span><\/p>\n
Find date values based on the existing date field<\/span><\/span><\/h2>\n
First, w<\/span>e can find the most current date using the<\/span>\u00a0<\/span><\/span>Max<\/span><\/span><\/a>\u00a0<\/span><\/span>function, then parse the value to a date object using the Date<\/span><\/a> function<\/span><\/span>.\u00a0<\/span>We can then <\/span>store the current date value in a variable, currentDate<\/code>. Using the<\/span>\u00a0<\/span><\/span>Text<\/span><\/span><\/a> function, we can convert the date value to the appropriate date format such as \"YYYY-MM-DD\"<\/code>for filtering later on. <\/span><\/span><\/p>\n
\/\/ Find the most current date from original FeatureSet\r\nvar currentDate = Text(Date(Max(fs, 'date')), \"YYYY-MM-DD\");\r\n<\/code><\/pre>\n
Now, we need to find out the date from exactly one week ago relative to currentDate<\/code>. To achieve that, <\/span>we can use the\u00a0<\/span><\/span>DateAdd<\/span><\/span><\/a> function, specifying the exact number of days to add to currentDate<\/code>. Finally, we can store the value in a variable,weekAgo<\/code>.<\/span><\/span>\u00a0<\/span><\/p>\n
\/\/ Find date from one week ago\r\nvar weekAgo = Text(DateAdd(currentDate, -7, \"days\"), \"YYYY-MM-DD\");\r\n<\/code><\/pre>\n"},{"acf_fc_layout":"content","content":"
Filter the FeatureSet by date<\/span>\u00a0<\/span><\/h2>\n
Using the Filter<\/a> function, we can filter the original FeatureSet based on the currentDate<\/code> and weekAgo<\/code> values in a SQL condition. As shown below, this will return two FeatureSets where the date<\/code> field matches currentDate<\/code> and weekAgo<\/code>, respectively.<\/p>\n
\/\/ Filter using currentDate value \r\nvar today = OrderBy(Filter(fs, \"(date = @currentDate) AND (location NOT IN ('Veterans Health','Dept of Defense','Federated States of Micronesia','Guam','Indian Health Svc','Long Term Care','American Samoa','Bureau of Prisons','Marshall Islands','Northern Mariana Islands','Puerto Rico','Republic of Palau','Virgin Islands'))\"), 'location'); \r\n\r\n\/\/ Filter using weekAgo to retrieve rows that correspond to a week ago \r\nvar lastWeek = OrderBy(Filter(fs, \"(date = @weekAgo) AND (location NOT IN ('Veterans Health','Dept of Defense','Federated States of Micronesia','Guam','Indian Health Svc','Long Term Care','American Samoa','Bureau of Prisons','Marshall Islands','Northern Mariana Islands','Puerto Rico','Republic of Palau','Virgin Islands'))\"), 'location'); <\/code><\/pre>\n"},{"acf_fc_layout":"content","content":"
Return filtered FeatureSet<\/span>\u00a0<\/span><\/h2>\n
Finally, we can use a nested for loop to iterate through the today<\/code> and lastWeek<\/code> FeatureSets. We store their features’ attributes in the empty dictionary, which we return as a FeatureSet to power the list element. <\/span>\u00a0<\/span><\/p>\n
\/\/ Loop through processed FeatureSet and store its attributes \r\nvar i = 0; \r\nfor (var t in today) { \r\n  var location = t[\"location\"]; \r\n  for (var l in lastWeek)  \r\n    if (l[\"location\"] == location) { \r\n      var feat = { \r\n        attributes: { \r\n          location: location, \r\n          current: t[\"daily_vaccinations\"], \r\n          week_ago: l[\"daily_vaccinations\"], \r\n          people_vaccinated_per_hundred: t[\"people_vaccinated_per_hundred\"], \r\n          people_fully_vaccinated_per_hun: t[\"people_fully_vaccinated_per_hun\"], \r\n          list_custom_order: IIf(l[\"location\"] != \"United States\", 1,0) \r\n        } \r\n      }; \r\n      dict.features[i] = feat; \r\n      break; \r\n    } \r\n  i++; \r\n} \r\nreturn OrderBy(FeatureSet(Text(dict)), \"list_custom_order\"); \r\n<\/code><\/pre>\n"},{"acf_fc_layout":"content","content":"
Below is a preview of the data table we constructed using data expressions, with the following fields:\u00a0<\/span><\/p>\n
location<\/code> – Name of the region or state<\/span>\u00a0<\/span><\/p>\n
current<\/code> – Most recent raw vaccination count <\/span>\u00a0<\/span><\/p>\n
week_ago<\/code> – Raw vaccination count from a week ago <\/span>\u00a0<\/span><\/p>\n
people_vaccinated_per_hundred<\/code> and people_fully_vaccinated_per_hun<\/code>– Latest metrics on the percentage of vaccinated populations<\/span>\u00a0<\/span><\/p>\n
list_custom_order<\/code>– Custom list order index (optional)<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1286372,"id":1286372,"title":"Restructured Dataset using Data Expressions","filename":"list-config-3-e1625698858534.png","filesize":222993,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\/list-config-3-2","alt":"Restructured Dataset using Data Expressions","author":"218642","description":"","caption":"","name":"list-config-3-2","status":"inherit","uploaded_to":1285722,"date":"2021-07-07 21:35:11","modified":"2021-07-07 21:35:35","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":2288,"height":1651,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-362x261.png","medium-width":362,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-768x554.png","medium_large-width":768,"medium_large-height":554,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-1497x1080.png","large-width":1497,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-1536x1108.png","1536x1536-width":1536,"1536x1536-height":1108,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-2048x1478.png","2048x2048-width":2048,"2048x2048-height":1478,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-644x465.png","card_image-width":644,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-3-e1625698858534-1497x1080.png","wide_image-width":1497,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
Configure list using Arcade advanced formatting <\/span>\u00a0<\/span>\u00a0<\/span><\/h2>\n
Now, from the enhanced data table, we want to extract three key metrics to display on our list:\u00a0<\/span>\u00a0<\/span><\/p>\n
    \n
  1. Percent of state population that received at least one dose\u00a0<\/span>\u00a0<\/span><\/li>\n
  2. Percent of state population that received two doses\u00a0<\/span><\/li>\n
  3. Weekly change\u00a0in\u00a0doses administered\u00a0<\/span>\u00a0<\/span><\/li>\n<\/ol>\n
    In this\u00a0last step, we will use advanced formatting to enhance the list content and layout.<\/span>\u00a0<\/span><\/p>\n
    From the List tab, we can enable Arcade and create an expression that controls the formatting properties of the list.\u00a0With advanced formatting, we can provide visual indicators such as\u00a0progress bars and arrows, as well as classifiers using different colors to communicate how each state is doing with regards to vaccination.\u00a0<\/span>\u00a0<\/span><\/p>\n
    Create a copy<\/a> of the\u00a0COVID vaccination status dashboard<\/a>\u00a0to see <\/span><\/span> how the list below was created using a combination of advanced formatting\u00a0and custom HTML.\u00a0<\/span><\/p>\n
    In addition, check out how else you can push the limits of this functionality in this blog <\/span>post<\/span><\/a>.\u00a0<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1286382,"id":1286382,"title":"List configuration - After","filename":"list-config-5.png","filesize":143262,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\/list-config-5-2","alt":"List configuration - After","author":"218642","description":"","caption":"","name":"list-config-5-2","status":"inherit","uploaded_to":1285722,"date":"2021-07-07 21:36:34","modified":"2021-07-07 21:36: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":3072,"height":1652,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5.png","medium-width":464,"medium-height":250,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5.png","medium_large-width":768,"medium_large-height":413,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5.png","large-width":1920,"large-height":1033,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5-1536x826.png","1536x1536-width":1536,"1536x1536-height":826,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5-2048x1101.png","2048x2048-width":2048,"2048x2048-height":1101,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5-826x444.png","card_image-width":826,"card_image-height":444,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/list-config-5-1920x1033.png","wide_image-width":1920,"wide_image-height":1033}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"
    Using data expressions, we were able to uncover key metrics from our dataset and visualize them in a meaningful and intuitive way. You now have more control over how to transform data to fulfill your specific dashboard requirements. I hope that you, too, can take your dashboards to the next level through the seamless integration of dashboard data expressions.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1286502,"id":1286502,"title":"COVID Vaccination Status Dashboard","filename":"dashboard-screenshot-2.png","filesize":268557,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\/dashboard-screenshot-2","alt":"COVID Vaccination Status Dashboard","author":"218642","description":"","caption":"","name":"dashboard-screenshot-2","status":"inherit","uploaded_to":1205192,"date":"2021-07-07 22:07:40","modified":"2021-07-07 22:07: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":3068,"height":1762,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2.png","medium-width":454,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2.png","medium_large-width":768,"medium_large-height":441,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2.png","large-width":1880,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2-1536x882.png","1536x1536-width":1536,"1536x1536-height":882,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2-2048x1176.png","2048x2048-width":2048,"2048x2048-height":1176,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2-810x465.png","card_image-width":810,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2-1880x1080.png","wide_image-width":1880,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""}],"authors":[{"ID":218642,"user_firstname":"Soobin","user_lastname":"Choi","nickname":"Soobin Choi","user_nicename":"schoi","display_name":"Soobin Choi","user_email":"schoi@esri.com","user_url":"","user_registered":"2021-04-12 20:35:24","user_description":"Soobin is a product engineer on the ArcGIS Dashboards team. She has a Master's in software engineering and a Bachelor's in Geography and Art. She is passionate about solving business problems using data visualization and maps.","user_avatar":""}],"related_articles":[{"ID":1205192,"post_author":"218642","post_date":"2021-07-08 09:56:40","post_date_gmt":"2021-07-08 16:56:40","post_content":"","post_title":"Enhancing dashboard elements using data expressions - Part 1","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"enhancing-dashboard-elements-using-data-expressions-part-1","to_ping":"","pinged":"","post_modified":"2021-07-09 16:44:59","post_modified_gmt":"2021-07-09 23:44:59","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1205192","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"2","filter":"raw"},{"ID":1201832,"post_author":"6461","post_date":"2021-05-06 10:30:05","post_date_gmt":"2021-05-06 17:30:05","post_content":"","post_title":"Add Context to your Dashboards using Data Expressions + Living Atlas","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"add-context-to-your-dashboards-using-data-expressions-living-atlas","to_ping":"","pinged":"","post_modified":"2021-05-06 10:33:13","post_modified_gmt":"2021-05-06 17:33:13","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1201832","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":797531,"post_author":"8482","post_date":"2022-02-27 10:00:48","post_date_gmt":"2022-02-27 18:00:48","post_content":"","post_title":"Getting started with advanced formatting using Arcade in Dashboards","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"getting-started-with-arcade-in-arcgis-dashboards","to_ping":"","pinged":"","post_modified":"2024-11-01 00:01:30","post_modified_gmt":"2024-11-01 07:01:30","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=797531","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/Screen-Shot-2021-07-09-at-4.33.07-PM.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2-1-scaled.png"},"yoast_head":"\nEnhancing dashboard elements using data expressions - Part 2<\/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\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enhancing dashboard elements using data expressions - Part 2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\" \/>\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=\"2021-07-09T23:44:19+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\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\"},\"author\":{\"name\":\"Soobin Choi\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/29471b4431cc3da9080be6d6315a8228\"},\"headline\":\"Enhancing dashboard elements using data expressions – Part 2\",\"datePublished\":\"2021-07-08T16:59:35+00:00\",\"dateModified\":\"2021-07-09T23:44:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\"},\"wordCount\":8,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Advanced Formatting\",\"ArcGIS Arcade\",\"arcgis dashboards\",\"Data Expressions\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\",\"name\":\"Enhancing dashboard elements using data expressions - Part 2\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2021-07-08T16:59:35+00:00\",\"dateModified\":\"2021-07-09T23:44:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Enhancing dashboard elements using data expressions – Part 2\"}]},{\"@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\/29471b4431cc3da9080be6d6315a8228\",\"name\":\"Soobin Choi\",\"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\/2021\/04\/Soobin-Choi-465x465.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Soobin-Choi-465x465.jpg\",\"caption\":\"Soobin Choi\"},\"description\":\"Soobin is a product engineer on the ArcGIS Dashboards team. She has a Master's in software engineering and a Bachelor's in Geography and Art. She is passionate about solving business problems using data visualization and maps.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/soobin-choi\/\"],\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/schoi\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Enhancing dashboard elements using data expressions - Part 2","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\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2","og_locale":"en_US","og_type":"article","og_title":"Enhancing dashboard elements using data expressions - Part 2","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2021-07-09T23:44:19+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\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2"},"author":{"name":"Soobin Choi","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/29471b4431cc3da9080be6d6315a8228"},"headline":"Enhancing dashboard elements using data expressions – Part 2","datePublished":"2021-07-08T16:59:35+00:00","dateModified":"2021-07-09T23:44:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2"},"wordCount":8,"commentCount":2,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Advanced Formatting","ArcGIS Arcade","arcgis dashboards","Data Expressions"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2","name":"Enhancing dashboard elements using data expressions - Part 2","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2021-07-08T16:59:35+00:00","dateModified":"2021-07-09T23:44:19+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Enhancing dashboard elements using data expressions – Part 2"}]},{"@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\/29471b4431cc3da9080be6d6315a8228","name":"Soobin Choi","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\/2021\/04\/Soobin-Choi-465x465.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Soobin-Choi-465x465.jpg","caption":"Soobin Choi"},"description":"Soobin is a product engineer on the ArcGIS Dashboards team. She has a Master's in software engineering and a Bachelor's in Geography and Art. She is passionate about solving business problems using data visualization and maps.","sameAs":["https:\/\/www.linkedin.com\/in\/soobin-choi\/"],"url":"https:\/\/www.esri.com\/arcgis-blog\/author\/schoi"}]}},"text_date":"July 8, 2021","author_name":"Soobin Choi","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/schoi","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/07\/dashboard-screenshot-2-1-scaled.png","primary_product":"ArcGIS Dashboards","tag_data":[{"term_id":761142,"name":"Advanced Formatting","slug":"advanced-formatting","term_group":0,"term_taxonomy_id":761142,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":673891,"name":"ArcGIS Arcade","slug":"arcgis-arcade","term_group":0,"term_taxonomy_id":673891,"taxonomy":"post_tag","description":"","parent":0,"count":12,"filter":"raw"},{"term_id":573561,"name":"arcgis dashboards","slug":"arcgis-dashboards","term_group":0,"term_taxonomy_id":573561,"taxonomy":"post_tag","description":"","parent":0,"count":39,"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"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1325,"filter":"raw"}],"product_data":[{"term_id":36671,"name":"ArcGIS Dashboards","slug":"ops-dashboard","term_group":0,"term_taxonomy_id":36671,"taxonomy":"product","description":"","parent":36591,"count":195,"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\/1285722","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\/218642"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1285722"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1285722\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1285722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1285722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1285722"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1285722"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1285722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}