Create a calculated column using beast mode
I would like to calculate the following using beast mode, having the results in a new column.
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.
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board