Beast mode Training

Hi I am a fairly new user of DOMO, I find very difficult to sort out in complex calculation the parentheses in Beast mode

Bearing in mind that I am an advanced user of Excel but never worked with SQL, I wanted to ask what would the best training to understand better Beast mode coding.

I did all the trainings on DOMO.

Thanks

Find more posts tagged with

Comments

GrantSmith

@user000051

Beast modes are really just a smaller subset of SQL commands. You can look up training on different SQL commands or functions online. One resource I like is https://www.sqltutorial.org/sql-functions/ or https://www.sqltutorial.org/sql-case/. You could also look up some online classes like Coursera or Udemity or Khan academy (free!) for SQL to help bolster your SQL prowess.

amehdad

@user000051, posting your questions and approaches to business problems in the Dojo is a great way to verify and refine your beast modes and other features. There are some great minds available here.

jaeW_at_Onyx

user000051

Most SQL and Excel have a 1 to 1 variant. For example the today() function in Excel is the same as the current_date() function in MySQL.

Instead of IF() statements in Excel you'll write a CASE statement in MySQL.

On most days of the week you can just google an abstracted version of your question and end it with "in MySQL"

Example: "how do i calculate the start of last week in MySQL." and then use that in Beast Modes.

P.S. I keep on saying google 'mysql' because most beast mode functions in Domo use the same syntax as MySQL.