Making points on a map a third colour that isn't in my data

[bonjourposte]

I have a Bing map I use to mark buildings that need inspection.  This colum comes from SQL- "first inspection" or "second inspection" and the ones that need inspection this year are filtered to show up on the map.  So naturally in the map, when I put "Inspection number" into the "colour" field well, the map generates two colours- red for first inspection and blue for second inspection.  Now the inspectors are asking that I make a third colour- green, let's say.  Green dots will tell the inspectors that despite it being a first or second inspection, the maturity date is coming up and maybe it's not worth it to go see that inspection.  How would I do that?

Thanks, all.

[TheoC]

Hi @bonjourposte 

If I understand correctly, you should be able to add a third category by creating a calculated column and using SWITCH ( TRUE() ) or something similar to create an updated Inspection Status column:

Inspection Status = 

VAR _days = 30 // Adjust this to whatever the logic is you want to use for near maturity days 
VAR _result = 

SWITCH (
    TRUE () ,
        AND ( 
            YourMaturityDateColumn <= TODAY() + _days , YourInspectionColumn = "First Inspection" ) , "Maybe Not Worth It",
        AND ( YourMaturityDateColumn <= TODAY() + _days , YourInspectionColumn = "Second Inspection" ) , "Maybe Not Worth It" ,
    YourInspectionColumn
)

Please make sure to adjust the formula to your table / column name conventions etc. 

Hope this helps!

Theo

[bonjourposte]

Oh my gosh, thank-you so much, but now I feel so bad because I took a different route and just decided to use slicers to show which properties are within the last six-month stretch before maturity.  But now I have a different problem and may come back to this solution tomorrow.  

Thanks again.