Select to view content in your preferred language

Create an if or iif statement for Details or List

3104
11
Jump to solution
02-22-2022 06:52 AM
Labels (1)
RobertBorchert
Honored Contributor

I am wondering if it is possible to create an "if" or "iif" statement in a dashboard.

More specifically in Details or List.

I have tried a variety of options.

var cracking = $feature.FOUNDATIONCRACKING:
iif(cracking = 'Yes', 'Var1','Var2')

iif($feature.FOUNDATIONCRACKING = 'Yes', 'Var1','Var2')

We are using Enterprise and Portal

The information is coming from a Survey and is stored as part of a feature.

My intent for the results of this is when a answer is an aberration that I can make the font red. 

In this example FOUNDATIONCRACKING is a question as to whether or not the foundation is cracking. If the answer is Yes I want to do something like this for the results of the "if" statement     

<font color='red'>FOUNDATIONCRACKING</FONT>,FOUNDATIONCRACKING

 

0 Kudos
11 Replies
RobertBorchert
Honored Contributor

Now what I need to do this for multiple answers.  The FOUNDATONCRACKING is the first question.

The second question is FOUNDATIONSPALLING. What this currently doing is keeping everything RED until the next No  answer then back to red when there is a Yes

0 Kudos
RobertBorchert
Honored Contributor

Thank you very much.  exactly what I was looking for

RobertBorchert_0-1645554140130.png

 

0 Kudos