topic Dashboard - Conditional Formatting on Table using multiple Keywords from the same field. in ArcGIS Dashboards Questions

Dashboard - Conditional Formatting on Table using multiple Keywords from the same field.

LindsayLewin — Sun, 28 Jul 2024 17:26:40 GMT

Hello.

I have a table where I would like to highlight entire rows different colors based on 3 choices from the same field.

I have one choice highlighted, but not sure how to include the other two, which would have a different highlight. Any suggestions would be appreciated.

Here is a little snapshot of my code

// Highlight descriptions with a keyword

var keyword = 'DAC';

// Use Find() to determine the index of the word

var hasKeyword = Find(keyword, Upper($datapoint["Status"])) >= 0;

// Update text and background colors if it has the keyword

return {

cells: {

GridID: {

displayText : Text($datapoint.GridID),

textColor: IIF(hasKeyword, '#000000', ''),

backgroundColor: IIF(hasKeyword, '#BDD7EE', ''),

textAlign: 'center',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

Re: Dashboard - Conditional Formatting on Table using multiple Keywords from the same field.

Davide_Pili — Mon, 29 Jul 2024 07:56:25 GMT

Hi LindsayLewin

I hope I understood your request well.
Try this Arcade code:

var highlight = ''

var colorText =''

if($datapoint.Status== 'DAC'){

highlight = '#89ac76'

colorText = '#ffffff'

}

if ($datapoint.Status == 'Staked'){

highlight= '#3d642d'

colorText = '#ffffff'

}

return {

cells: {

GRID_ID: {

displayText : Text($datapoint.GRID_ID),

textColor: colorText,

backgroundColor: highlight,

textAlign: 'right',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

Status: {

displayText : $datapoint.Status,

textColor: colorText,

backgroundColor: highlight,

textAlign: 'left',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

Seeded: {

displayText : Text($datapoint.Seeded),

textColor: colorText,

backgroundColor: highlight,

textAlign: 'left',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

seedDepth: {

displayText : Text($datapoint.seedDepth),

textColor: colorText,

backgroundColor: highlight,

textAlign: 'right',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

}

Re: Dashboard - Conditional Formatting on Table using multiple Keywords from the same field.

LindsayLewin — Tue, 30 Jul 2024 17:16:12 GMT

This worked great!

Thank you!

Lindsay

Re: Dashboard - Conditional Formatting on Table using multiple Keywords from the same field.

AmySnelgrove1 — Thu, 15 Aug 2024 22:19:49 GMT

Ignore! I figure out my mistake!