Beast Mode

Ask Beast Mode questions and get answers from Domo peers

Recent Discussions

ERROR: This calculation uses both aggregated and non-aggregated columns.
I have been using beast mode fields that used window functions and which validated and worked fine in my charts for years now. However, today when I tried to add a new beast mode I am getting the following error "This calculation uses both aggregated and non-aggregated columns. This may result in duplicate rows and…
what kind of SQL does DOmo use
Hi everyone, does anyone what kind of SQL DOMO uses? standard or mySQL?
beast mode for total active tickets per hour
Hi Everyone, I was hoping to get some assistance on writing a beast mode for getting a table to show total number of tickets per hour. Something like the one below: I have something like this so far- DATE_FORMAT(Date_Entered_UTC, '%Y-%m-%d %H:00:00'), COUNT(TicketNbr) but getting an error when trying to submit it. Any…
How can i achieve the below grouped calculation in a beast mode?
Hello Team, How can i achieve the below calculation in a beast mode. sum(MAX(SUM(`metric1`) OVER (PARTITION BY `Metric2`, `metric3')) OVER (PARTITION BY `Metric2`, `metric3`)) If its not possible in domo beast mode then can you please suggest a way to achieve it in any other feature?
Beast Mode- SQL code to count how many updates in 6 hour intervals
Hello, I'm in need of assistance please of creating a beast mode but can't seem to write it correctly. I have a table named updates with a column time_start that stores the timestamp of each update. the Rows will be the ticket numbers And I want to group the updates by 6-hour intervals, and count how many updates fall into…
beast mode for total active tickets per hour
Hi Everyone, I was hoping to get some assistance on writing a beast mode for getting a table to show total number of tickets per hour. Something like the one below: I have something like this so far- DATE_FORMAT(Date_Entered_UTC, '%Y-%m-%d %H:00:00'), COUNT(TicketNbr) but getting an error when trying to submit it. Any…
WoW Comparison BeastMode
I'm trying to make a card that will show me revenue that has been newly parked (week over week). Our data captures snapshots each week of the data so we can compare if there are changes week to week. This is the BeastMode we thought would work but it's not working properly: Case WHEN (Snapshot Week Rank = 1 and…
Why does my beast mode not work and returns me error "a column in the calculation does not exist'
CASE WHEN Current = 'True' AND group roles LIKE '%Housing%' THEN TRUE ELSE FALSE END I confirm that the above column names are correct and are working otherwise in beast mode.
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam
Beast Mode Case-When Grouping Not Supporting Occurrence Count
Hoping for an assist on this. I have a dataset that includes users along with a log entry for each time they viewed something. I'm trying to create groupings of the number of views to better understand the users. I've had luck with using beast mode case-when in other situations, but for some reason, I'm unable to get it to…

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Other Categories

Product Ideas
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ideas Exchange
Suggest & vote on new features you would like to see implemented in the Domo Product.
Connect
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Connectors
Connectors, Custom Connectors, Writeback
Workbench
Workbench, ODBC Writeback, Plugins
Cloud Amplifier
Ask Cloud Amplifier questions and get answers from Domo peers
Federated
Ask Federated questions and get answers from Domo peers
Transform
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Datasets
Ask DataFusion and Dataset Views questions and get answers from Domo peers
SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Beast Mode
Ask Beast Mode questions and get answers from Domo peers
Visualize
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Charting
Ask Charting questions and get answers from Domo peers
App Studio
Ask App Studio questions and get answers from Domo peers
Variables
Ask Variables questions and get answers from Domo peers
Cards, Dashboards, Stories
Ask Cards, Dashboards, and Stories questions and get answers from Domo peers
Automate
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Apps
Ask Apps and DDX Bricks questions and get answers from Domo peers
APIs & Domo Developer
Ask APIs and Developer.domo.com questions and get answers from Domo peers
Workflows
Ask Workflows questions and get answers from Domo peers
Code Engine
Write, test, and distribute workflow functions with Javascript or Python
AI and Machine Learning
Ask questions about DomoAI and get answers from Domo peers.
AI Chat
Ask questions about using DomoGPT with your data
AI Projects and Models
Ask questions about organizing, managing, training, and accessing your AI models
Jupyter Workspaces
Ask Jupyter Workspaces questions and get answers from Domo peers
Distribute
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Domo Everywhere
Ask Domo Everywhere questions and get answers from Domo peers
Scheduled Reports
Ask Reporting questions and get answers from Domo peers
Software Integrations
Ask add-ons, plugins, and add-in software integration questions from Domo peers.
Manage
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Governance & Security
Ask questions about People, Groups, Roles, Sandbox, Activity log, Buzz, Teams, Approvals and PDP and get best practices from Domo peers
Buzz & Navigation
Ask questions about Buzz and navigation and get best practices from Domo peers
Domo Community Gallery
Watch how our Customers are using Domo to solve their complex problems.
Product Releases
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Domo University
Questions or discussions related to Domo University, trainings and certifications
Community Forums
Getting Started
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Community Announcements
Get the latest from Domo's Community Team.
Social Groups
Archive
Old or outdated content that could still be found helpful.