topic Re: Report conditional if statement in ArcGIS Survey123 Questions

Report conditional if statement

AnuSawant — Thu, 19 May 2022 02:04:07 GMT

Hi there,

I am trying to add a conditional statement in my report so that I can get color coded risk score.

In my survey Risk Score is calculated on a risk probability and impact (various parameters).

e.g. flood probability - alright

flood impact - severe

Risk score - Extreme

I am struggling to get the query correct as I am having various parameters for which risk been calculated.

if(${flooding_risk== 'Almost_certain' }and ${flooding_impact== 'Severe'},)Extreme (25)

if(${flooding_risk}== 'Likely' and ${flooding_impact}== 'Severe',)Extreme (20)

result it is showing

I am expecting my result should print only "Extreme (25)" or "Extreme (20)" if its present in the record.

Any help would be appreciated.

Thanks,

Anu

Re: Report conditional if statement

RobertBorchert — Thu, 19 May 2022 12:52:39 GMT

Where are you generating the report? i.e. dashboard, etc.

Re: Report conditional if statement

AnuSawant — Thu, 19 May 2022 21:16:40 GMT

Hi Robert,

Using the Survey123 website. Is there any other way to export a report to get this work?

Thanks,

Re: Report conditional if statement

RobertBorchert — Fri, 20 May 2022 13:11:53 GMT

setting the color of the font in the code won't change the end result.

You will need to use color coding. But I don't think it will work in the web site.

You can export the table to excel and manually color code based on the number

Re: Report conditional if statement

AnuSawant — Sun, 22 May 2022 19:54:55 GMT

Yes exporting to either word or excel would be the last option. I have been waiting for this colour coding works on the template for long. Hopefully we will get this thing working sooner or later.

Thanks Robert for your help.