I have a condition that is set to Next n Days on a date/time field with the value of n being 1.
I have a manual filter on a table using this model that has a manual source of Activate and Set Value, and the number 7 for the value. This is returning no rows.
The filter works if I only activate it, and not set the value too. My goal is to have a dropdown filter where the user can select 7, 14, 30, and 60 days from the filter list and it inject those days for the “n” value in the condition.