How to use a user selected date parameter in a calculated field?

Theodore_Mwangi

Hi,

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'

ELSE NULL

END

I'd wish to do this in the Chart section in DOMO.

ST_Superman

Unfortunately, I am not aware of any way to allow user defined variables in the Domo product. You may need to create a custom app to accomplish what you're looking for

GrantSmith

Hi @Theodore_Mwangi

They way Domo does "dynamic variables" is essentially to use a webform to allow the user to change the value and then trigger a DataFlow to reprocess the data for the visualization. There isn't a friendly way of doing this through the UI directly sadly.

Theodore_Mwangi

@ST_-Superman-_ Thanks for the quick feedback.

@GrantSmith Thanks for the suggestion. However, I don't think the webform will work for my current use case since i am building a user interactive dashboard where they can select the date range which is later on used to calculate values for a column in the dashboard.

jaeW_at_Onyx

@Theodore_Mwangi , @GrantSmith 's method will work. I wouldn't do it in Magic though, I'd probably use a Webform JOINED to the FACT table ON a constant 1 = 1 in a Fusion or DatasetView, this way you don't have to wait for the ETL to reprocess.

But this is the only solution until the Dynamic Variable beta goes live OR unless you build a custom app. Good luck.