Beast mode Training

user000051 · May 2020

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

GrantSmith · May 2020

@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 · September 2021

@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 · September 2021

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.

Magic ETL

Magic ETL

Beast mode Training

Welcome!

Comments

Welcome!

Welcome!

Quick Links

Categories