How to add traffic light function into table

[nurulizzaty]

Hello experts,

How can i highlight if the date is over 3 days than the current date? Meaning it is overdue. I'm not sure how the formula is.

Eg : If(dimension: incident date) > 3 days after , then red circle is displayed.

Really need your help on this guys pleaseeeee :(((((

@Arthur_Fong help me pleasee 😞

[nurulizzaty]

Anyone help me on this please..... This is urgenttt :(((((((

@

[Arthur_Fong]

Do you have a sample app?

[nurulizzaty]

I don't have the sample app but i can give you example. 

Eg: Dimension : Incident Date

So if the date has passed 3 days, it will turn out red, but if not it will turn green.

I tried this formula but obviously it is wrong. I don't know how to calculate the 3 days overdue..

if(incident_date >='3',lightRed(),lightgreen())