Dynamic Target Based on Current Date

user02769

Hello all,

I am currently utilizing a gauge card with a target metric. What I would like to do is have the target be dynamic based on a date. For example, we have a different target for each quarter in our fiscal calendar. Depending on which quarter we are currently in, I would like the target to reflect the correct data.

I tried a beastmode for my target that went something like

(CASE

when CURDATE(between 01-01-2022 and 03-01-2022) then 98

when CURDATE(between 03-02-2022 and 05-30-2022) then 98.5

end)

but I'm getting a syntax error. Any help would be appreciated!

MarkSnodgrass

Your beast mode syntax should look something like this:

(CASE WHEN CURRENT_DATE() >= '1/1/2022' AND CURRENT_DATE() <= '3/1/2022' THEN 98
 WHEN CURRENT_DATE() >= '3/2/2022' AND CURRENT_DATE() <= '5/30/2022' THEN 98.5
 END
)

You might also consider adding an ELSE clause to handle when the current date doesn't match any of the WHEN clauses.

MarkSnodgrass

Your beast mode syntax should look something like this:

(CASE WHEN CURRENT_DATE() >= '1/1/2022' AND CURRENT_DATE() <= '3/1/2022' THEN 98
 WHEN CURRENT_DATE() >= '3/2/2022' AND CURRENT_DATE() <= '5/30/2022' THEN 98.5
 END
)

You might also consider adding an ELSE clause to handle when the current date doesn't match any of the WHEN clauses.

user02769

Thank you!! So helpful!