Dashboard Advanced Formatting Arcade

Anonymous User

Hello,

Having issues trying to get this to work.  I am in dashboard using list widget, advanced formatting. The goal is if

#1. postdate > 48 hours, background changes to red. 

#2. but if postdate is empty or if there is a close date, do nothing

#3. also if there is no postdate or no close date, do nothing.

I can get a part of it to work but not all of it.  I have tried using IIF and WHEN.

What I have tried and the results. All help is appreciated.  Thank you.

var pastduecolor = IIF(IsEmpty($datapoint.campclosedate) && (currentdate > twodayslater), " ", "#BE2528")

When using the above  #1, #3 work

var pastduecolor = IIF((currentdate > twodayslater)," ", "#BE2528")

When using the above  #2, #3 work

var pastduecolor = IIF(!IsEmpty($datapoint.campclosedate) && (currentdate > twodayslater), " ", "#BE2528 ")

When using the above # 1, #2 work

 var pastduecolor = When(IsEmpty($datapoint.campclosedate) && (currentdate > twodayslater), "#BE2528", IsEmpty($datapoint.firstpostda1) && IsEmpty($datapoint.campclosedate), " ", " ")

When using above #1, #2 work

 

Thank you very  much,

Annette

 

jcarlson

Hi Annette,

Just back from 2 weeks' vacation. I think the trouble here is that "||" and "&&" are used for boolean conditions that can evaluate to "true" or "false", something like

$datapoint.firstpostda1 > 48 || !IsEmpty($datapoint.campclosedate)

But the iif function is returning strings, which won't evaluate properly. Also, when you have multiple conditions, linking them with || or && really only makes sense if they have a single outcome. "If A or B, do X". Where you have two conditions and two outcomes, these really need to be separated.

So, taking the "plain English" version of your conditions:

If post date is greater than 48 hours, turn red OR if camp close date is not empty turn green.

We could just write it like this:

var pastduecolor;

if ($datapoint.firstpostda1 > 48){
    pastduecolor = "red"
} else if (!IsEmpty($datapoint.campclosedate)){
    pastduecolor = "green"
}

Since these conditions aren't linked, the order matters. If the empty close date is more important than the other field, then just put it first.