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
Where are you generating the report? i.e. dashboard, etc.
Hi Robert,
Using the Survey123 website. Is there any other way to export a report to get this work?
Thanks,
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
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.