Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Summing by groups in beast mode?
I'm running on 2 hours of sleep so I think I am just overthinking this right now but I essentially have a large dataset of event attendance by members Here is a sample of my data: Event Date Event Name Member ID Member is Registered for Event Parent Group Location Type Apr-25 Event 1 1 0 Primary Primary Apr-25 Event 1 2 1…
BeastMode to show an end date that is at least 6 month ago or older
I want to show records where the Program End Date is at least 6 months ago or older — in other words: Include: End Dates before or equal to 6 months ago Exclude: End Dates from 6 months ago up to today Exclude: Future End Dates How can I write this in a Beastmode?
Display warning when saving shared Beast Mode
I like that Beast Mode Manager gives the option to lock a beast mode that is shared to the dataset, but sometimes there are legitimate reasons for non-owners to be able to edit the formula. It would be helpful to simply show a warning to make sure users are aware that changing the beast mode will impact other cards as…
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…
Domo Sandbox: How to create a dashboard (AKA page) repo without creating beast mode copies?
I'd love to start using Domo Sandbox as a dev environment to edit dashboards and then promote when ready. We don't want users to view changes that are in progress! However, I've only gotten dashboard (AKA page) repos to work when they copy literally EVERYTHING on the page — cards and beast modes. My group only wants to…
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…
Add time zone option to inbuilt date/time functions
The Domo functions such as NOW(), CURRENT_TIME(), CURRENT_TIMESTAMP(), CURTIME() all return times in UTC. It would be great if these could all be modified to take additional optional parameter of time zone so that the return values are shifted to the local time appropriate to the given time zone (including daylight savings…
Got a fun one for grouping Columns together. Need help building
This one will take some setup. I have a card by Style and Color, with values of Total AVAIL STK and then broken out by Size columns, and TOTAL WIP and by Size columns. The issue is when we filter to a style, we don't need to see the sizes it doesn't have. If we're viewing a purse, it only needs to show "1SZ" since it would…
How can I write this formula in beast mode?
Hello, I am trying to write this formula from google sheets in Beast Mode DOMO but I can't get to make it work. Does anyone know how to write it correctly in beast mode? Take into consideration that Year and Tons are columns. (SUM(IF(Year = 2025, Tons,0))/(SUM(IF(Year = 2024, Tons,0))))-1 Thanks for your time in advance!
Writing a google sheets formula in DOMO beast mode
Hello, I would like some help writing this formula from google sheets in DOMO Beast Mode or any other option available in DOMO, please. Take into consideration that Year and Tons are columns. (SUM(IF(Year = 2025, Tons,0))/(SUM(IF(Year = 2024, Tons,0))))-1 Thanks in advance, and have a nice day!

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.