topic Conditional Formating in Tables using Advanced formatting in ArcGIS Dashboards Questions

Conditional Formating in Tables using Advanced formatting

VerleyAltamirano — Tue, 22 Feb 2022 15:48:45 GMT

Hello,

I am creating a table with data collected in a survey, these data are discrete, my idea is to condition the data, for example, if the value is "0" it changes the format of the field to red and if it is "5" it changes to green.

It is a simple process in an indicator, the problem is to define each of the cells to format the table depending on the column.

Can someone help me with the initial syntax to be able to find what I'm looking for?

Re: Conditional Formating in Tables using Advanced formatting

abelvang_3ID — Tue, 19 Nov 2024 15:02:35 GMT

Verley,

Something I've been playing with is the variables in the settings . Some of the Arcade coding I'm testing out is as follows:
var color= IIF($datapoint.[input location] = 0 , 'red', '')

var color = IIF($datapoint.[input location] > 4, 'green','')

then doing this to the values

[INPUT LOCATION]: {

displayText : Text($datapoint.[input location]),

textColor: '',

backgroundColor: color,

textAlign: 'right',

iconName: '',

iconAlign: '',

iconColor: '',

iconOutlineColor: ''

try that and see if it gives you what you're looking for.

Re: Conditional Formating in Tables using Advanced formatting

abelvang_3ID — Tue, 19 Nov 2024 15:05:01 GMT

You can also reference the link below for further help on this.

https://doc.arcgis.com/en/dashboards/10.9.1/create-and-share/advanced-formatting.htm