Beast mode Training

user000051
user000051 Member
in Magic ETL

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 Coach

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    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.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories