Adding comments in Beastmode calculations

This is a stupid question... but how do I write comments in Beast Mode calculations?

Best Answers

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓
    -- 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!**
  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷
    Answer ✓

    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 to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.