{"id":1162422,"date":"2021-04-22T01:00:20","date_gmt":"2021-04-22T08:00:20","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1162422"},"modified":"2021-04-22T09:38:37","modified_gmt":"2021-04-22T16:38:37","slug":"introducing-data-expressions-in-arcgis-dashboards","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards","title":{"rendered":"Introducing Data Expressions in ArcGIS Dashboards"},"author":19621,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[37101],"tags":[32551,573561,25521,759522,26521],"industry":[],"product":[36671],"class_list":["post-1162422","blog","type-blog","status-publish","format-standard","hentry","category-announcements","tag-arcade","tag-arcgis-dashboards","tag-dashboards","tag-data-expression","tag-visualization","product-ops-dashboard"],"acf":{"short_description":"The latest release of ArcGIS Dashboards introduces 'data expressions' - a new capability to build effective dashboards. ","flexible_content":[{"acf_fc_layout":"content","content":"

ArcGIS Dashboards<\/span><\/a>\u00a0enable users to convey information\u00a0at a glance\u00a0via highly configurable visual elements such as maps, gauges, and indicators.\u00a0\u00a0<\/span>One\u00a0<\/span>key\u00a0<\/span>ingredient in\u00a0<\/span>creating compelling\u00a0<\/span>d<\/span>ashboards<\/span> is well-structured data that <\/span>is suited<\/span>\u00a0for\u00a0<\/span>visualization.<\/span>\u00a0For example, you may need a new field to hold a calculation or a modified string. Or perhaps you need to collate data that is spread across multiple fields or layers. These small data refinements can be challenging, especially when you don\u2019t own\u00a0<\/span>the dataset<\/span>.<\/span>\u00a0<\/span><\/p>\n

To overcome challenges like these, the latest release<\/a> of Dashboards introduces an exciting new\u00a0<\/span>capability named<\/span>\u00a0\u2018data\u00a0<\/span>expressions\u2019<\/span>.<\/span>\u00a0<\/span><\/p>\n

What are data expressions?<\/span><\/b>\u00a0<\/span><\/h2>\n

Data expressions are\u00a0<\/span>Arcade<\/span><\/a>\u00a0expressions written<\/span>\u00a0to<\/span>\u00a0return<\/span>\u00a0a<\/span>\u00a0<\/span>FeatureSet<\/span><\/a>.\u00a0<\/span>The returned\u00a0<\/span>FeatureSet<\/span>\u00a0is then used as the\u00a0<\/span>data source<\/span><\/a>\u00a0<\/span>for one or more dashboard elements.\u00a0<\/span>\u00a0B<\/span>y\u00a0<\/span>leveraging Arcade\u2019s ability to<\/span>\u00a0perform mathematical calculations, manipulate text, evaluate logical statements<\/span>, and so on<\/span>,\u00a0<\/span>t<\/span>hey offer\u00a0<\/span>dashboard authors a whole\u00a0<\/span>new\u00a0<\/span>set of\u00a0<\/span>capabilities\u00a0<\/span>for configuring informative and robust d<\/span>ata visualizations.\u00a0<\/span>Dashboard eleme<\/span>n<\/span>ts backed by a data expression\u00a0<\/span>can\u00a0<\/span>participate in the full <\/span>dashboard interactive experience<\/a><\/span>.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"

Tip:\u00a0<\/span>Albeit complimentary, d<\/span>o not confuse data expressions with\u00a0<\/span>Arcade\u00a0<\/span>expressions\u00a0<\/span>written\u00a0<\/span>to provide<\/span>\u00a0<\/span>advanced formatting<\/span><\/a>\u00a0<\/span>of list and indicator elements<\/span>\u00a0<\/span>(introduced in the<\/span>\u00a0<\/span>beta release<\/span><\/a>\u00a0of ArcGIS Dashboards)<\/span>.\u00a0<\/span>Data expressions and f<\/span>ormatting expressions leverage different\u00a0<\/span>Arcade profile<\/span>s<\/span><\/a>, and\u00a0<\/span>formatting expressions are written to\u00a0<\/span>return<\/span>\u00a0<\/span>a\u00a0<\/span>Dictionary<\/span><\/a>\u00a0<\/span>of properties\u00a0<\/span>t<\/span>hat<\/span>\u00a0control\u00a0<\/span>how the<\/span>\u00a0element\u2019s data points are<\/span>\u00a0rendered at runtime.\u00a0<\/span>\u00a0<\/span><\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

Adding a data expression\u00a0<\/span><\/b>\u00a0<\/span><\/h2>\n

A data expression can be added from the \u2018Select a layer\u2019 screen when you add a new data-driven element or change the layer for an existing element. The \u2018Select a layer\u2019 screen has a new section for data expressions.\u00a0<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1175142,"id":1175142,"title":"SelectALayerScreen","filename":"SelectALayerScreen.png","filesize":14343,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/selectalayerscreen","alt":"The 'Select a layer' now has a new section for adding and selecting data expressions.","author":"19621","description":"","caption":"","name":"selectalayerscreen","status":"inherit","uploaded_to":1162422,"date":"2021-03-26 22:01:36","modified":"2021-04-09 18:34: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":1227,"height":721,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen.png","medium-width":444,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen.png","medium_large-width":768,"medium_large-height":451,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen.png","large-width":1227,"large-height":721,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen.png","1536x1536-width":1227,"1536x1536-height":721,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen.png","2048x2048-width":1227,"2048x2048-height":721,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen-791x465.png","card_image-width":791,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/SelectALayerScreen.png","wide_image-width":1227,"wide_image-height":721}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

On the \u2018Select a layer\u2019 screen, clicking on the \u2018New data expression\u2019 button opens the Arcade editor. You can add a name for your expression and optionally set a refresh interval if you are working with regularly updating data. You can type your expression in the editor area and hit the \u2018Done\u2019 button to save it. Note that the \u2018Data expressions\u2019 profile<\/a> does not support global variables. Instead, you will be using the Arcade\u00a0<\/span><\/span>FeatureSetByPortalItem<\/span><\/span>()<\/span><\/span><\/a> function to access feature layers.\u00a0\u00a0<\/span><\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"

Tip: Depending on their\u00a0<\/span><\/span>complexity,\u00a0<\/span><\/span>Arcade expressions\u00a0<\/span><\/span>can\u00a0<\/span><\/span>introduce processing overhead<\/span><\/span>\u00a0to your dashboard,\u00a0<\/span><\/span>thereby impacting the end user\u2019s viewing experience<\/span><\/span>.\u00a0<\/span><\/span>Do not set a refresh interval if your data is not being updated<\/span><\/span>\u00a0regularly<\/span><\/span>.\u00a0<\/span><\/span>When used, r<\/span><\/span>efresh intervals should\u00a0<\/span><\/span>reflect\u00a0<\/span><\/span>how often the data is\u00a0<\/span><\/span>actually <\/span><\/span>updated.\u00a0<\/span><\/span><\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"image","image":{"ID":1175162,"id":1175162,"title":"ExpressionEditor","filename":"ExpressionEditor.png","filesize":24818,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/expressioneditor","alt":"Data expressions are authored and saved in the Arcade editor.","author":"19621","description":"","caption":"","name":"expressioneditor","status":"inherit","uploaded_to":1162422,"date":"2021-03-26 22:07:14","modified":"2021-04-09 18:03:45","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":1910,"height":895,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor.png","medium-width":464,"medium-height":217,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor.png","medium_large-width":768,"medium_large-height":360,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor.png","large-width":1910,"large-height":895,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor-1536x720.png","1536x1536-width":1536,"1536x1536-height":720,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor.png","2048x2048-width":1910,"2048x2048-height":895,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor-826x387.png","card_image-width":826,"card_image-height":387,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/ExpressionEditor.png","wide_image-width":1910,"wide_image-height":895}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Examples<\/span><\/b>\u00a0<\/span><\/h2>\n

Let\u2019s <\/span>look<\/span>\u00a0at a few common visualization challenges and how data expressions can help.<\/span>\u00a0<\/span><\/p>\n

1. Data that needs restructuring\u00a0<\/span><\/i><\/b>\u00a0<\/span><\/p>\n

Often, when data is created or collected, it is not optimized for visualization. Take, for example, survey data from a survey with multiple-choice questions. Below is a sample data table capturing the output of a survey that asks road surveyors to input one or more road condition hazards.\u00a0\u00a0<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1163962,"id":1163962,"title":"DT_1","filename":"DT_1.png","filesize":22552,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/dt_1","alt":"","author":"19621","description":"","caption":"","name":"dt_1","status":"inherit","uploaded_to":1162422,"date":"2021-03-17 23:31:15","modified":"2021-03-17 23:31:15","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":529,"height":356,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","medium-width":388,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","medium_large-width":529,"medium_large-height":356,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","large-width":529,"large-height":356,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","1536x1536-width":529,"1536x1536-height":356,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","2048x2048-width":529,"2048x2048-height":356,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","card_image-width":529,"card_image-height":356,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_1.png","wide_image-width":529,"wide_image-height":356}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Creating a pie chart with\u00a0<\/span><\/span>slices derived from\u00a0<\/span><\/span>the\u00a0<\/span><\/span>RoadCondition<\/span><\/span>\u00a0creates an ineffective chart. What we really want to know is the number of reports by each hazard type\u00a0<\/span><\/span>i<\/span><\/span>.e.,<\/span><\/span>\u00a0pothole, debris, slick.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1167922,"id":1167922,"title":"2021-03-22_12-46-50","filename":"2021-03-22_12-46-50.png","filesize":11010,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/2021-03-22_12-46-50","alt":"A pie chart with comma separated values visualized as-is. Since hazard reports like 'debris, slick, pothole' and 'slick, pothole' visualized as separate groups, it does not provide an overview of the actual count of hazards by type.","author":"19621","description":"","caption":"","name":"2021-03-22_12-46-50","status":"inherit","uploaded_to":1162422,"date":"2021-03-22 19:49:31","modified":"2021-04-13 03:17:10","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":552,"height":420,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","medium-width":343,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","medium_large-width":552,"medium_large-height":420,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","large-width":552,"large-height":420,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","1536x1536-width":552,"1536x1536-height":420,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","2048x2048-width":552,"2048x2048-height":420,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","card_image-width":552,"card_image-height":420,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-46-50.png","wide_image-width":552,"wide_image-height":420}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Let\u2019s add a data expression so that each hazard type is captured in a separate row.\u00a0<\/span><\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"","image_reference":false,"layout":"code_snippet","image_reference_figure":"","snippet":"\/\/ Reference layer using the FeatureSetByPortalItem() function. \r\nvar fs = FeatureSetByPortalItem(Portal('https:\/\/www.arcgis.com'), 'd10b9e8dbd7f4cccbd0a938a06c586e9' , 0, ['Report_road_condition'], false);\r\n\r\n\/\/ Empty dictionary to capture each hazard reported as separate rows. \r\nvar choicesDict = {'fields': [{ 'name': 'split_choices', 'type': 'esriFieldTypeString'}], \r\n 'geometryType': '', 'features': []}; \r\n\r\nvar index = 0; \r\n\r\n\/\/ Split comma separated hazard types and store in dictionary. \r\nfor (var feature in fs) { \r\n var split_array = Split(feature[\"Report_road_condition\"], ',') \r\n var count_arr = Count(split_array) \r\n for(var i = 0; i < count_arr; i++ ){ \r\n choicesDict.features[index++] = { \r\n 'attributes': { 'split_choices': Trim(split_array[i]), \r\n }} \r\n}} \r\n\r\n\/\/ Convert dictionary to featureSet. \r\nvar fs_dict = FeatureSet(Text(choicesDict)); \r\n\r\n\/\/ Return featureset after grouping by hazard types. \r\nreturn GroupBy(fs_dict, ['split_choices'], \r\n [{ name: 'split_count', expression: 'split_choices', statistic: 'COUNT' }]); ","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

The resulting FeatureSet is a simple summary of counts by hazard type.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1194522,"id":1194522,"title":"DT_2","filename":"DT_2-1-e1618321685219.png","filesize":35244,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/dt_2-2","alt":"","author":"19621","description":"","caption":"","name":"dt_2-2","status":"inherit","uploaded_to":1162422,"date":"2021-04-13 13:47:50","modified":"2021-04-13 13:47: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":300,"height":157,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-213x182.png","thumbnail-width":213,"thumbnail-height":182,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","medium-width":300,"medium-height":157,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","medium_large-width":300,"medium_large-height":157,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","large-width":300,"large-height":157,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","1536x1536-width":300,"1536x1536-height":157,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","2048x2048-width":300,"2048x2048-height":157,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","card_image-width":300,"card_image-height":157,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_2-1-e1618321685219.png","wide_image-width":300,"wide_image-height":157}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

You can then swap the pie\u00a0<\/span>chart\u2019s <\/span><\/span>data<\/span>\u00a0source\u00a0<\/span><\/span>with the data expression<\/span><\/span>\u00a0<\/span><\/span>t<\/span><\/span>o\u00a0<\/span><\/span>provide<\/span><\/span>\u00a0a better overview of the data.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1167942,"id":1167942,"title":"2021-03-22_12-59-39","filename":"2021-03-22_12-59-39.png","filesize":9268,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/2021-03-22_12-59-39","alt":"A pie chart with comma separated values visualized as separate slices.","author":"19621","description":"","caption":"","name":"2021-03-22_12-59-39","status":"inherit","uploaded_to":1162422,"date":"2021-03-22 20:00:18","modified":"2021-04-08 23:01: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":552,"height":420,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","medium-width":343,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","medium_large-width":552,"medium_large-height":420,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","large-width":552,"large-height":420,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","1536x1536-width":552,"1536x1536-height":420,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","2048x2048-width":552,"2048x2048-height":420,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","card_image-width":552,"card_image-height":420,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/2021-03-22_12-59-39.png","wide_image-width":552,"wide_image-height":420}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

<\/h3>\n

2.Working with raw data\u00a0<\/em><\/h3>\n

A common visualization challenge is when your data is\u00a0<\/span><\/span>t<\/span><\/span>ransactional,<\/span><\/span>\u00a0but you want to show summary statistics in\u00a0<\/span><\/span>elements like the List. Below is a table with raw observational data water quality data collected across the state of Maryland.\u00a0<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1170852,"id":1170852,"title":"DT_3","filename":"DT_3-1.png","filesize":18967,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/dt_3-2","alt":"","author":"19621","description":"","caption":"","name":"dt_3-2","status":"inherit","uploaded_to":1162422,"date":"2021-03-24 03:58:09","modified":"2021-03-24 03:58:09","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":660,"height":402,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","medium-width":429,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","medium_large-width":660,"medium_large-height":402,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","large-width":660,"large-height":402,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","1536x1536-width":660,"1536x1536-height":402,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","2048x2048-width":660,"2048x2048-height":402,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","card_image-width":660,"card_image-height":402,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_3-1.png","wide_image-width":660,"wide_image-height":402}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

A list element from this dataset shows\u00a0<\/span><\/span>individual\u00a0<\/span><\/span>observations but<\/span><\/span>\u00a0does not provide insights into the\u00a0<\/span><\/span>dataset as a whole<\/span><\/span>.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1183002,"id":1183002,"title":"List_before","filename":"List_before-1.png","filesize":20913,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/list_before-2","alt":"A list element visualizing unaggregated data.","author":"19621","description":"","caption":"","name":"list_before-2","status":"inherit","uploaded_to":1162422,"date":"2021-04-05 23:00:08","modified":"2021-04-08 23:00:06","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":394,"height":769,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1.png","medium-width":134,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1.png","medium_large-width":394,"medium_large-height":769,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1.png","large-width":394,"large-height":769,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1.png","1536x1536-width":394,"1536x1536-height":769,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1.png","2048x2048-width":394,"2048x2048-height":769,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1-238x465.png","card_image-width":238,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/List_before-1.png","wide_image-width":394,"wide_image-height":769}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Using the following data expression, you can return\u00a0<\/span><\/span>summary\u00a0<\/span><\/span>statistics<\/span><\/span>.\u00a0<\/span><\/span>And because\u00a0<\/span><\/span>the Arcade\u00a0<\/span><\/span>GroupBy<\/span><\/span>() function allows the calculation of multiple statistics in a single function call, you can request statistics by county for total sites, average rainfall, and total water quality advisories.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"","image_reference":false,"layout":"code_snippet","image_reference_figure":"","snippet":"var fs = FeatureSetByPortalItem(Portal('https:\/\/arcgis.com\/'), '164373608f1241e78c66f8f4b9822866', 0, ['COUNTY','STATIONNUM','RAINFALL','ADVISORYDESC'], false);\r\n\r\n\/\/ Return a featueset with multiple group by statistics. \r\nreturn GroupBy(fs, ['COUNTY'], [ \r\n {name: 'total_sites', expression: 'STATIONNUM', statistic: 'COUNT' }, \r\n {name: 'avg_rain', expression: 'RAINFALL', statistic: 'AVG' },\r\n {name: 'count_adv', expression: 'ADVISORYDESC', statistic: 'COUNT' }]); ","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

The data expression generates a\u00a0<\/span><\/span>F<\/span><\/span><\/span>eature<\/span><\/span>S<\/span><\/span><\/span>et that provides statistics by county.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1170872,"id":1170872,"title":"DT_4","filename":"DT_4.png","filesize":13424,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/dt_4","alt":"","author":"19621","description":"","caption":"","name":"dt_4","status":"inherit","uploaded_to":1162422,"date":"2021-03-24 04:09:27","modified":"2021-03-24 04:09:27","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":569,"height":402,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","medium-width":369,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","medium_large-width":569,"medium_large-height":402,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","large-width":569,"large-height":402,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","1536x1536-width":569,"1536x1536-height":402,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","2048x2048-width":569,"2048x2048-height":402,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","card_image-width":569,"card_image-height":402,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/DT_4.png","wide_image-width":569,"wide_image-height":402}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Once the data is summarized<\/span><\/span>\u00a0and acting as the list\u2019s data source<\/span><\/span>, you can<\/span><\/span>\u00a0add further\u00a0<\/span><\/span>informative\u00a0<\/span><\/span>value by configuring<\/span><\/span>\u00a0an expression for<\/span><\/span>\u00a0<\/span><\/span>advanced formatting<\/span><\/span>.<\/span><\/span><\/span><\/span><\/a>\u00a0<\/span><\/span>What is shown below is just one example of what is possible.\u00a0<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1183012,"id":1183012,"title":"GroupByList","filename":"GroupByList.png","filesize":20783,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/groupbylist","alt":"A list element visualizing summary statistics returned by a data expression.","author":"19621","description":"","caption":"","name":"groupbylist","status":"inherit","uploaded_to":1162422,"date":"2021-04-05 23:00:31","modified":"2021-04-08 22:59:25","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":494,"height":770,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList.png","medium-width":167,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList.png","medium_large-width":494,"medium_large-height":770,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList.png","large-width":494,"large-height":770,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList.png","1536x1536-width":494,"1536x1536-height":770,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList.png","2048x2048-width":494,"2048x2048-height":770,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList-298x465.png","card_image-width":298,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/GroupByList.png","wide_image-width":494,"wide_image-height":770}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

