{"id":2225202,"date":"2024-01-12T15:57:14","date_gmt":"2024-01-12T23:57:14","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=2225202"},"modified":"2024-10-31T23:56:30","modified_gmt":"2024-11-01T06:56:30","slug":"arcade-expressions-pro-charts","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts","title":{"rendered":"Arcade Expressions in Pro Charts"},"author":157441,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341,777102],"tags":[24311,32551,42181,30821],"industry":[],"product":[36561],"class_list":["post-2225202","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-arcade","tag-analysis","tag-arcade","tag-arcgis-pro","tag-charts","product-arcgis-pro"],"acf":{"short_description":"This post demonstrates how Arcade expressions can be used to configure your charts in Pro.","flexible_content":[{"acf_fc_layout":"content","content":"

In ArcGIS Pro 3.1, the Charts development team introduced the ability to configure charts with Arcade<\/a> expressions. Now you can use expressions to tweak your data visualizations on the fly without needing to update your dataset or schema. Currently, Arcade expressions are available to configure bar charts, pie charts, line charts, histograms, and scatter plots.\u00a0Arcade is a powerful expression language that opens countless possibilities for visualizing your data in Pro, and in this blog I’ll show three cases where charts are configured using Arcade expressions.<\/p>\n

Reformatting Text<\/h3>\n

Let\u2019s start with a simple example. Suppose you create this bar chart to see which states have had the most bigfoot sightings (download data here<\/a>\u2014but note that I’ve altered some fields for demo purposes). You quickly discover that the category labels are formatted in all caps:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221122,"id":2221122,"title":"bar_original","filename":"bar_original-1.png","filesize":48378,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/bar_original-2","alt":"","author":"157441","description":"","caption":"","name":"bar_original-2","status":"inherit","uploaded_to":0,"date":"2024-01-09 19:38:41","modified":"2024-01-09 19:38:41","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":795,"height":442,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","medium-width":464,"medium-height":258,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","medium_large-width":768,"medium_large-height":427,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","large-width":795,"large-height":442,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","1536x1536-width":795,"1536x1536-height":442,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","2048x2048-width":795,"2048x2048-height":442,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","card_image-width":795,"card_image-height":442,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_original-1.png","wide_image-width":795,"wide_image-height":442}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

You\u2019re worried that this chart will appear aggressive and shouty, but you\u2019re also unable to update the attribute table to reformat the category labels because the dataset is read-only. Fortunately, you can use Arcade to reformat these values without needing to update the attribute table. First, click the Arcade expression button to the right of the Category or Date<\/strong> dropdown:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221202,"id":2221202,"title":"expression_button","filename":"expression_button.png","filesize":4164,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","link":"https:\/\/www.esri.com\/arcgis-blog\/expression_button","alt":"","author":"157441","description":"","caption":"","name":"expression_button","status":"inherit","uploaded_to":0,"date":"2024-01-09 20:00:49","modified":"2024-01-09 20:00:49","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":334,"height":85,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button-213x85.png","thumbnail-width":213,"thumbnail-height":85,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","medium-width":334,"medium-height":85,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","medium_large-width":334,"medium_large-height":85,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","large-width":334,"large-height":85,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","1536x1536-width":334,"1536x1536-height":85,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","2048x2048-width":334,"2048x2048-height":85,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","card_image-width":334,"card_image-height":85,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/expression_button.png","wide_image-width":334,"wide_image-height":85}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

An Expression Window opens and here you can enter the title of your expression as well as your expression code:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221162,"id":2221162,"title":"bar_expression","filename":"bar_expression-1.png","filesize":20091,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/bar_expression-2","alt":"","author":"157441","description":"","caption":"","name":"bar_expression-2","status":"inherit","uploaded_to":0,"date":"2024-01-09 19:42:35","modified":"2024-01-09 19:42:35","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":519,"height":563,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1.png","medium-width":241,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1.png","medium_large-width":519,"medium_large-height":563,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1.png","large-width":519,"large-height":563,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1.png","1536x1536-width":519,"1536x1536-height":563,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1.png","2048x2048-width":519,"2048x2048-height":563,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1-429x465.png","card_image-width":429,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_expression-1.png","wide_image-width":519,"wide_image-height":563}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

This expression uses the Proper<\/a> Arcade function to format the text to title case<\/a>:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221132,"id":2221132,"title":"bar_arcade","filename":"bar_arcade-1.png","filesize":48893,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/bar_arcade-2","alt":"","author":"157441","description":"","caption":"","name":"bar_arcade-2","status":"inherit","uploaded_to":0,"date":"2024-01-09 19:39:01","modified":"2024-01-09 19:39:01","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":795,"height":442,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","medium-width":464,"medium-height":258,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","medium_large-width":768,"medium_large-height":427,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","large-width":795,"large-height":442,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","1536x1536-width":795,"1536x1536-height":442,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","2048x2048-width":795,"2048x2048-height":442,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","card_image-width":795,"card_image-height":442,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/bar_arcade-1.png","wide_image-width":795,"wide_image-height":442}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

That looks much nicer\u2014and it was possible with a single line of Arcade code, without needing to update our dataset.<\/p>\n

Converting Data<\/h3>\n

Unit conversion is another common data preparation task that can many times be handled with Arcade. Our dataset has a field that reflects the high temperature on the day of each bigfoot sighting, and we’d like to see the distribution of these values using a histogram. However, we realize that the values are given in Fahrenheit and we’re presenting the chart to an international audience that is more accustomed to Celsius:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221082,"id":2221082,"title":"hist_original","filename":"hist_original-1.png","filesize":33509,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/hist_original-2","alt":"","author":"157441","description":"","caption":"","name":"hist_original-2","status":"inherit","uploaded_to":0,"date":"2024-01-09 19:34:41","modified":"2024-01-09 19:34:41","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":795,"height":442,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","medium-width":464,"medium-height":258,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","medium_large-width":768,"medium_large-height":427,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","large-width":795,"large-height":442,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","1536x1536-width":795,"1536x1536-height":442,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","2048x2048-width":795,"2048x2048-height":442,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","card_image-width":795,"card_image-height":442,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_original-1.png","wide_image-width":795,"wide_image-height":442}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Using Arcade we can convert the data to Celsius using basic mathematical operations to calculate the Fahrenheit-to-Celsius formula<\/a>:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2220882,"id":2220882,"title":"hist_expression","filename":"hist_expression.png","filesize":17485,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression.png","link":"https:\/\/www.esri.com\/arcgis-blog\/hist_expression","alt":"","author":"157441","description":"","caption":"","name":"hist_expression","status":"inherit","uploaded_to":0,"date":"2024-01-09 19:06:57","modified":"2024-01-09 19:06:57","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":519,"height":563,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression.png","medium-width":241,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression.png","medium_large-width":519,"medium_large-height":563,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression.png","large-width":519,"large-height":563,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression.png","1536x1536-width":519,"1536x1536-height":563,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression.png","2048x2048-width":519,"2048x2048-height":563,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression-429x465.png","card_image-width":429,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_expression.png","wide_image-width":519,"wide_image-height":563}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

And now we have a histogram that displays the temperature distribution in Celsius:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221712,"id":2221712,"title":"hist_arcade","filename":"hist_arcade-3.png","filesize":39577,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","link":"https:\/\/www.esri.com\/arcgis-blog\/hist_arcade-4","alt":"","author":"157441","description":"","caption":"","name":"hist_arcade-4","status":"inherit","uploaded_to":0,"date":"2024-01-10 01:43:06","modified":"2024-01-10 01:43: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":795,"height":442,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","medium-width":464,"medium-height":258,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","medium_large-width":768,"medium_large-height":427,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","large-width":795,"large-height":442,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","1536x1536-width":795,"1536x1536-height":442,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","2048x2048-width":795,"2048x2048-height":442,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","card_image-width":795,"card_image-height":442,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/hist_arcade-3.png","wide_image-width":795,"wide_image-height":442}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Reclassifying Data<\/h3>\n

Finally, let\u2019s look at a more advanced example. Data often needs to be wrangled to prepare it for visualization, particularly when dealing with categorical values. For instance, here is a chart showing noise complaints over time for Montgomery County, Maryland (download data here<\/a>). The chart is split by the Case_Type<\/em> field so that each line reflects noise complaints for a specific type: <\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221032,"id":2221032,"title":"line_original","filename":"line_original-2.png","filesize":186382,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","link":"https:\/\/www.esri.com\/arcgis-blog\/line_original-3","alt":"","author":"157441","description":"","caption":"","name":"line_original-3","status":"inherit","uploaded_to":0,"date":"2024-01-09 19:31:42","modified":"2024-01-09 19:31:42","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":795,"height":442,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","medium-width":464,"medium-height":258,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","medium_large-width":768,"medium_large-height":427,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","large-width":795,"large-height":442,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","1536x1536-width":795,"1536x1536-height":442,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","2048x2048-width":795,"2048x2048-height":442,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","card_image-width":795,"card_image-height":442,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_original-2.png","wide_image-width":795,"wide_image-height":442}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

This chart is a mess of lines that\u2019s nearly impossible to interpret; this is mainly because the categories are too granular. We really only need to see a general breakdown of noise complaints. Fortunately, we can easily reclassify the values by creating an expression for the Split by<\/strong> variable. The following expression uses logical statements and the Find<\/a> function to determine whether each category value contains the text “Industrial” or “Residential”\u2014the expression reclassifies each value accordingly. If the category does not contain either keyword, the value is classified as Other:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2220932,"id":2220932,"title":"line_expression","filename":"line_expression.png","filesize":21327,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression.png","link":"https:\/\/www.esri.com\/arcgis-blog\/line_expression","alt":"","author":"157441","description":"","caption":"","name":"line_expression","status":"inherit","uploaded_to":0,"date":"2024-01-09 19:13:13","modified":"2024-01-09 19:13:13","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":519,"height":563,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression.png","medium-width":241,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression.png","medium_large-width":519,"medium_large-height":563,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression.png","large-width":519,"large-height":563,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression.png","1536x1536-width":519,"1536x1536-height":563,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression.png","2048x2048-width":519,"2048x2048-height":563,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression-429x465.png","card_image-width":429,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_expression.png","wide_image-width":519,"wide_image-height":563}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

And here’s the chart using the reclassification expression we’ve created:<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2221472,"id":2221472,"title":"line_arcade","filename":"line_arcade-3.png","filesize":56551,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","link":"https:\/\/www.esri.com\/arcgis-blog\/line_arcade-4","alt":"","author":"157441","description":"","caption":"","name":"line_arcade-4","status":"inherit","uploaded_to":0,"date":"2024-01-09 21:19:33","modified":"2024-01-09 21:19:33","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":799,"height":448,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","medium-width":464,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","medium_large-width":768,"medium_large-height":431,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","large-width":799,"large-height":448,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","1536x1536-width":799,"1536x1536-height":448,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","2048x2048-width":799,"2048x2048-height":448,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","card_image-width":799,"card_image-height":448,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2023\/12\/line_arcade-3.png","wide_image-width":799,"wide_image-height":448}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"

Now that we\u2019ve reclassified the data, the patterns are much clearer. For instance, we see that both Residential and Industrial noise complaints tend to be seasonal and spike during the summer months. For Residential complaints, we see a particularly large spike during the summer of 2020. This was during the peak of COVID stay-at-home orders, so you could hypothesize that people were more likely to complain about residential noise because they were spending many hours at home.<\/p>\n

\n

Arcade is a powerful tool for preparing and massaging data for visualization, but it comes with one caveat. Because Arcade expressions are calculated on the fly, they may impact chart performance. Therefore, proceed with caution when dealing with large datasets or performing intense operations\u2014in such cases it may be advisable to use the field calculator to calculate new field values stored in the dataset if possible.<\/p>\n

