Adding comments in Beastmode calculations

NathanDorsch
Member
in Charting
This is a stupid question... but how do I write comments in Beast Mode calculations?
0
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InBest Answers
-
- -- This is a comment
- SUM(`Column`)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Amazingly fast answer by @GrantSmith :)
Beast modes also accept /* */ as comment blocks, such as this:
- /* check to see if the shift is in
- the same day */
- (CASE WHEN DATE(`startdate`) = DATE(`enddate`) THEN
- /* same day*/
- /* check to see if the start hour is too early */
- (CASE WHEN HOUR(`startdate`)< 9 THEN
- /*move the start date to 9 */
- ADDTIME(DATE(`startdate`),9*60*60)
- /* check to see if the start hour is too late */
- WHEN HOUR(`startdate`)>17 THEN
- /*move it to the next day and start at 9 */
- ADDTIME(ADDDATE(DATE(`startdate`), interval 1 day),9*60*60)
- ELSE TIMEDIFF(`enddate`,`startdate`)
- END
- )
- ELSE
- /* spans multiple days */
- TIMEDIFF(`enddate`,`startdate`)
- END
- )
This is useful if you have a multi-line comment you want to write.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
- -- This is a comment
- SUM(`Column`)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Amazingly fast answer by @GrantSmith :)
Beast modes also accept /* */ as comment blocks, such as this:
- /* check to see if the shift is in
- the same day */
- (CASE WHEN DATE(`startdate`) = DATE(`enddate`) THEN
- /* same day*/
- /* check to see if the start hour is too early */
- (CASE WHEN HOUR(`startdate`)< 9 THEN
- /*move the start date to 9 */
- ADDTIME(DATE(`startdate`),9*60*60)
- /* check to see if the start hour is too late */
- WHEN HOUR(`startdate`)>17 THEN
- /*move it to the next day and start at 9 */
- ADDTIME(ADDDATE(DATE(`startdate`), interval 1 day),9*60*60)
- ELSE TIMEDIFF(`enddate`,`startdate`)
- END
- )
- ELSE
- /* spans multiple days */
- TIMEDIFF(`enddate`,`startdate`)
- END
- )
This is useful if you have a multi-line comment you want to write.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
It also formats lines beginning with # as if they are comments, but does not actually treat them as such.
0
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InWelcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InCategories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 83 App Studio
- 46 Variables
- 777 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive