Beast Mode

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…

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?

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…

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 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…

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…

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.

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…

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…

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…

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,…

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…

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,…

((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

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…

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(),…

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…

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…

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…

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…

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…

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…

I want to see all items on an invoice for the last 2 years that contain a specific item. i.e., I want to see all items on the invoice where at least 1 of the items is item X.

Tired of changing the date filter every time you open a dashboard? Now you can set a default date using variables, so your cards always display the right time frame, automatically. 🔧 How it works: Go to Variables in the Analyzer or Dashboard settings. Create a new variable of type Date. In the Default Value, select…

At the card level it would be beneficial to know what the current operating environment is for a card and leverage that information in a beast mode. For example, if there were a "system variable" that stored what the current "Graph By" selection is, like what is already available in Smart Text, then you could have a beast…

*Thanks to @ajay_p for bringing this topic to the table! 💡* Choosing between a Beast Mode formula or building the logic into Magic ETL depends on the context, how reusable the logic needs to be, and performance considerations. Here's a quick guide to help you decide the best path: 🧠 Beast Mode = quick, dynamic calculations…

I'm trying to create a beast mode calculation that will identify users based on a domain field I have that identifies the domain from the users email in its own column (emaildomain). I have a list of hundreds of email domains that are freemail domains. I've tried to create a Case When statement for when the emaildomain is…

Customer Sales Rep Sales Manager TOTAL Customer PTS Bob a Rudy 100 Bob b Rudy 100 Tina b Rudy 125 Jimmy a Rudy 65 I have a sample dataset above. As you can see, Customer Bob is assigned to 2 Sales Reps & the Total Customer PTS = 100 no matter which Sales Rep it is. Since I'm the manager Rudy, I want to see the Total…

hi All, Want to use the following: CASE WHEN 'Next Cycle Count:' (basically this is a date coming up in the next few months) only want to show the items that appear for next 30 days only