topic Re: Replace values with text using Arcade in a list in ArcGIS Dashboards Questions

Replace values with text using Arcade in a list

dwold — Fri, 18 Aug 2023 18:40:51 GMT

How would I convert values (0,1) with yes/no in a list?

This is what I tried but not right

Data Table:

Re: Replace values with text using Arcade in a list

KenBuja — Fri, 18 Aug 2023 18:47:15 GMT

You should use the When function. Is the field numeric or a string?

//if it's a number var over = When($datapoint['IsOverriden'] == 0, 'No', $datapoint['IsOverriden'] == 1, 'Yes', ''); //if it's a string var over = When($datapoint['IsOverriden'] == '0', 'No', $datapoint['IsOverriden'] == '1', 'Yes', '');

Re: Replace values with text using Arcade in a list

dwold — Fri, 18 Aug 2023 18:53:31 GMT

@KenBuja Thank you!

Re: Replace values with text using Arcade in a list

dwold — Fri, 18 Aug 2023 20:19:54 GMT

@KenBuja If I wanted to hide the Override line if the value is 0 would that be done through an if statement? Or can that still be done using the when statement?

Showing only records that have 1/yes

Re: Replace values with text using Arcade in a list

KenBuja — Mon, 21 Aug 2023 12:47:07 GMT

How are you constructing the text block?

Re: Replace values with text using Arcade in a list

dwold — Mon, 21 Aug 2023 15:15:39 GMT

@KenBuja I removed the == 0, 'No', line thinking the list would remove/hide the 0 values, but it still read Score override: (because that is part of the text block)

(didn't think it would be that easy but gave it a shot)

Doing this:

and then:

{expression/icon}

{AssesmentName}

Created on {expression/create}

Created by {Creator}

Score override: {expression/over}

Re: Replace values with text using Arcade in a list

KenBuja — Mon, 21 Aug 2023 15:28:32 GMT

Instead of putting "Score override: " in the text block, add that in the expression only if the value is "Yes"

If ($datapoint['IsOverriden'] == 1) return 'Score override: Yes';

Re: Replace values with text using Arcade in a list

dwold — Mon, 21 Aug 2023 19:07:14 GMT

Great, thank you!

Re: Replace values with text using Arcade in a list

dwold — Tue, 22 Aug 2023 11:38:53 GMT

@KenBuja I'm new to arcade so I don't think I am doing something right. When I remove the text block that line is deleted (even values with 1/yes). Does the return call look in the right spot? See anything that I am doing wrong?

Re: Replace values with text using Arcade in a list

KenBuja — Tue, 22 Aug 2023 14:21:02 GMT

I'm sorry, I was incorrect. That should be

If ($datapoint['IsOverriden'] == 1) var over = 'Score override: Yes';

Keep 'over' in the attributes and {expression/over} in the template

Re: Replace values with text using Arcade in a list

dwold — Tue, 22 Aug 2023 19:22:00 GMT

Great, worked perfectly! Thank you!