Create a calculated column using beast mode
Aloha:
I would like to calculate the following using beast mode, having the results in a new column.
Example:
column name: Start Date "9/1/2019"
column name: Days Ago "2"
If column "days ago" has a number in it, then take the date in the "start date" column and subtract it from the number in column "days ago"; resulting in the new "activity date".
If column "days ago" is null (has no data), the result is: "start date"
New column is: Activity Date
Any assistance is greatly appreciated.
Best Answer
-
Another option (assuming it will be either a number or null) is to utilize COALESCE or IFNULL function:
DATE_SUB(`Start Date`, interval COALESCE(`Days Ago`, 0) day)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
You could do this a couple different ways, but here is one for you:
CASE WHEN 'Days Ago' >= 1 THEN DATE_SUB('Start Date', interval 'Days Ago' day) ELSE 'Start Date' END
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Another option (assuming it will be either a number or null) is to utilize COALESCE or IFNULL function:
DATE_SUB(`Start Date`, interval COALESCE(`Days Ago`, 0) day)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hello @Hulachic5 & @MarkSnodgrass ,
I love the work you've done with Beast Modes. I'm happy to let you know we have just released Code Block apps in our Domo Appstore. These allow customers and Domo experts such as yourself, to publish code blocks like the ones you've created for distribution in the Appstore. The publish process for the code blocks is currently in an early beta. If you are interested in publishing your code blocks, let me know and we can enable it for you.Cheers,
Cody SmithDirector of Product, Domo
2 -
Thanks a million. It truly made a difference.
Have an AWESOME Day!.
SPM
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive