{"id":838811,"date":"2020-04-29T08:30:25","date_gmt":"2020-04-29T15:30:25","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=838811"},"modified":"2024-11-01T00:18:06","modified_gmt":"2024-11-01T07:18:06","slug":"conditional-formatting-indicators-with-arcade","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade","title":{"rendered":"Conditional formatting in dashboard indicators with Arcade"},"author":10072,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[777102,37121],"tags":[32551,147192,532642,30111,642031],"industry":[],"product":[36591,36671],"class_list":["post-838811","blog","type-blog","status-publish","format-standard","hentry","category-arcade","category-real-time","tag-arcade","tag-dashboard","tag-dashboard-design","tag-data-visualization","tag-formatting","product-apps","product-ops-dashboard"],"acf":{"short_description":"Use conditional formatting to provide context to your dashboard indicators using Arcade in ArcGIS Dashboards.","flexible_content":[{"acf_fc_layout":"content","content":"

One of the main jobs of a dashboard is to give an audience information quickly and easily.\u00a0<\/span>Seeing numbers and text is useful, but without context, they can be meaningless.\u00a0<\/span>There are many ways to\u00a0<\/span>provide context<\/span><\/a>\u00a0to your elements, and with the ArcGIS\u00a0<\/span>Dashboards Beta, we have introduced support for Arcade expressions, opening a whole new avenue of conditional formatting.\u00a0<\/span>\u00a0<\/span><\/p>\n

Using an Arcade expression, you can now define your own logic and apply a variety of different formatting techniques to draw attention to important values, events, and situations.\u00a0<\/span>Let\u2019s go through how we can use this technique in an\u00a0<\/span>e<\/span>arthquake monitoring dashboard like the one below.\u00a0<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":838831,"id":838831,"title":"final dashboard","filename":"final-dashboard.jpg","filesize":198358,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\/final-dashboard-2","alt":"earthquake monitoring dashboard","author":"10072","description":"","caption":"","name":"final-dashboard-2","status":"inherit","uploaded_to":838811,"date":"2020-04-27 12:49:31","modified":"2020-04-27 12:49:49","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":1915,"height":922,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard.jpg","medium-width":464,"medium-height":223,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard.jpg","medium_large-width":768,"medium_large-height":370,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard.jpg","large-width":1915,"large-height":922,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard-1536x740.jpg","1536x1536-width":1536,"1536x1536-height":740,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard.jpg","2048x2048-width":1915,"2048x2048-height":922,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard-826x398.jpg","card_image-width":826,"card_image-height":398,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-dashboard.jpg","wide_image-width":1915,"wide_image-height":922}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.arcgis.com\/apps\/dashboards\/40069c2a61f5467b8496e6129e9bab44"},{"acf_fc_layout":"content","content":"

In this dashboard, we have an indicator (top left) showing the count of earthquakes in the last 24 hours.\u00a0<\/span><\/span>With\u00a0<\/span><\/span>Arcade, we can define relevant logic and format the indicator<\/span><\/span>\u00a0to communicate only the information that matters.<\/span><\/span>\u00a0<\/span><\/span>In this case, we want to see when there has been an increase or decrease in activity, but since\u00a0<\/span><\/span>minor fluctuations are perfectly normal, we really are only concerned with significant spike in activity.<\/span><\/span>\u00a0Here\u2019s how we can do this.\u00a0<\/span><\/span>\u00a0<\/span><\/p>\n

1. Set up the indicator<\/span>
\n<\/span><\/h2>\n

First, we need to set up our data.\u00a0<\/span>In your indicator, we want to get a count of earthquakes within the last 24 hours<\/span>\u00a0as well as set up a reference with a count of ea<\/span>rthquakes between 24 to 48 hours ago.<\/span>\u00a0<\/span>\u00a0<\/span><\/p>\n

a.\u00a0 In the <\/span>Data<\/span><\/b>\u00a0tab, from the\u00a0<\/span>Statistic\u00a0<\/span><\/b>drop-down, choose\u00a0<\/span>Count\u00a0<\/span><\/b>to get a count of your earthquake.<\/span>
\nb.\u00a0 <\/span>Apply a\u00a0<\/span>filter<\/span><\/a>\u00a0to only get a count of earthquakes less than 24 hours old.\u00a0<\/span>
\nc.\u00a0 <\/span>Enable\u00a0<\/span>Reference<\/span><\/b>\u00a0and again, get the count of earthquakes.<\/span>
\nd.\u00a0 <\/span>Apply two filters. The first, for earthquakes greater than or equal to 24 hours old and the second, for earthquakes less than 48 hours old.\u00a0<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":838841,"id":838841,"title":"reference filters","filename":"reference-filters.jpg","filesize":33447,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\/reference-filters","alt":"indicator data configuration","author":"10072","description":"","caption":"","name":"reference-filters","status":"inherit","uploaded_to":838811,"date":"2020-04-27 12:52:27","modified":"2020-04-27 12:53:07","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":600,"height":814,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters.jpg","medium-width":192,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters.jpg","medium_large-width":600,"medium_large-height":814,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters.jpg","large-width":600,"large-height":814,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters.jpg","1536x1536-width":600,"1536x1536-height":814,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters.jpg","2048x2048-width":600,"2048x2048-height":814,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters-343x465.jpg","card_image-width":343,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/reference-filters.jpg","wide_image-width":600,"wide_image-height":814}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

2. Calculate the percent change<\/span>\u00a0<\/span><\/h2>\n

Now that we have both the counts of the last 24 hours and the 24 hours before that, we can do a percent change calculation using Arcade to see what the increase or decrease was between the two time periods.\u00a0<\/span>\u00a0<\/span><\/p>\n

We do this by creating a new variable with the calculation (see below).\u00a0<\/span>\u00a0<\/span><\/p>\n

var\u00a0<\/span>percentChange<\/span>\u00a0=\u00a0<\/span>Floor(<\/span>100*($<\/span>datapoint.count<\/span>\u00a0- $<\/span>reference.count<\/span>) \/ $<\/span>reference.count<\/span>, 1);<\/span>\u00a0<\/span><\/code><\/p>\n"},{"acf_fc_layout":"content","content":"

3. De<\/span>clare\u00a0<\/span>the threshold<\/span>s
\n<\/span><\/h2>\n

With the percent change calculation written, we now want to declare our thresholds. Like we said, we only care about significant spike activity and not minor <\/span>fluctuations,<\/span>\u00a0so we want this to<\/span>\u00a0be<\/span>\u00a0reflect<\/span>ed<\/span>\u00a0in our formatting. <\/span>We\u2019ll set two<\/span><\/span>\u00a0threshold<\/span><\/span>s, one<\/span><\/span>\u00a0<\/span><\/span>for when<\/span><\/span>\u00a0there\u00a0<\/span><\/span>ha<\/span><\/span>s been a\u00a0<\/span><\/span>5<\/span><\/span>% increase or greater<\/span><\/span>\u00a0<\/span><\/span>compared to<\/span><\/span>\u00a0<\/span><\/span>the previous period<\/span><\/span>\u00a0<\/span><\/span>and one for when there has been a 15% increase or greater.<\/span><\/span><\/span><\/p>\n

var threshold1 = 5;<\/code>
\nvar threshold2 = 15;<\/code><\/p>\n"},{"acf_fc_layout":"content","content":"

4. Format based on conditions <\/span>\u00a0<\/span>\u00a0<\/span><\/h2>\n

All that\u2019s left is to set up our indicator\u2019s formatting when the conditions we set are met. <\/span>We can set up t<\/span><\/span>hree\u00a0<\/span><\/span>formats; one for when there is no significant increase<\/span><\/span>,\u00a0<\/span><\/span>another for when there is<\/span><\/span>\u00a0significant increase, and the last for when there is an extreme increase.<\/span><\/span>\u00a0<\/span><\/span>\u00a0<\/span><\/span><\/p>\n

When there is no significant increase in earthquakes, we\u2019ll return the following:\u00a0<\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"","image_reference":false,"layout":"code_snippet","image_reference_figure":"","snippet":"if (percentChange < threshold1) {\r\n return { \r\n topText: 'Last 24 Hr', \r\n topTextMaxSize: 'medium', \r\n middleText: $datapoint["count"], \r\n middleTextMaxSize: 'large', \r\n } \r\n} ","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

In this format, the indicator will simply display the count of earthquakes in the last 24 hours, like the indicator below.
\n<\/span><\/p>\n

\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":843341,"id":843341,"title":"no change indicator","filename":"no-change-indicator.jpg","filesize":16116,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\/no-change-indicator","alt":"indicator with no significant change to count","author":"10072","description":"","caption":"","name":"no-change-indicator","status":"inherit","uploaded_to":838811,"date":"2020-04-29 14:59:48","modified":"2020-04-29 15:00:06","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":500,"height":374,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","medium-width":349,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","medium_large-width":500,"medium_large-height":374,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","large-width":500,"large-height":374,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","1536x1536-width":500,"1536x1536-height":374,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","2048x2048-width":500,"2048x2048-height":374,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","card_image-width":500,"card_image-height":374,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/no-change-indicator.jpg","wide_image-width":500,"wide_image-height":374}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

When there has been a significant increase in earthquakes, we\u2019ll set the following to return:\u00a0<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"","image_reference":false,"layout":"code_snippet","image_reference_figure":"","snippet":"else if (percentChange < threshold2) { \r\n return { \r\n textColor: 'red', \r\n topText: 'Last 24 Hr', \r\n topTextMaxSize: 'medium', \r\n middleText: $datapoint["count"], \r\n middleTextMaxSize: 'large', \r\n bottomText: percentChange + '% increase from yesterday', \r\n bottomTextMaxSize: 'small', \r\n iconName: 'up', \r\n iconAlign:'left', \r\n } \r\n} ","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

\u00a0<\/span><\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":843381,"id":843381,"title":"significant change indicator","filename":"significant-change-indicator.jpg","filesize":23694,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\/significant-change-indicator","alt":"indicator showing significant increase","author":"10072","description":"","caption":"","name":"significant-change-indicator","status":"inherit","uploaded_to":838811,"date":"2020-04-29 15:02:21","modified":"2020-04-29 15:02:44","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":490,"height":372,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","medium-width":344,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","medium_large-width":490,"medium_large-height":372,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","large-width":490,"large-height":372,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","1536x1536-width":490,"1536x1536-height":372,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","2048x2048-width":490,"2048x2048-height":372,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","card_image-width":490,"card_image-height":372,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/significant-change-indicator.jpg","wide_image-width":490,"wide_image-height":372}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Finally, when there has been an extreme increase in earthquakes, we\u2019ll return the following:<\/span><\/span>\u00a0<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"sidebar","content":"","image_reference":false,"layout":"code_snippet","image_reference_figure":"","snippet":"else if (percentChange < threshold2) { \r\n return { \r\n textColor: 'white',\r\n backgroundColor: 'red',\r\n topText: 'Last 24 Hr', \r\n topTextMaxSize: 'medium', \r\n middleText: $datapoint["count"], \r\n middleTextMaxSize: 'large', \r\n bottomText: percentChange + '% increase from yesterday', \r\n bottomTextMaxSize: 'small', \r\n iconName: 'warning', \r\n iconAlign: 'left', \r\n } \r\n} ","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false},{"acf_fc_layout":"content","content":"

In this case, if there has been an extreme increase, our indicator<\/span><\/span>\u00a0will turn red\u00a0<\/span><\/span>and a warning icon<\/span><\/span>\u00a0<\/span><\/span>will appear beside the count<\/span><\/span>\u00a0to bring quick attention to the change<\/span><\/span>.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":843411,"id":843411,"title":"extreme change indicator","filename":"extreme-change-indicator.jpg","filesize":25006,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\/extreme-change-indicator","alt":"indicator showing extreme increase","author":"10072","description":"","caption":"","name":"extreme-change-indicator","status":"inherit","uploaded_to":838811,"date":"2020-04-29 15:06:36","modified":"2020-04-29 15:06:58","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":490,"height":369,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","medium-width":347,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","medium_large-width":490,"medium_large-height":369,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","large-width":490,"large-height":369,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","1536x1536-width":490,"1536x1536-height":369,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","2048x2048-width":490,"2048x2048-height":369,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","card_image-width":490,"card_image-height":369,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/extreme-change-indicator.jpg","wide_image-width":490,"wide_image-height":369}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Your final expression will look something like this<\/span><\/span>.<\/span><\/span>\u00a0<\/span><\/p>\n"},{"acf_fc_layout":"image","image":{"ID":843461,"id":843461,"title":"final arcade expression","filename":"final-arcade-expression-2.jpg","filesize":56419,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\/final-arcade-expression-3","alt":"final arcade expression","author":"10072","description":"","caption":"","name":"final-arcade-expression-3","status":"inherit","uploaded_to":838811,"date":"2020-04-29 15:14:39","modified":"2020-04-29 15:14:51","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":543,"height":720,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2.jpg","medium-width":197,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2.jpg","medium_large-width":543,"medium_large-height":720,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2.jpg","large-width":543,"large-height":720,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2.jpg","1536x1536-width":543,"1536x1536-height":720,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2.jpg","2048x2048-width":543,"2048x2048-height":720,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2-351x465.jpg","card_image-width":351,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/final-arcade-expression-2.jpg","wide_image-width":543,"wide_image-height":720}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Take this technique and apply it to your own data to see how Arcade can be used in your dashboards to\u00a0<\/span>set up conditional formatting.\u00a0<\/span>Check out the advanced formatting <\/a><\/span>documentation<\/span>\u00a0for more information on defining properties in your elements.<\/span>\u00a0You can also\u00a0<\/span>make a copy of this dashboard<\/span><\/a>\u00a0to see the expression and the rest of the dashboard\u2019s configuration.<\/span>\u00a0<\/span><\/p>\n

The Dashboards team at\u00a0<\/span>Esri<\/span>\u00a0is excited to see how you use Arcade in your own dashboards to set conditional formatting. If you can, share your innovative dashboards with us using #ArcGISDashboards.\u00a0<\/span>\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n"}],"authors":[{"ID":8482,"user_firstname":"David","user_lastname":"Nyenhuis","nickname":"Dave Nyenhuis","user_nicename":"dnyenhuis","display_name":"David Nyenhuis","user_email":"DNyenhuis@esri.com","user_url":"","user_registered":"2018-10-26 13:47:59","user_description":"David Nyenhuis is a senior product engineer on the ArcGIS Dashboards team, driven by a simple idea: the best data experiences speak instantly. He specializes in distilling complexity into clear visual signals\u2014whether through maps, bold metrics, charts, or gauges\u2014so insights surface without effort. His work is guided by a passion for helping users build dashboards that stay current, invite exploration, and feel as refined as they are effective.","user_avatar":""},{"ID":10072,"user_firstname":"Noora","user_lastname":"Golabi","nickname":"ngolabi","user_nicename":"ngolabi","display_name":"Noora Golabi","user_email":"ngolabi@esri.com","user_url":"","user_registered":"2019-10-21 16:04:20","user_description":"Noora is a product writer with a background in Geography and GIS. Working from Ottawa, Canada, she focuses on writing documentation and creating resources for users. In her free time, she's often baking, exploring the outdoors, and spending time with her dog.","user_avatar":""}],"related_articles":[{"ID":832001,"post_author":"10072","post_date":"2020-04-23 08:25:26","post_date_gmt":"2020-04-23 15:25:26","post_content":"","post_title":"Communicating status with icons using Arcade in Dashboards","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"communicating-status-with-icons-in-the-arcgis-dashboards-beta","to_ping":"","pinged":"","post_modified":"2024-11-01 00:18:18","post_modified_gmt":"2024-11-01 07:18:18","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=832001","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":797531,"post_author":"8482","post_date":"2022-02-27 10:00:48","post_date_gmt":"2022-02-27 18:00:48","post_content":"","post_title":"Getting started with advanced formatting using Arcade in Dashboards","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"getting-started-with-arcade-in-arcgis-dashboards","to_ping":"","pinged":"","post_modified":"2024-11-01 00:01:30","post_modified_gmt":"2024-11-01 07:01:30","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=797531","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":800001,"post_author":"9082","post_date":"2020-04-09 08:00:01","post_date_gmt":"2020-04-09 15:00:01","post_content":"","post_title":"ArcGIS Dashboards Beta Now Available","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"arcgis-dashboards-beta-now-available","to_ping":"","pinged":"","post_modified":"2021-01-11 11:10:02","post_modified_gmt":"2021-01-11 19:10:02","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=800001","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"4","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/conditinalformattingcard-1.jpg","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/conditinalformattingbanner-1.jpg"},"yoast_head":"\nConditional formatting in dashboard indicators with Arcade<\/title>\n<meta name=\"description\" content=\"Learn how to use Arcade to create conditional formatting to provide context to your dashboard indicators in the ArcGIS Dashboards Beta.\" \/>\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\/real-time\/conditional-formatting-indicators-with-arcade\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conditional formatting in dashboard indicators with Arcade\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Arcade to create conditional formatting to provide context to your dashboard indicators in the ArcGIS Dashboards Beta.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\" \/>\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=\"2024-11-01T07:18:06+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\/real-time\/conditional-formatting-indicators-with-arcade#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\"},\"author\":{\"name\":\"Noora Golabi\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/d6d26bb8da3387354ff0b0189d79f68d\"},\"headline\":\"Conditional formatting in dashboard indicators with Arcade\",\"datePublished\":\"2020-04-29T15:30:25+00:00\",\"dateModified\":\"2024-11-01T07:18:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\"},\"wordCount\":7,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"arcade\",\"Dashboard\",\"dashboard design\",\"data visualization\",\"formatting\"],\"articleSection\":[\"Arcade\",\"Real-Time Visualization & Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\",\"name\":\"Conditional formatting in dashboard indicators with Arcade\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2020-04-29T15:30:25+00:00\",\"dateModified\":\"2024-11-01T07:18:06+00:00\",\"description\":\"Learn how to use Arcade to create conditional formatting to provide context to your dashboard indicators in the ArcGIS Dashboards Beta.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conditional formatting in dashboard indicators with Arcade\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/d6d26bb8da3387354ff0b0189d79f68d\",\"name\":\"Noora Golabi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg\",\"caption\":\"Noora Golabi\"},\"description\":\"Noora is a product writer with a background in Geography and GIS. Working from Ottawa, Canada, she focuses on writing documentation and creating resources for users. In her free time, she's often baking, exploring the outdoors, and spending time with her dog.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/ngolabi\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Conditional formatting in dashboard indicators with Arcade","description":"Learn how to use Arcade to create conditional formatting to provide context to your dashboard indicators in the ArcGIS Dashboards Beta.","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\/real-time\/conditional-formatting-indicators-with-arcade","og_locale":"en_US","og_type":"article","og_title":"Conditional formatting in dashboard indicators with Arcade","og_description":"Learn how to use Arcade to create conditional formatting to provide context to your dashboard indicators in the ArcGIS Dashboards Beta.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-11-01T07:18:06+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\/real-time\/conditional-formatting-indicators-with-arcade#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade"},"author":{"name":"Noora Golabi","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/d6d26bb8da3387354ff0b0189d79f68d"},"headline":"Conditional formatting in dashboard indicators with Arcade","datePublished":"2020-04-29T15:30:25+00:00","dateModified":"2024-11-01T07:18:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade"},"wordCount":7,"commentCount":1,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["arcade","Dashboard","dashboard design","data visualization","formatting"],"articleSection":["Arcade","Real-Time Visualization & Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade","name":"Conditional formatting in dashboard indicators with Arcade","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2020-04-29T15:30:25+00:00","dateModified":"2024-11-01T07:18:06+00:00","description":"Learn how to use Arcade to create conditional formatting to provide context to your dashboard indicators in the ArcGIS Dashboards Beta.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Conditional formatting in dashboard indicators with Arcade"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/d6d26bb8da3387354ff0b0189d79f68d","name":"Noora Golabi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/12\/IMG_20190105_125214-e1577129433605-213x200.jpg","caption":"Noora Golabi"},"description":"Noora is a product writer with a background in Geography and GIS. Working from Ottawa, Canada, she focuses on writing documentation and creating resources for users. In her free time, she's often baking, exploring the outdoors, and spending time with her dog.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/ngolabi"}]}},"text_date":"April 29, 2020","author_name":"Multiple Authors","author_page":"https:\/\/www.esri.com\/arcgis-blog\/products\/ops-dashboard\/real-time\/conditional-formatting-indicators-with-arcade","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/04\/conditinalformattingbanner-1.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":147192,"name":"Dashboard","slug":"dashboard","term_group":0,"term_taxonomy_id":147192,"taxonomy":"post_tag","description":"","parent":0,"count":22,"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":30111,"name":"data visualization","slug":"data-visualization","term_group":0,"term_taxonomy_id":30111,"taxonomy":"post_tag","description":"","parent":0,"count":97,"filter":"raw"},{"term_id":642031,"name":"formatting","slug":"formatting","term_group":0,"term_taxonomy_id":642031,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"}],"category_data":[{"term_id":777102,"name":"Arcade","slug":"arcade","term_group":0,"term_taxonomy_id":777102,"taxonomy":"category","description":"","parent":0,"count":98,"filter":"raw"},{"term_id":37121,"name":"Real-Time Visualization & Analytics","slug":"real-time","term_group":0,"term_taxonomy_id":37121,"taxonomy":"category","description":"","parent":0,"count":166,"filter":"raw"}],"product_data":[{"term_id":36591,"name":"Apps","slug":"apps","term_group":0,"term_taxonomy_id":36591,"taxonomy":"product","description":"","parent":0,"count":649,"filter":"raw"},{"term_id":36671,"name":"ArcGIS Dashboards","slug":"ops-dashboard","term_group":0,"term_taxonomy_id":36671,"taxonomy":"product","description":"","parent":36591,"count":195,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=ops-dashboard","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/838811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/10072"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=838811"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/838811\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=838811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=838811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=838811"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=838811"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=838811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

With this, if there has been a significant increase in earthquakes, our indicator text will now be red, and text will be added to the bottom stating the percent change from the day before.\u00a0<\/span><\/span>In addition, we\u2019ve<\/span><\/span> made it so that an icon also appears beside the count by configuring the “up” icon below the Arcade editor<\/span><\/span>. To le<\/span><\/span>arn more about using icons in indicators with Arcade, see <\/span><\/span>this article<\/span><\/span><\/a>.<\/span><\/span>\u00a0<\/span><\/p>\n