Hello! I'm looking for some help with using varia...
# ask-questions
d
Hello! I'm looking for some help with using variables for SQL templates when defining metrics. In your documentation, I see the option to use a variable for
valueColumn
or for a date as a filter, but I'm not seeing the option to set a numerical variable. I'm trying to define a metric like subscribers who have aged to X days and would like a metric template defined as date_diff(now, sub created) > X days, where "X" would be defined in the UI form when building a report. Please let me know if this is possible. Thanks!