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

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.

Answers

  • 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
    GrantSmith Indiana 🔴

    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.

  • @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
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    @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.