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
0 -
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.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@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.
0 -
@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.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 126 Manage
- 123 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive