{"id":1205192,"date":"2021-07-08T09:56:40","date_gmt":"2021-07-08T16:56:40","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1205192"},"modified":"2021-07-09T16:44:59","modified_gmt":"2021-07-09T23:44:59","slug":"enhancing-dashboard-elements-using-data-expressions-part-1","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1","title":{"rendered":"Enhancing dashboard elements using data expressions &#8211; Part 1"},"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":[673891,573561,532642,761132],"industry":[],"product":[36671],"class_list":["post-1205192","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-arcgis-arcade","tag-arcgis-dashboards","tag-dashboard-design","tag-data-expressions","product-ops-dashboard"],"acf":{"short_description":"Learn how you can leverage data expressions to power and enhance data visualization on your dashboard.","flexible_content":[{"acf_fc_layout":"content","content":"<p><span data-contrast=\"auto\">Data comes in all shapes and sizes.\u00a0Sometimes, despite our best intentions, the structure of the data that we use poses various challenges that hinder us from building our ideal dashboard.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">With <\/span><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/\"><span data-contrast=\"none\">dashboard\u00a0data\u00a0expressions<\/span><\/a><span data-contrast=\"auto\">, dashboard authors will be equipped with the power to reconstruct datasets to drive any dashboard element.\u00a0From combining multiple datasets in a chart to extracting only relevant records to display in a list, data expressions extend the capabilities of dashboards to a whole new level. If you are new to this concept,\u00a0get started by watching the following video\u00a0<\/span><span data-contrast=\"auto\">for a\u00a0sneak peek of what\u00a0we will cover in this post.\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"youtube","start_time":"0","end_time":"","youtube_video_url":"<iframe title=\"ArcGIS Dashboards\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/0TGKNSIb0H0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>"},{"acf_fc_layout":"content","content":"<p style=\"text-align: center\"><a href=\"https:\/\/www.youtube.com\/watch?v=0TGKNSIb0H0\"><em>Click here to open in YouTube<\/em><\/a><\/p>\n<p><span class=\"TextRun SCXW163610048 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW163610048 BCX0\">At the end of this two-part blog post, you will\u00a0<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\">have learned how to author\u00a0<\/span><\/span><a class=\"Hyperlink SCXW163610048 BCX0\" href=\"https:\/\/www.arcgis.com\/apps\/dashboards\/26fe7750a29240a78101820e44039abd\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined SCXW163610048 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW163610048 BCX0\" data-ccp-charstyle=\"Hyperlink\">this\u00a0<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\" data-ccp-charstyle=\"Hyperlink\">dashboard,<\/span><\/span><\/a><span class=\"TextRun SCXW163610048 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW163610048 BCX0\">\u00a0th<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\">at visualizes the current state of COVID-19 vaccinations for each state and across the United States. Follow along\u00a0<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\">part I to\u00a0<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\">learn how you can visualize data\u00a0<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\">from<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\">\u00a0multiple data sources<\/span><span class=\"NormalTextRun SCXW163610048 BCX0\">\u00a0using data expressions.<\/span><\/span><span class=\"EOP SCXW163610048 BCX0\" data-ccp-props=\"{}\">\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":""},{"acf_fc_layout":"content","content":"<h1>Combine multiple datasets to create a stacked chart<\/h1>\n<p><span class=\"TextRun SCXW222576451 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW222576451 BCX0\">Below is a group of serial charts that show how many vaccinations each manufacturer\u00a0<\/span><span class=\"NormalTextRun SCXW222576451 BCX0\">allocated<\/span><span class=\"NormalTextRun SCXW222576451 BCX0\">\u00a0per week. Behind each serial chart is a feature service layer\u00a0<\/span><span class=\"NormalTextRun SCXW222576451 BCX0\">containing<\/span><span class=\"NormalTextRun SCXW222576451 BCX0\">\u00a0vaccine data specific to that manufacturer.<\/span><\/span><span class=\"EOP SCXW222576451 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1205352,"id":1205352,"title":"Serial charts showing vaccination allocation by different manufacturers","filename":"serial-chart-before.png","filesize":54020,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\/serial-chart-before","alt":"Serial charts showing vaccination allocation by different manufacturers","author":"218642","description":"","caption":"Serial charts showing vaccination allocation by different manufacturers","name":"serial-chart-before","status":"inherit","uploaded_to":1205192,"date":"2021-04-20 21:45:55","modified":"2021-04-20 21:46:39","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":2022,"height":572,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before.png","medium-width":464,"medium-height":131,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before.png","medium_large-width":768,"medium_large-height":217,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before.png","large-width":1920,"large-height":543,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before-1536x435.png","1536x1536-width":1536,"1536x1536-height":435,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before.png","2048x2048-width":2022,"2048x2048-height":572,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before-826x234.png","card_image-width":826,"card_image-height":234,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-before-1920x543.png","wide_image-width":1920,"wide_image-height":543}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><span class=\"TextRun SCXW211997906 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW211997906 BCX0\">Using\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">data expressions, users\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">now\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">have the flexibility\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">of combining datasets from separate feature layers to power a single dashboard element<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">.<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">To combine our data<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">,\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">we will first\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">group<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0each dataset based on the manufacturer name (<\/span><span class=\"NormalTextRun ContextualSpellingAndGrammarErrorV2 SCXW211997906 BCX0\">i.e.<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">Moderna<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">, Pfizer, and Janssen)\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">and<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0calculate how many\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">total<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0doses were\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">allocated<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0each week.\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">The diagram below\u00a0<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">demonstrates<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0such<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">\u00a0data transformation<\/span><span class=\"NormalTextRun SCXW211997906 BCX0\">.<\/span><\/span><span class=\"EOP SCXW211997906 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1205362,"id":1205362,"title":"Combine three data tables into one","filename":"Group-1.png","filesize":35343,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\/group-1","alt":"Combine three data tables into one","author":"218642","description":"","caption":"Combine three data tables into one","name":"group-1","status":"inherit","uploaded_to":1205192,"date":"2021-04-20 21:47:20","modified":"2021-04-20 21:47:39","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":768,"height":1296,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1.png","medium-width":155,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1.png","medium_large-width":768,"medium_large-height":1296,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1.png","large-width":640,"large-height":1080,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1.png","1536x1536-width":768,"1536x1536-height":1296,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1.png","2048x2048-width":768,"2048x2048-height":1296,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1-276x465.png","card_image-width":276,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-1-640x1080.png","wide_image-width":640,"wide_image-height":1080}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Now let\u2019s see how we can achieve this using data expressions.<\/p>\n<h2>Access each layer item as a FeatureSet<\/h2>\n<p><span class=\"TextRun SCXW42122263 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW42122263 BCX0\">First, we can use<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0the<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<\/span><\/span><a class=\"Hyperlink SCXW42122263 BCX0\" href=\"https:\/\/developers.arcgis.com\/arcade\/function-reference\/data_functions\/#featuresetbyportalitem\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined MacChromeBold SCXW42122263 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW42122263 BCX0\" data-ccp-charstyle=\"Hyperlink\">FeatureSetByPortalItem<\/span><\/span><\/a><span class=\"TextRun SCXW42122263 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">function<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0to access each layer item<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0as a\u00a0<\/span><span class=\"NormalTextRun SpellingErrorV2 SCXW42122263 BCX0\">FeatureSet<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">.<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">We can then use the<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<\/span><\/span><a class=\"Hyperlink SCXW42122263 BCX0\" href=\"https:\/\/developers.arcgis.com\/arcade\/function-reference\/data_functions\/#groupby\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined MacChromeBold SCXW42122263 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW42122263 BCX0\" data-ccp-charstyle=\"Hyperlink\">GroupBy<\/span><\/span><\/a><span class=\"TextRun SCXW42122263 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0function<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0to<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">aggregate<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\"> features based on the<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<code>week_of_allocations<\/code> <\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">to calculate\u00a0<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">the\u00a0<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">sum\u00a0<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">of first and follow-up doses<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">allocate<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">d<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0by each manufacturer<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">.<\/span><span class=\"NormalTextRun SCXW42122263 BCX0\">\u00a0<\/span><\/span><span class=\"EOP SCXW42122263 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<pre><code>var portal = Portal(\"https:\/\/www.arcgis.com\/\"); \r\nvar moderna = GroupBy( \r\n  FeatureSetByPortalItem(portal,\"a30a91d7ef394aca83ea8f6ca8e2130e\",0,[\"*\"],false), \r\n  [\"week_of_allocations\"], \r\n  [ \r\n    { name: \"moderna_1\", expression: \"F_1st_dose_allocations\", statistic: \"SUM\" }, \r\n    { name: \"moderna_2\", expression: \"F_2nd_dose_allocations\", statistic: \"SUM\" }, \r\n    { name: \"count_of_doses\" ,expression: \"F_1st_dose_allocations+F_2nd_dose_allocations\", statistic:\"SUM\" } \r\n  ] \r\n); \r\n\r\nvar pfizer = GroupBy( \r\n  FeatureSetByPortalItem(portal,\"eb84b1b87bcb4a79b6dd39b9f64910b0\",0,[\"*\"],false), \r\n  [\"week_of_allocations\"], \r\n  [ \r\n    { name: \"pfizer_1\", expression: \"F_1st_dose_allocations\", statistic: \"SUM\" }, \r\n    { name: \"pfizer_2\", expression: \"\tF_2nd_dose_allocations\", statistic: \"SUM\" }, \r\n    { name: \"count_of_doses\" ,expression: \"F_1st_dose_allocations+F_2nd_dose_allocations\", statistic:\"SUM\" } \r\n  ] \r\n);\r\n\r\nvar janssen = GroupBy( \r\n  FeatureSetByPortalItem(portal,\"f2607276692c471d941a95adc043a4a5\",0,[\"*\"],false), \r\n  [\"week_of_allocations\"], \r\n  [{ name: \"janssen\", expression: \"F_1st_dose_allocations\", statistic: \"SUM\" }] \r\n);<\/code><\/pre>\n"},{"acf_fc_layout":"content","content":"<h2>Combine multiple FeatureSets<\/h2>\n<p><span class=\"TextRun SCXW218506835 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW218506835 BCX0\">Once we have a\u00a0<\/span><span class=\"NormalTextRun SpellingErrorV2 SCXW218506835 BCX0\">FeatureSet<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0for each manufacturer, we can\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">iterate<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0through each feature\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">of the\u00a0<\/span><span class=\"NormalTextRun SpellingErrorV2 SCXW218506835 BCX0\">FeatureSet<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">to store\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">its\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">attributes into an empty\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">dictionary<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">.<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">After we\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">iterate<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0through all features<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">, we<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0can<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">convert the dictionary\u00a0<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">containing<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0all features and their attributes into a\u00a0<\/span><span class=\"NormalTextRun SpellingErrorV2 SCXW218506835 BCX0\">FeatureSet<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">\u00a0to power the serial chart<\/span><span class=\"NormalTextRun SCXW218506835 BCX0\">.\u00a0<\/span><\/span><span class=\"EOP SCXW218506835 BCX0\" data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<pre><code>var combinedDict = { \r\n  fields: [ \r\n    { name: \"manufacturer\", type: \"esriFieldTypeString\" }, \r\n    { name: \"week_of_allocation\", type: \"esriFieldTypeString\" }, \r\n    { name: \"count_of_doses\", type: \"esriFieldTypeInteger\" }, \r\n  ], \r\n  geometryType: \"\", \r\n  features: [], \r\n}; \r\n\r\nvar i = 0; \r\n\/\/ Loop through each FeatureSet and store its attributes \r\nfor (var m in moderna) { \r\n  combinedDict.features[i++] = { \r\n    attributes: { \r\n      manufacturer: \"Moderna\", \r\n      week_of_allocation: m[\"week_of_allocations\"], \r\n      count_of_doses: m[\"count_of_doses\"], \r\n    }, \r\n  }; \r\n} \r\n\r\nfor (var p in pfizer) { \r\n  combinedDict.features[i++] = { \r\n    attributes: { \r\n      manufacturer: \"Pfizer\", \r\n      week_of_allocation: p[\"week_of_allocations\"], \r\n      count_of_doses: p[\"count_of_doses\"], \r\n    }, \r\n  }; \r\n}\r\n\r\nfor (var j in janssen) { \r\n  combinedDict.features[i++] = { \r\n    attributes: { \r\n      manufacturer: \"Janssen\", \r\n      week_of_allocation: j[\"week_of_allocations\"], \r\n      count_of_doses: j[\"janssen\"], \r\n    }, \r\n  }; \r\n} \r\n\r\n\/\/ Return dictionary cast as a FeatureSet  \r\nreturn FeatureSet(Text(combinedDict));    \r\n<\/code><\/pre>\n<p><span class=\"TextRun SCXW168733707 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW168733707 BCX0\">The<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">\u00a0above<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">\u00a0data expression returns a<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SpellingErrorV2 SCXW168733707 BCX0\">FeatureSet<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">\u00a0that\u00a0<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">summarizes\u00a0<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">the total number of doses<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">\u00a0<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">allocated<\/span><span class=\"NormalTextRun SCXW168733707 BCX0\">\u00a0per week by each manufacturer. <span data-contrast=\"auto\"><a href=\"https:\/\/www.arcgis.com\/apps\/dashboards\/new#id=26fe7750a29240a78101820e44039abd\">Create a copy<\/a> of the\u00a0<\/span><a href=\"https:\/\/www.arcgis.com\/apps\/dashboards\/26fe7750a29240a78101820e44039abd\"><span data-contrast=\"none\">COVID vaccination status dashboard<\/span><\/a><span data-contrast=\"auto\">\u00a0to see the full expression.<\/span><\/span><\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1205432,"id":1205432,"title":"Combined feature set","filename":"Group-2-e1618957478556.png","filesize":160672,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\/group-2-2","alt":"Combined feature set","author":"218642","description":"","caption":"Combined feature set","name":"group-2-2","status":"inherit","uploaded_to":1205192,"date":"2021-04-20 22:04:37","modified":"2021-04-20 22:05:14","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":600,"height":357,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","medium-width":439,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","medium_large-width":600,"medium_large-height":357,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","large-width":600,"large-height":357,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","1536x1536-width":600,"1536x1536-height":357,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","2048x2048-width":600,"2048x2048-height":357,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","card_image-width":600,"card_image-height":357,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Group-2-e1618957478556.png","wide_image-width":600,"wide_image-height":357}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<h2>Configure serial chart powered by the combined FeatureSet<\/h2>\n<p><span class=\"TextRun BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">We can now use the\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">combined<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\"> FeatureSet<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0as our serial chart\u2019s data source<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">. First,<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0set the x-axis\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">by pulling<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0categories from\u00a0<\/span><\/span><strong><span class=\"TextRun MacChromeBold BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">Grouped values<\/span><\/span><\/strong><span class=\"TextRun BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">and set the\u00a0<\/span><\/span><strong><span class=\"TextRun MacChromeBold BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">Category field\u00a0<\/span><\/span><\/strong><span class=\"TextRun BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">to <code>week_of_allocation<\/code><\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">.<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0Then set\u00a0<\/span><\/span><strong><span class=\"TextRun MacChromeBold BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">Statistic<\/span><\/span><\/strong><span class=\"TextRun BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0to\u00a0<\/span><\/span><strong><span class=\"TextRun MacChromeBold BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">Sum<\/span><\/span><\/strong><span class=\"TextRun BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0and\u00a0<\/span><\/span><strong><span class=\"TextRun MacChromeBold BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\">Field<\/span><\/span><\/strong><span class=\"TextRun BCX0 SCXW80774583\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX0 SCXW80774583\"> to <code>count_of_doses<\/code><\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0to display\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">the\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">total\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">number<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0of doses<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">allocated<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0per week<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0along the y-axis<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">.<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">Finally<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">,<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0<\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">split the values by <code>manufacturer<\/code><\/span><span class=\"NormalTextRun BCX0 SCXW80774583\">\u00a0to compare weekly allocations among different manufacturers<\/span><span class=\"NormalTextRun AdvancedProofingIssueV2 BCX0 DefaultHighlightTransition SCXW80774583\">.<\/span><\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1205452,"id":1205452,"title":"serial chart config 1","filename":"serial-chart-config-1-scaled.png","filesize":396021,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-scaled.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\/serial-chart-config-1","alt":"Serial chart configuration","author":"218642","description":"","caption":"Serial chart configuration","name":"serial-chart-config-1","status":"inherit","uploaded_to":1205192,"date":"2021-04-20 22:05:57","modified":"2021-04-20 22:06:14","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":2560,"height":1415,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-scaled.png","medium-width":464,"medium-height":256,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-scaled.png","medium_large-width":768,"medium_large-height":425,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-scaled.png","large-width":1920,"large-height":1061,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-1536x849.png","1536x1536-width":1536,"1536x1536-height":849,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-2048x1132.png","2048x2048-width":2048,"2048x2048-height":1132,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-826x457.png","card_image-width":826,"card_image-height":457,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-1-1920x1061.png","wide_image-width":1920,"wide_image-height":1061}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><span data-contrast=\"auto\">Instead of displaying\u00a0our\u00a0data\u00a0in\u00a0three separate\u00a0elements,\u00a0we have summarized them into one comparison chart.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><span data-contrast=\"auto\">From the\u00a0<\/span><b><span data-contrast=\"auto\">Series<\/span><\/b><span data-contrast=\"auto\">\u00a0tab, we can easily turn this chart into a stacked line chart. For the\u00a0<\/span><b><span data-contrast=\"auto\">Stacking<\/span><\/b><span data-contrast=\"auto\">\u00a0option, select\u00a0<\/span><b><span data-contrast=\"auto\">Stacked<\/span><\/b><span data-contrast=\"auto\">, and set the\u00a0<\/span><b><span data-contrast=\"auto\">Type<\/span><\/b><span data-contrast=\"auto\">\u00a0as\u00a0<\/span><b><span data-contrast=\"auto\">Line.\u00a0<\/span><\/b><span data-contrast=\"auto\">Toggle on\u00a0<\/span><b><span data-contrast=\"auto\">Connect gaps\u00a0<\/span><\/b><span data-contrast=\"auto\">and increase the\u00a0<\/span><b><span data-contrast=\"auto\">Fill\u00a0<\/span><\/b><span data-contrast=\"auto\">opacity.\u00a0Now, you have\u00a0an\u00a0area chart\u00a0that\u00a0visualizes\u00a0changes and trends in vaccine allocation over time.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1205462,"id":1205462,"title":"Serial chart configuration","filename":"serial-chart-config-2-scaled.png","filesize":441956,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-scaled.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\/serial-chart-config-2","alt":"Serial chart configuration","author":"218642","description":"","caption":"Serial chart configuration","name":"serial-chart-config-2","status":"inherit","uploaded_to":1205192,"date":"2021-04-20 22:06:44","modified":"2021-04-20 22:07:03","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":2560,"height":1417,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-scaled.png","medium-width":464,"medium-height":257,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-scaled.png","medium_large-width":768,"medium_large-height":425,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-scaled.png","large-width":1920,"large-height":1063,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-1536x850.png","1536x1536-width":1536,"1536x1536-height":850,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-2048x1133.png","2048x2048-width":2048,"2048x2048-height":1133,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-826x457.png","card_image-width":826,"card_image-height":457,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/serial-chart-config-2-1920x1063.png","wide_image-width":1920,"wide_image-height":1063}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p><span data-contrast=\"auto\">Using data expressions, we now have a simple comparison chart that shows not only the cumulative count of vaccines\u00a0allocated\u00a0each week but also how many doses were\u00a0allocated\u00a0by each manufacturer.\u00a0<\/span><\/p>\n<p>Follow along in <a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-2\/\">part 2<\/a> of this post to learn, step-by-step, how you can leverage data expressions and advanced formatting to visualize hidden data using an informative and intuitive list element.<\/p>\n"}],"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":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Soobin-Choi-465x465.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"related_articles":[{"ID":1285722,"post_author":"218642","post_date":"2021-07-08 09:59:35","post_date_gmt":"2021-07-08 16:59:35","post_content":"","post_title":"Enhancing dashboard elements using data expressions - Part 2","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"enhancing-dashboard-elements-using-data-expressions-part-2","to_ping":"","pinged":"","post_modified":"2021-07-09 16:44:19","post_modified_gmt":"2021-07-09 23:44:19","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1285722","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"2","filter":"raw"},{"ID":1162422,"post_author":"19621","post_date":"2021-04-22 01:00:20","post_date_gmt":"2021-04-22 08:00:20","post_content":"","post_title":"Introducing Data Expressions in ArcGIS Dashboards","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"introducing-data-expressions-in-arcgis-dashboards","to_ping":"","pinged":"","post_modified":"2021-04-22 09:38:37","post_modified_gmt":"2021-04-22 16:38:37","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1162422","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"4","filter":"raw"},{"ID":922061,"post_author":"9082","post_date":"2020-07-09 12:56:16","post_date_gmt":"2020-07-09 19:56:16","post_content":"","post_title":"ArcGIS Dashboards at Esri UC 2020","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"arcgis-dashboards-at-esri-uc-2020","to_ping":"","pinged":"","post_modified":"2020-07-13 12:36:12","post_modified_gmt":"2020-07-13 19:36:12","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=922061","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-2-scaled.png"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Enhancing dashboard elements using data expressions - Part 1<\/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-1\" \/>\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 1\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\" \/>\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:59+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-1#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\"},\"author\":{\"name\":\"Soobin Choi\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/29471b4431cc3da9080be6d6315a8228\"},\"headline\":\"Enhancing dashboard elements using data expressions &#8211; Part 1\",\"datePublished\":\"2021-07-08T16:56:40+00:00\",\"dateModified\":\"2021-07-09T23:44:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\"},\"wordCount\":8,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS Arcade\",\"arcgis dashboards\",\"dashboard design\",\"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-1#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1\",\"name\":\"Enhancing dashboard elements using data expressions - Part 1\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2021-07-08T16:56:40+00:00\",\"dateModified\":\"2021-07-09T23:44:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1#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-1\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1#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 &#8211; Part 1\"}]},{\"@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 1","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-1","og_locale":"en_US","og_type":"article","og_title":"Enhancing dashboard elements using data expressions - Part 1","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2021-07-09T23:44:59+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-1#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1"},"author":{"name":"Soobin Choi","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/29471b4431cc3da9080be6d6315a8228"},"headline":"Enhancing dashboard elements using data expressions &#8211; Part 1","datePublished":"2021-07-08T16:56:40+00:00","dateModified":"2021-07-09T23:44:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1"},"wordCount":8,"commentCount":2,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS Arcade","arcgis dashboards","dashboard design","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-1#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1","name":"Enhancing dashboard elements using data expressions - Part 1","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2021-07-08T16:56:40+00:00","dateModified":"2021-07-09T23:44:59+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1#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-1"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/analytics\/enhancing-dashboard-elements-using-data-expressions-part-1#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 &#8211; Part 1"}]},{"@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-2-scaled.png","primary_product":"ArcGIS Dashboards","tag_data":[{"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":532642,"name":"dashboard design","slug":"dashboard-design","term_group":0,"term_taxonomy_id":532642,"taxonomy":"post_tag","description":"","parent":0,"count":8,"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":1329,"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":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\/1205192","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=1205192"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1205192\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1205192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1205192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1205192"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1205192"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1205192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}