-
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…
-
All Items on an Invoice that contain a specific Item Number
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.
-
💡 Tip of the Week #15: Show the data you want by default
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…
-
Smart Text as a Variable
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…
-
🚀 Tip of the Week #12 – Beast Mode vs Magic ETL: Choose Smart, Work Smart 💡
*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…
-
Creating BeastMode to Identify Freemail Users Using LARGE list of Freemail Domains
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…
-
SUM(DISTINCT) based on another column
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…
-
only show data for next 30 days
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
-
Use loops to avoid rewriting case statements within a beast mode many times
I find myself writing bucketing beast modes that are very manual, tedious, and often not accurate. I was wondering if there's a way to accomplish something like this using a variable or something so I: 1) Wouldn't need to retype the same thing over and over 2) Could modify my bucket size all at once Here's an example:
-
Show value on row option
Please add an option to show value on row for pivot tables. I've seen a couple other posts about this but I'm not sure if this will become a feature. I don't think construction yet another dataset is the right way to deal with this. It is standard functionality in Excel and PowerBI.
-
SQL/Beastmode query for copying in values from another column
Hello, I have a dataset with lead sources from two different places, and I need to splice in the lead source from another column into the main column (Source - Mapped) only when criteria is met. I don't want to fully replace the data in the 'Source - Mapped' column because it has values that are not present in other…
-
How to dynamically return the latest value for a filtered date range
I have a card for Top 20 Selling Styles that includes Sales, Units Sold, and Quantity On Hand. It is powered by Sales and Inventory datasets that are updated weekly with a date tied to each week. The person I am building this card for will be utilizing a date filter to change the card to the time period they want to see.…
-
Hi I had question about a basic beast mode calculation that is not behaving correctly
My beast mode calculation is here which is delivered margin define / qtymarketingforecast : Here are the result but as you can see if you divide the delivered margin $ from qty marketing forecast you end up with a different value then you are supposed to: Not sure what is causing the results to be off since the beast mode…
-
SQL Fluff - SQL TILE / Beast Modes
It would be great if we could integrate SQL fluff into beast modes and the sql tile in Domo or have a format button with in those options as users can copy and past code it can cause readability issues. https://github.com/sqlfluff/sqlfluff
-
CURRENT_DATE reflective of instance time zone
Requesting CURRENT_DATE function in beastmode to be reflective of our company time zone instead of UTC. At 6pm daily (Central Time), our reporting is off as the UTC current date shifts to the next day. We were originally told this was a bug but after four months waiting for the fix, Support has come back saying this is…
-
When using a multi-select filter, can this be used as "AND" logic instead of "OR" logic?
I am using a dropdown selector filter in Domo that I have set to allow multiple selections. My goal is to set it so that when 2+ values are selected, the card below it on my dashboard will only bring back rows that meet ALL of the selected values. For example, if I select "1 Normal Remodel" and "3 Kitchen", the only jobs…
-
Aggregated and Non Aggregated - Index Calculation
Hello! I am attempting to create an index out of two beast modes. One is an aggregated measure that returns the percent share of impressions against the total group. The second is a count of assets to capture how many social videos have been published per each social platform. For example, I'll have two columns for TikTok…
-
More Efficient YoY Actual to Budget View
Hi Domo Sapiens, Currently, we have a year over year graph that has current year budget also in the series: The bar graphs are each year's actual values, and the line is the current year's budget value. I hard-coded each series with a beastmode, as such: CASE WHEN YEAR(Date) = '2025' AND Actual or Budget = 'Actual' THEN…
-
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?
-
How can I set up a text box Variable that can search for a text string in a field?
Hi Domo Community, Like the title says, I'd like to set up a Variable to be used in a dashboard where users can input text and it will search for the text string in related reports and return the results. For example, I have a "Description" field for items. I'd like to search "6mm bolt" in the Variable/text box and have it…