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