<\/h3>\n

3. Calculating metrics from values across columns<\/span><\/i><\/b>\u00a0<\/span><\/p>\n

In this example, you can see how data expressions can be used to calculate metrics from data that is spread across multiple fields in a layer. The below expression is using sample data for COVID-19 for the state of California. Let\u2019s calculate the\u00a0<\/span>Case Fatality Ratio (CFR)<\/span><\/a>\u00a0which is simply a ratio of confirmed COVID-19 deaths to cases. Deaths and cases are stored in two separate fields in the dataset, which is a common way of organizing data. We will calculate CFR for two points in time \u2013 the latest date and 7 days prior.<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"","image_reference":false,"layout":"code_snippet","image_reference_figure":"","snippet":"var fs = FeatureSetByPortalItem(Portal('https:\/\/www.arcgis.com'), '290bfa5c085c4861a85573111f2641ce', 0, [\"newcountconfirmed\", \"newcountdeaths\"], false)\r\n\r\n\/\/ Filter the dataset to exclude the last 7 days. \r\nvar dt_7 = DateAdd(Date(Max(fs, 'date')), -7, 'days')\r\nvar fs_7 = Filter(fs, 'date < @dt_7')\r\n\r\n\/\/ Calculate CFR for latest date and 7 days prior. \r\nvar ratioDict = { \r\n 'fields': [{'name':'CFR', 'type':'esriFieldTypeDouble'},\r\n {'name':'CFR_7', 'type':'esriFieldTypeDouble'}], \r\n 'geometryType': '', \r\n 'features': \r\n [{'attributes': \r\n {'CFR': Round((SUM(fs,'newcountdeaths')\/SUM(fs,'newcountconfirmed'))*100,2), \r\n 'CFR_7': Round((SUM(fs_7,'newcountdeaths')\/SUM(fs_7,'newcountconfirmed'))*100,2)\r\n }}]}; \r\n\r\n\/\/ Convert dictionary to featureset and return it. \r\nreturn FeatureSet(Text(ratioDict)); ","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

The resulting metric can be visualized in an indicator element.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1183042,"id":1183042,"title":"CFR_Indicator","filename":"CFR_Indicator-2.png","filesize":11410,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\/cfr_indicator-3","alt":"Case Fatality Ratio visualized in an Indicator element.","author":"19621","description":"","caption":"","name":"cfr_indicator-3","status":"inherit","uploaded_to":1162422,"date":"2021-04-05 23:24:54","modified":"2021-04-20 23:12: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":573,"height":339,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","medium-width":441,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","medium_large-width":573,"medium_large-height":339,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","large-width":573,"large-height":339,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","1536x1536-width":573,"1536x1536-height":339,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","2048x2048-width":573,"2048x2048-height":339,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","card_image-width":573,"card_image-height":339,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/CFR_Indicator-2.png","wide_image-width":573,"wide_image-height":339}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"sidebar","content":"

Note: While data expressions are a convenient alternative to republishing data, they are not a replacement for data processing workflows. Certain operations in data expressions can be expensive and severally impact your dashboard’s performance. Refer to detailed documentation on the recommended best practices<\/a>.<\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

Conclusion<\/h2>\n

These are some examples of how data expressions can help you build effective Dashboards. Stay tuned for more blogs on the many innovative\u00a0<\/span><\/span>uses of data expressions. Additional sample expressions are available on GitHub<\/a>. You can also contribute<\/a> your own expressions to the repository to share them with the rest of the user community. Also, check out the ‘Data expressions’<\/a>\u00a0 group to explore the Dashboards used in this blog.\u00a0<\/span><\/span><\/span><\/p>\n

