Hi,
I saw on the documentation that there is an option to assign constant values to variable with “constant”.
In the documentation only a string was inserted as a value.
can I use the same method to assign other types of variables? like number (of mathematical operations) or lists to it?
for example:
I want to check if a given name is a friend of someone in my list.
constant: my_list {
value: “Oren”, “Dan”, “Nicole”
}
and than use it like this:
dimension : name {
type: string
SQL: ${TABLE}.name
}
dimension: friends {
type: yesno
SQL: case when ${name} in @my_list then yes end;;
}