brycec Domo Employee

Comments

  • Have you looked into using variables to achieve this? https://www.domo.com/learn/video/variables-use-case-feature-walkthrough
    in Beast mode that looks at filters? Comment by brycec June 2023
  • To those reading this thread years later: When I looked into this, it is because the version of MySQL that Domo is running does not support WITH. You can check the version by running this command: SELECT VERSION(). That command outputs 5.6.37-82.2-82.2, however WITH and Common Table Expressions weren't added to MySQL until…
    in Do MySQL dataflows support the use of the WITH clause? Comment by brycec February 2022
Avatar