Is there any method to define a static variable within a dashboard query.
As part of this use case, I also need to lookup a userid on a data table and get the corresponding Password policy days to be used in a calculation. for example
$PassDays = if (graph.entity.user.userid in %Password_Policy.USER then %Password.Policy.DAYS, 90)
math.round(( (graph.entity.user.last_password_change_time.seconds + ($PassDays * 86400))- timestamp.current_seconds() )/86400) < 30
