Set Bar Chart Series Color based on Aggregate Value

Dashboard Designer SharePoint 2013/2016, Office 365 versions
1

I am using a standard Column Bar Chart and would like to control the color of each series using the value of a column called “Color” in my list. I was able to do this with a Pie Chart; however, when I apply the same logic to a Column Bar Chart it does not recognize the specified color.

The Bar Chart is being used to show the results of system testing and we want to designate specific colors for “Untested, Pass, Fail, etc” … so that when users look at the charts, they recognize that Red is always “Fail” and Green is always “Pass”

2

Hi! Add this in DataSource -> Advanced -> handlers.aggregationSuccess

var colors = { 'Pass': 'green', 'Untested': '#00f', 'Fail': 'red'} data.groups .forEach(function(item){ item.color = colors[item.value]});

correct “colors” to your names of fields and nessesary colors. enjoy!

3

Hi Yuriy and thanks for the reply. I tried what you suggested and it did not work. I am not a developer, so I may need a little more guidance.

To simplify the troubleshooting, my aggregate column is ZZZZZ and I have 4 status values that I'm tracking. The attached image shows what the chart looks like without manipulating any of the series colors. It’s aggregating by “Team” and then “Status.” To make things simple, the “status” column was named ZZZZZ in my list. Below is the code I added to DataSource -> Advanced -> handlers.aggregationSuccess, but it is not working for me.

handlers.aggregationSuccess = function(data, logger) { var ZZZZZ = {'OPEN': 'gray', 'PASS': 'green', 'FAIL': 'red', 'CLOSE': 'blue'} data.groups .forEach(function(item){ item.color = ZZZZZ[item.value]}); return true; }

SeriesColor.png1264×674 17.8 KB

4

Hi!
Please, send us chart’s configuration (export it in the designer) and data (click ‘Export data’ above the console in the designer)

5

Export of the chart and export of the data into this thread below.

chart_export
{“dataSource”:{“webUrl”:"/sites/Projects/csiv3",“listUrl”:“Lists/ICRP”,“viewName”:“CRP for Dashboard”,“fields”:[“Functional_x0020_Area”,“ID”,“ZZZZZ”],“rootFolder”:null,“caml”:"\n \n \n \n <FieldRef Name=“Scenario_x0020_Scope”/>\n <Value Type=“Text”>CRP / UNIT TEST\n \n \n \n \n <FieldRef Name=“Functional_x0020_Area”/>\n <FieldRef Name=“ID”/>\n <FieldRef Name=“ZZZZZ”/>\n \n <RowLimit Paged=“TRUE”>2000\n <Aggregations Value=“Off”/>\n\n",“group”:{“field”:“ZZZZZ”,“aggregates”:[{“result”:“StatusCount”,“field”:“ID”,“aggregate”:“count”}]},“handlers”:“var handlers = {};\nhandlers.init = function(data, logger) {\n data.items = [\n {value: 0, finger: ‘Thumb’, red: 0, green: 100},\n {value: 100, finger: ‘Index’, red: 160, green: 100},\n {value: 160, finger: ‘Middle’, red: 80, green: 100},\n {value: 100, finger: ‘Ring’, red: 60, green: 100},\n {value: 80, finger: ‘Pinky’, red: 40, green: 100}\n ];\n logger.debug('Data is initialized: ', data);\n return true;\n}\n\nhandlers.requestInit = function(query, logger) {\n return true;\n}\n\nhandlers.requestSuccess = function(data, logger) {\n return true;\n}\n\nhandlers.requestError = function(error, logger) {\n return $.Deferred().reject(error);\n}\n\nhandlers.aggregationSuccess = function(data, logger) {\n var ZZZZZ = {‘OPEN’: ‘#34bcfc’, ‘PASS’: ‘#309b46’,\n ‘FAIL’: ‘#e61e26’, ‘CLOSE’: ‘#bfbfbe’}\n data.groups\n .forEach(function(item){\n item.color = ZZZZZ[item.value]});\n return true;\n}\n\nhandlers.aggregationError = function(error, logger) {\n return $.Deferred().reject(error);\n}\n\nhandlers.finish = function(data, logger) {\n logger.debug('Data is processed: ', data);\n return true;\n}”},“dashboard”:{“chart”:{“seriesDefaults”:{“type”:“column”,“opacity”:1,“labels”:{“visible”:true,“position”:“center”,“format”:"{0}"}},“series”:{“groupsAsSeries”:true,“fieldSets”:[{“categoryField”:“Functional_x0020_Area”,“field”:“ID”,“aggregate”:“count”}]},“categoryAxis”:{“baseUnit”:“fit”,“baseUnitStep”:“auto”,“labels”:{“format”:""},“majorGridLines”:{“visible”:true},“minorGridLines”:{“visible”:false},“crosshair”:{“visible”:false}},“theme”:“metro”,“legend”:{“visible”:true,“position”:“bottom”},“tooltip”:{“visible”:true,“format”:"{0}"},“valueAxis”:{“labels”:{“format”:""},“majorGridLines”:{“visible”:true},“minorGridLines”:{“visible”:false},“crosshair”:{“visible”:false},“type”:“numeric”}},“width”:“100%”,“height”:300,“handlers”:“var handlers = {};\nhandlers.preRender = function(config, logger) {\n logger.debug('Configuration: ', config);\n return true;\n}”}}

data_export
{“items”:[{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:1,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:2,“ZZZZZ”:“PASS”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:3,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:4,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:5,“ZZZZZ”:“CLOSE”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:6,“ZZZZZ”:“CLOSE”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:7,“ZZZZZ”:“PASS”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:8,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:9,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:10,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:11,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:12,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:13,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:14,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:15,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:16,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:17,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:18,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:19,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:20,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:21,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:22,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:23,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:24,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:25,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:26,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:27,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:28,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:29,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:30,“ZZZZZ”:“PASS”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:31,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:32,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:33,“ZZZZZ”:“CLOSE”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:34,“ZZZZZ”:“CLOSE”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:35,“ZZZZZ”:“PASS”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:36,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:37,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:38,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:39,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:40,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:41,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:42,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:43,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:44,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:45,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:46,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:47,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:48,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:49,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:50,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:51,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:52,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:53,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:54,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:55,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:56,“ZZZZZ”:“OPEN”}],“groups”:[{“field”:“ZZZZZ”,“value”:“CLOSE”,“items”:[{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:5,“ZZZZZ”:“CLOSE”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:6,“ZZZZZ”:“CLOSE”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:33,“ZZZZZ”:“CLOSE”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:34,“ZZZZZ”:“CLOSE”}],“hasSubgroups”:false,“aggregates”:{“ID”:{“count”:4}},“StatusCount”:4,“color”:"#bfbfbe"},{“field”:“ZZZZZ”,“value”:“FAIL”,“items”:[{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:13,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:8,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:9,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:10,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:11,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:12,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:3,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:31,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:32,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:41,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:4,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:36,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:37,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:38,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:39,“ZZZZZ”:“FAIL”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:40,“ZZZZZ”:“FAIL”}],“hasSubgroups”:false,“aggregates”:{“ID”:{“count”:16}},“StatusCount”:16,“color”:"#e61e26"},{“field”:“ZZZZZ”,“value”:“OPEN”,“items”:[{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:29,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:22,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:23,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:24,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:25,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:26,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:27,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:28,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:54,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:53,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:1,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:55,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:14,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:15,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:52,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:16,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:17,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:18,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:19,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:20,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:21,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:42,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:43,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:44,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:45,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:46,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:47,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:48,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:49,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:50,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:51,“ZZZZZ”:“OPEN”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:56,“ZZZZZ”:“OPEN”}],“hasSubgroups”:false,“aggregates”:{“ID”:{“count”:32}},“StatusCount”:32,“color”:"#34bcfc"},{“field”:“ZZZZZ”,“value”:“PASS”,“items”:[{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:35,“ZZZZZ”:“PASS”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:30,“ZZZZZ”:“PASS”},{“Functional_x0020_Area”:“TEAM B”,“Functional_x0020_AreaId”:10,"_Functional_x0020_Area":{"$1b_1":10,"$4r_1":“TEAM B”},“ID”:2,“ZZZZZ”:“PASS”},{“Functional_x0020_Area”:“TEAM A”,“Functional_x0020_AreaId”:9,"_Functional_x0020_Area":{"$1b_1":9,"$4r_1":“TEAM A”},“ID”:7,“ZZZZZ”:“PASS”}],“hasSubgroups”:false,“aggregates”:{“ID”:{“count”:4}},“StatusCount”:4,“color”:"#309b46"}]}

6

Hi, try to delete my previous script from DS->Advanced and put this one to Dashboard -> Advanced -> handlers.preRender

var colors = {'OPEN': '#34bcfc', 'PASS': '#309b46', 'FAIL': '#e61e26', 'CLOSE': '#bfbfbe'} config.series .forEach(function(item){ item.color = colors[item.name]});

1 Like
7

Hi Yuriy,

Much thanks! That seems to have done the trick. Our status values and aggregates are a little more complicated (I changed all the values to simplify), so I am going to change everything back and am confident that it should work for us. Again, I appreciate the guidance.