We hope that this blog post gives you a glimpse into what\u2019s possible when using Arcade to configure charts in Pro. We encourage you to find creative ways to incorporate Arcade expressions into your next data visualization project!<\/p>\n"}],"authors":[{"ID":157441,"user_firstname":"Christopher","user_lastname":"Allen","nickname":"Christopher Allen","user_nicename":"callen","display_name":"Chris Allen","user_email":"callen@esri.com","user_url":"","user_registered":"2021-01-13 22:34:06","user_description":"Chris is a product engineer on the Pro Charts team, where he puts his background in GIS, data science, and visualization to good use. In his free time, Chris enjoys taking walks, supporting the Milwaukee Bucks, and watching old episodes of Huell Howser on PBS.","user_avatar":""}],"related_articles":"","card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/01\/banner2-1.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/01\/linebanner-17.png"},"yoast_head":"\nArcade Expressions in Pro Charts<\/title>\n<meta name=\"description\" content=\"This post demonstrates how Arcade expressions can be used to configure your charts in Pro.\" \/>\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\/arcgis-pro\/analytics\/arcade-expressions-pro-charts\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Arcade Expressions in Pro Charts\" \/>\n<meta property=\"og:description\" content=\"This post demonstrates how Arcade expressions can be used to configure your charts in Pro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts\" \/>\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-01T06:56:30+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\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts\"},\"author\":{\"name\":\"Chris Allen\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/56dfaef3f02a3ce06f957e1efa80057b\"},\"headline\":\"Arcade Expressions in Pro Charts\",\"datePublished\":\"2024-01-12T23:57:14+00:00\",\"dateModified\":\"2024-11-01T06:56:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts\"},\"wordCount\":5,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Analysis\",\"arcade\",\"ArcGIS Pro\",\"charts\"],\"articleSection\":[\"Analytics\",\"Arcade\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts\",\"name\":\"Arcade Expressions in Pro Charts\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2024-01-12T23:57:14+00:00\",\"dateModified\":\"2024-11-01T06:56:30+00:00\",\"description\":\"This post demonstrates how Arcade expressions can be used to configure your charts in Pro.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arcade Expressions in Pro Charts\"}]},{\"@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\/56dfaef3f02a3ce06f957e1efa80057b\",\"name\":\"Chris Allen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/01\/ca_smaller-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/01\/ca_smaller-213x200.jpg\",\"caption\":\"Chris Allen\"},\"description\":\"Chris is a product engineer on the Pro Charts team, where he puts his background in GIS, data science, and visualization to good use. In his free time, Chris enjoys taking walks, supporting the Milwaukee Bucks, and watching old episodes of Huell Howser on PBS.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/callen\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Arcade Expressions in Pro Charts","description":"This post demonstrates how Arcade expressions can be used to configure your charts in Pro.","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\/arcgis-pro\/analytics\/arcade-expressions-pro-charts","og_locale":"en_US","og_type":"article","og_title":"Arcade Expressions in Pro Charts","og_description":"This post demonstrates how Arcade expressions can be used to configure your charts in Pro.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2024-11-01T06:56:30+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\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts"},"author":{"name":"Chris Allen","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/56dfaef3f02a3ce06f957e1efa80057b"},"headline":"Arcade Expressions in Pro Charts","datePublished":"2024-01-12T23:57:14+00:00","dateModified":"2024-11-01T06:56:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts"},"wordCount":5,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Analysis","arcade","ArcGIS Pro","charts"],"articleSection":["Analytics","Arcade"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts","name":"Arcade Expressions in Pro Charts","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2024-01-12T23:57:14+00:00","dateModified":"2024-11-01T06:56:30+00:00","description":"This post demonstrates how Arcade expressions can be used to configure your charts in Pro.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/arcade-expressions-pro-charts#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Arcade Expressions in Pro Charts"}]},{"@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\/56dfaef3f02a3ce06f957e1efa80057b","name":"Chris Allen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/01\/ca_smaller-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/01\/ca_smaller-213x200.jpg","caption":"Chris Allen"},"description":"Chris is a product engineer on the Pro Charts team, where he puts his background in GIS, data science, and visualization to good use. In his free time, Chris enjoys taking walks, supporting the Milwaukee Bucks, and watching old episodes of Huell Howser on PBS.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/callen"}]}},"text_date":"January 12, 2024","author_name":"Chris Allen","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/callen","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/01\/linebanner-17.png","primary_product":"ArcGIS Pro","tag_data":[{"term_id":24311,"name":"Analysis","slug":"analysis","term_group":0,"term_taxonomy_id":24311,"taxonomy":"post_tag","description":"","parent":0,"count":96,"filter":"raw"},{"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":42181,"name":"ArcGIS Pro","slug":"arcgis-pro","term_group":0,"term_taxonomy_id":42181,"taxonomy":"post_tag","description":"","parent":0,"count":323,"filter":"raw"},{"term_id":30821,"name":"charts","slug":"charts","term_group":0,"term_taxonomy_id":30821,"taxonomy":"post_tag","description":"","parent":0,"count":46,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1325,"filter":"raw"},{"term_id":777102,"name":"Arcade","slug":"arcade","term_group":0,"term_taxonomy_id":777102,"taxonomy":"category","description":"","parent":0,"count":98,"filter":"raw"}],"product_data":[{"term_id":36561,"name":"ArcGIS Pro","slug":"arcgis-pro","term_group":0,"term_taxonomy_id":36561,"taxonomy":"product","description":"","parent":0,"count":2035,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-pro","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2225202","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\/157441"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=2225202"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2225202\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2225202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2225202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2225202"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2225202"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2225202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}