Dashboard Constraint
Hello,
I'm trying to constrain a dashboard prompt by a date selector, however the field I'm trying to constrain is displaying SQL results, meaning the 'Constrain' button doesn't display.
I have added default values to the constrain, however we'd like it to be dynamic based off of the first date field with the condition between.
Is this achievable within SQL results?
To confirm, first field is a date field with the condition between
Second field (The one we want to constrain) is a text field but is displaying SQL results
The reason we're using SQL results is because we're getting the word before the first '#'