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

Comments

  • GrantSmith
    GrantSmith Indiana 🔴

    @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.

  • @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
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    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.