Beast Mode

Issue with CASE WHEN statements -
Hi, I keep getting a syntax error notification for my beast mode, but cannot figure out why. Could someone tell me what I am doing wrong? I am trying to write a forumla to obtain the count of all records where column_a = value_1 . Can you tell me where my syntax error is? COUNT(CASE WHEN column_a = 'value_1' THEN 1 ELSE…
Keyword filtering on all columns..it just works
Hi all, just sharing a solution I worked through a couple of weeks ago that was intended to allow the user to filter on a keyword or partial word as a dynamic filter on any or even all columns in a dataset. You will need the following: Free Text Variable – This is what the customer will interact with Coalesce() – Returns…
Search for keyword (from text input variable) in a phrase
Hi all, I am trying to find a way in Beast mode in which a user can input a text(keyword) in a box and then the formula would search the phrase to see if that keyword exists. The problem I run into is that I need to add '% and %' respectively to a custom variable as part of LIKE. Can something like CHAR(37)& custom…
Paired coloured brackets in formulas
Would it be possible to implement paired coloured brackets into beast modes and Magic ETL formulas (a la Excel)? This would make it far easier to work with large and complex beast modes, especially with only single-level nesting currently available.
Calculating A Total Time Based Off Multiple Values
I may be overthinking this but hopefully someone has a suggestion. I have a dataset where I need to take the total time of two tasks, only if they are part of the same ID and completed by the same Name. (ID is based off of an overall order where the task is one task within that order.) Screenshot below shows that I would…
Beast Mode Data Type filtering and reporting
Could the Data Type of beast modes be added to the Domostats report and also added as a filter property in the Beast Mode manager?
How to get YOY NRF Comp date data next to Filtered date
Shopify Created/FC Order Entered Date NRF Order Enter LY Date TY Units Booked(Order Entered) LY Units Booked(DesiredOutcome) 11/7/2025 11/8/2024 966 1,200 11/6/2025 11/7/2024 1,295 1,201 11/5/2025 11/6/2024 1,154 1,202 11/4/2025 11/5/2024 1,130 1,203 11/3/2025 11/4/2024 1,479 1,204 11/2/2025 11/3/2024 2,475 1,205 11/1/2025…
Can you change the number type using variables?
I want to change the number type when using variables (switching from currency to percentage to numeric) depending on the selection. Is this possible? If so, how?
The Comparative Gauge chart is showing the % change incorrectly
The Comparative Gauge chart is showing the % change incorrectly in my card. I set the Previous Value to 6-week Average Sales and the Current Value to Last Week Average Sales. Both Beast Modes work correctly on their own, but the Comparative Gauge is displaying the wrong percentage. For example, last week’s sales were…
Visualizing a Case Statement into a Table
Hello, I have a beast mode that utilizes a case statement that groups all results that have 'Unknown' in the name to be mapped to 'Unknown' else it'll show 'Known' I am trying to figure out how I can represent each count and % of Unknown and Known by US state within a table. Ideally there will be 4 columns: 1 column to…
Variables Don't Have Filter Settings
I want my variables to only affect certain cards. The Filter settings are available for normal filters and on the cards themselves, so this doesn't seem like a heavy development lift.
NUMBER_FORMAT function
Please consider the implementation of a NUMBER_FORMAT function in Beast Mode in the same vein that we have DATE_FORMAT and TIME_FORMAT. This would take a number, and based on parameters, format the number (add thousand separator commas, percent sign, currency sign). Numerous discussions have been had in the forums about…
Color Rules for Gauge
Request to add color rules for data points calculated using Beast Mode as opposed to data included in the chart for the Filled Gauge chart. In an effort to create a dynamic color rule for the Filled Gauge chart, I created color rules that correspond to a Beast Mode ratio of new users / day. However, the Gauge Values need…
Global Column Rename
Idea: I’d love to see a feature in Domo that allows us to rename dataset columns once, and have those changes automatically reflected everywhere that column is referenced (cards, drill paths, ETLs, beast modes, etc.). Problem Today: When we want to rename a column (for example, changing “Parent Account” to “Parent…
Adding Calculated Total Rows in a Pivot Table?
My sample dataset: Pivot table using Region Code Name & Account as Rows, MTD as Value will show just like the picture above. However, I want to add calculated total rows, so that my pivot table would show like this: individual Region Code then the Total for each Account as each row. Is there away to do that with Beastmode,…
Incorrect total when the field used is a beast mode using a case statement
I have the below beast mode that is created using fields that are all fixed by their various dimensions. `Expected Cost` CASE WHEN SUM(Revised Estimate (fixed by Estimate)) = 0 AND SUM(Cost to Date (fixed by GL)) <> 0 THEN SUM(Cost to Date (fixed by GL)) WHEN SUM(Cost to Date (fixed by GL)) > SUM(Revised Estimate (fixed by…
Beast Mode Folders
Hi, It's been more than a year since this post (https://community-forums.domo.com/main/discussion/66358/navigation-q-a-from-domopalooza?utm_source=community-search&utm_medium=organic-search&utm_term=beast+mode+folder ), I'd like to check if the folder functionality for beasts mode has been implemented. At my organisation,…
beast mode below works but is erratic
((SUM(CASE WHEN Disconnects IS NULL THEN 0 ELSE Disconnects END)) / (SUM(SUM(CASE WHEN ServiceStatusValue IS NULL THEN 0 ELSE ServiceStatusValue END)) OVER (ORDER BY BillingPeriod) + SUM(CASE WHEN Unique Count ServiceID IS NULL THEN 0 ELSE Unique Count ServiceID END))) * -1
Rank function in Beast Mode
I have earlier applied the dense rank window function in beast mode as below and it worked. Now I am trying to apply the same logic against another dataset for my dashboard, it says syntax error and throws the below error "This calculation uses both aggregated and non-aggregated columns. This may result in duplicate rows…
Displaying `% Change` based on `Date` Beast Modes (Prev Month YoY and Last 2 Months MoM)
Hi everyone, I've created two beast modes based upon Date: Previous Month YoY: CASE WHEN ( YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) ) OR ( YEAR(Date) = YEAR(DATE_SUB(CURDATE(), INTERVAL 13 MONTH)) AND MONTH(Date) = MONTH(DATE_SUB(CURDATE(),…
💡 Tip of the Week: Mastering FIXED Functions in Beast Mode
Beast Mode’s FIXED functions give you precise control over how your metrics are calculated, regardless of how users filter or group the data on a card. They're especially useful when you need your KPIs to remain stable and consistent across different contexts. 📌 Here you have some examples of Fixed Functions: ✅ FIXED…
FIXED Function with filter on card
Hi All I'm sure this has been asked a few times but I couldn't find a specific answer that helped with my challenge I have a PIVOT Table which contains all of my financial data rows consisting of Costs and Revenues I want to calculate a share of revenue for each cost whilst having a filter on my card to remove the Revenue…
Beast mode to select all the slicers
I have a column that populates the below 7 options, I would want to have another option 'All' which displays numbers of all 7 cases instead of manually selecting all 7. I am trying to write a below beast mode for the same but the 'All' option would not include all of the cases. case when combination = 'desktop' then…
Beast Mode: build “hotel stay duration” from Timestamps
Hi all, I need to calculate the time between two Timestamp fields in Analyzer: Hotel Arrival Date Hotel Departure Date Goal A numeric duration in hours (decimal) A readable HH:MM string for tables Optional: integer minutes Example Arrival = 2025-08-28 22:10:00 Departure = 2025-08-30 00:20:00 Expected: Hours ≈ 26.17, HH:MM…
Is it possible to create case when for ALL?
I have a column 'channel_id' with 5 id from 1 to 5. I want to create a case when: CASE WHEN channel_id = 1 THEN 'Facebook' WHEN channel_id = 2 THEN 'Instagram' WHEN channel_id = 3 THEN 'Tiktok' WHEN channel_id NOT IN (1, 2, 3) THEN 'Others' WHEN channel_id IN (1, 2, 3, 4, 5) THEN 'All' END So that I can have this column as…
Beast Mode: build “expiration at end of next day” from a Timestamp
Hi all, I have a Timestamp column named Voucher Create Date and I need to convert it to 11:59 PM (end of day) the next day. This will be named Expiration Date E.x. If Voucher Create Date is 8/27/25 2:00:00 PM then this column should give me 8/28/25 11:59:59 PM How can I do this via Beast Mode? These did not work/gave a…

Beast Mode

Discussion List