How to use a user selected date parameter in a calculated field?
I would like to include a dynamic user selected date parameter in a calculated field. Where the user selects a Start (selected_start_date) and End (selected_end_date) from a date filter then depending on what date ranges are chosen run the following sample calculation:
IF user_sign_up_date <= selected_end_date THEN 'Active'
ELSEIF user_sign_up_date >selected_end_date THEN 'Inactive'
I'd wish to do this in the Chart section in DOMO.