We would love to see how you incorporate data expressions into your dashboards. Please share them with us on Twitter<\/a> and LinkedIn<\/a> using #ArcGISDashboards.<\/span><\/span><\/span><\/p>\n

 <\/p>\n"}],"authors":[{"ID":19621,"user_firstname":"Vivek","user_lastname":"Malleshappa","nickname":"vmalleshappa","user_nicename":"vmalleshappa","display_name":"Vivek Malleshappa","user_email":"vmalleshappa@esri.com","user_url":"https:\/\/community.esri.com\/t5\/arcgis-dashboards\/ct-p\/arcgis-dashboards","user_registered":"2020-03-24 18:59:36","user_description":"Vivek is a Product Engineer on the ArcGIS Dashboards team.","user_avatar":""}],"related_articles":[{"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"},{"ID":1190082,"post_author":"7151","post_date":"2021-04-13 11:00:14","post_date_gmt":"2021-04-13 18:00:14","post_content":"","post_title":"New ArcGIS Dashboards is Out of Beta","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"new-arcgis-dashboards-is-out-of-beta","to_ping":"","pinged":"","post_modified":"2025-08-21 15:01:55","post_modified_gmt":"2025-08-21 22:01:55","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=1190082","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":878991,"post_author":"6461","post_date":"2020-06-10 11:11:30","post_date_gmt":"2020-06-10 18:11:30","post_content":"","post_title":"Your Arcade Questions Answered","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"your-arcade-questions-answered","to_ping":"","pinged":"","post_modified":"2024-11-01 00:17:42","post_modified_gmt":"2024-11-01 07:17:42","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=878991","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"2","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/with_panel_rz_card.jpg","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/with_panel_rz.jpg"},"yoast_head":"\nIntroducing Data Expressions in ArcGIS Dashboards<\/title>\n<meta name=\"description\" content=\"The latest release of Dashboards introduces an exciting new capability called 'data expressions'.\" \/>\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\/announcements\/introducing-data-expressions-in-arcgis-dashboards\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing Data Expressions in ArcGIS Dashboards\" \/>\n<meta property=\"og:description\" content=\"The latest release of Dashboards introduces an exciting new capability called 'data expressions'.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-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=\"2021-04-22T16:38:37+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\/announcements\/introducing-data-expressions-in-arcgis-dashboards#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\"},\"author\":{\"name\":\"Vivek Malleshappa\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/08ead9a3b86f0c6801b3136ce60abb92\"},\"headline\":\"Introducing Data Expressions in ArcGIS Dashboards\",\"datePublished\":\"2021-04-22T08:00:20+00:00\",\"dateModified\":\"2021-04-22T16:38:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\"},\"wordCount\":6,\"commentCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"arcade\",\"arcgis dashboards\",\"dashboards\",\"data expression\",\"Visualization\"],\"articleSection\":[\"Announcements\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\",\"name\":\"Introducing Data Expressions in ArcGIS Dashboards\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2021-04-22T08:00:20+00:00\",\"dateModified\":\"2021-04-22T16:38:37+00:00\",\"description\":\"The latest release of Dashboards introduces an exciting new capability called 'data expressions'.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing Data Expressions in ArcGIS 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\/08ead9a3b86f0c6801b3136ce60abb92\",\"name\":\"Vivek Malleshappa\",\"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\/2020\/03\/Profile-pic-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/03\/Profile-pic-213x200.jpg\",\"caption\":\"Vivek Malleshappa\"},\"description\":\"Vivek is a Product Engineer on the ArcGIS Dashboards team.\",\"sameAs\":[\"https:\/\/community.esri.com\/t5\/arcgis-dashboards\/ct-p\/arcgis-dashboards\"],\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/vmalleshappa\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Introducing Data Expressions in ArcGIS Dashboards","description":"The latest release of Dashboards introduces an exciting new capability called 'data expressions'.","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\/announcements\/introducing-data-expressions-in-arcgis-dashboards","og_locale":"en_US","og_type":"article","og_title":"Introducing Data Expressions in ArcGIS Dashboards","og_description":"The latest release of Dashboards introduces an exciting new capability called 'data expressions'.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2021-04-22T16:38:37+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\/announcements\/introducing-data-expressions-in-arcgis-dashboards#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards"},"author":{"name":"Vivek Malleshappa","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/08ead9a3b86f0c6801b3136ce60abb92"},"headline":"Introducing Data Expressions in ArcGIS Dashboards","datePublished":"2021-04-22T08:00:20+00:00","dateModified":"2021-04-22T16:38:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards"},"wordCount":6,"commentCount":5,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["arcade","arcgis dashboards","dashboards","data expression","Visualization"],"articleSection":["Announcements"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards","name":"Introducing Data Expressions in ArcGIS Dashboards","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2021-04-22T08:00:20+00:00","dateModified":"2021-04-22T16:38:37+00:00","description":"The latest release of Dashboards introduces an exciting new capability called 'data expressions'.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/announcements\/introducing-data-expressions-in-arcgis-dashboards#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Introducing Data Expressions in ArcGIS 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\/08ead9a3b86f0c6801b3136ce60abb92","name":"Vivek Malleshappa","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\/2020\/03\/Profile-pic-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/03\/Profile-pic-213x200.jpg","caption":"Vivek Malleshappa"},"description":"Vivek is a Product Engineer on the ArcGIS Dashboards team.","sameAs":["https:\/\/community.esri.com\/t5\/arcgis-dashboards\/ct-p\/arcgis-dashboards"],"url":"https:\/\/www.esri.com\/arcgis-blog\/author\/vmalleshappa"}]}},"text_date":"April 22, 2021","author_name":"Vivek Malleshappa","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/vmalleshappa","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/03\/with_panel_rz.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":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":25521,"name":"dashboards","slug":"dashboards","term_group":0,"term_taxonomy_id":25521,"taxonomy":"post_tag","description":"","parent":0,"count":39,"filter":"raw"},{"term_id":759522,"name":"data expression","slug":"data-expression","term_group":0,"term_taxonomy_id":759522,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":26521,"name":"Visualization","slug":"visualization","term_group":0,"term_taxonomy_id":26521,"taxonomy":"post_tag","description":"","parent":0,"count":45,"filter":"raw"}],"category_data":[{"term_id":37101,"name":"Announcements","slug":"announcements","term_group":0,"term_taxonomy_id":37101,"taxonomy":"category","description":"","parent":0,"count":2010,"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":197,"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\/1162422","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\/19621"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1162422"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1162422\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1162422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1162422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1162422"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1162422"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1162422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}