Beast Mode

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…
Cumulative Sum for the Year on a table card
I want to create a table card that has a line for each month-year for all sales and show total $ for the month, a running total of $ for the year (up to that point), total quantity sold for the month, and a running total of quantity sold for the year (up to that point). Example: Month-Year | Monthly $| Running $ | Monthly…
AVG() Beastmode Handling 0s?
Hi All, If have a dataset with duplicate IDs (required) and a metric - let's call it "total apples" against each ID (so also duplicated) The goal is to get the average of this meric but only considering the trend of distinct IDs overtime. I've labelled each distinct ID (using row_number over create date partition by id)…
MTD and MTD Last Year, leap year problem
I want to show sales MTD and MTD Last Year as of Feb 28, 2025 so I created Beast Mode: MTD = CASE WHEN CURRENT_DATE >= SHIP_DATE and CURRENT_DATE <= LASTDAY(SHIP_DATE) THEN 'sales_amount' ELSE 0 END MTD Last Year = CASE WHEN DATE_ADD(CURRENT_DATE, INTERVAL -1 YEAR) >= SHIP_DATE AND DATE_ADD(CURRENT_DATE, INTERVAL -1 YEAR)…
Calculating YTD for each week in table
Hi, I want to replicate a table that looks like this: My dataset currently has date, impressions, and goal, and in ETL I've mapped the dates to a week by joining with another table. How would I use beast mode to find the impressions to date for each week, as well as the delivery percentage of goal?
Customizable Average Calculation
I have a graph that calculates the hours of different job types. Since DOMO has a label feature for %_PERCENT_OF_CATEGORY, it would be helpful if DOMO could add in the grid line settings an option to allow users to choose different options for calculating the average. In this example we are calculating the average value in…
beast mode using window function as a filter
Hello, I have a beast mode that's very important to calculate the summary number correctly. I can't find any alternative to this. However, it is using a window function and I'm wondering why it won't appear if I tried to add it as a filter in the card or dashboard. I can add it in the quick filters pane of the card, but…
Combining Filtered Rows to one table
Hello, I am using one dataset for all three cards shown below. I have them on separate cards right now as they each are filtered to different things. Is there a way I can combine them so they would all show on one card/table together with one heading but show the three rows one under another with their filters still…
Setting up a rolling sum based on date
Hello, We are trying to set up a beast mode or ETL Formula that will be able to calculate a rolling average of leads based on the last 30 days and the last 90 days. Ideally we would want to be able to compare the average number of leads for the last 30 days to their rolling 90 day average to see if the client's lead…
Filter Line without Column Turning Blank
Hi All, I'm using a calculation with a variable (see below) to select designed time periods and need to remove my revenue line (Hierarchy = Revenue) however, when I add filter "Hierarchy Not In 'REVENUE'" the column using the below formula returns BLANK for every row in that column but does not cause any of the other…
Apply a % Model based on an identifying field
Hi All I've got a challenge when trying to apply a sum(max()) value to my card as there is a variable I can't identify correctly In my data (anonymized) I have the following columns I need to use for this: [Customer], [Model Type], [Model %], [Master Description], [Sub Description] What I need to do is, when a [Customer]…
MTD & MTD Last Year Beastmode that calculate the ratio
so I have a beast mode that calculates the ratio of committed orders % committed count = SUM(CASE WHEN % complete > 0 THEN 1 ELSE 0 END) / COUNT(Order #) but I want to create a Beast Mode to calculate the same ratio but just for this MTD, so I tried this, but it return 0 CASE WHEN YEAR(CURDATE()) = YEAR(MONTH_END_DATE) AND…
HTML Beast Mode help
Is there a way to add a colored line below a number value on a card? or even a "line break" colored line? I am trying to use beast mode/html to create a blue line to add below the SUM value of the card. I am currently using a single value card with: 'CONCAT( SUM(Actual_Count), ' <hr style="border: 3px solid #30B0E0; width:…
How to Filter for "Today AND Last 7 Days" in Domo Visualizer?
Hi everyone, I’m trying to implement a date range in Domo (using `Reservation Start Date`) that includes both Today AND the Last 7 Days at the same time. This will be for a weekly scheduled send. I know Domo has built-in filters for "Last 7 Days" and "Today," but I can't find a way to combine them in a single filter within…
Beastmode to flag an item if the date is longer than a week from the current date.
Hello, I am trying to write a beastmode to 'FLAG' and item if the submission date is longer than a week from the current date. How would I proceed? See below for my current beastmode that flags something if it does not fall into the current week of the current date. My thought process is if the date is longer than the…
Using Average on Beast Mode
I want to calculate the average number of semesters that students with bachelor's degrees have completed. Below is my Beast Mode calculation. However, it currently counts all semesters (or terms) a student has attended, even if they pursued additional degrees after earning their bachelor's. I only want to count the…
Running Into Error with BeastMode and Table
I'm working on a beastmode where I am trying to assign a label to individual orders based on their price_tier and their Product Name. If an order's price_tier is equal to the MAX of the price_tier for a Product Name, I want it labeled "Sold". If an order's price tier is less than the max, I want it labeled "Discount". And…
How can I utilize double case statements in a beastmode
I want to create a beastmode where it calculates something like the below: when segment = A then calculate the amount moved from A to B when segment = B then calculate the amount moved from B to A (image below) How can I calculate this using the beastmode functions?
Datasets API - Get Metadata - RequestedParts
The documentation for the dataset-get-metadata endpoint here indicates that the "requestedParts" parameter can be used to specify which parts of the metadata are needed in the response. However, the documentation does not indicate list of accepted values. The sample request below also indicates a different param named…
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?
Beast mode - no aggregation
Hi Everyone, I created a pivot table that will show the cost of dispatches. Please see below: one of the values that we are using is called Number of Ports ( blue Value that says COUNT of Nu. ) and for some reason the number does not populate any data even though on our tickets it shows a number. And maybe because that's…
Seeking Best Practice Advice: Reporting Financials in Domo
Hi community, What is best practice for reporting financials in Domo? Currently, we have raw financials, account by account, fed in through a simple CSV. There are no summaries in this CSV, so I have to aggregate them with Beastmodes to get to summary numbers. For example, EBITDA is calculated as such (see code below) This…
Running Total Beast Mode with Fixed Functionality
I’m working on a running total Beast Mode that tracks ticket sales by event. My current formula works fine: SUM(SUM(tickets sold)) OVER (PARTITION BY EVENT ORDER BY DATE ASC) However, these events reoccur yearly, and I want to compare ticket sales pacing to previous years while maintaining drill-down and filtering…
Partition in Beastmode or Possible Another Solution
Hi, I have a dataset that joins spends from our Facebook account by date with leads that came in that day. Since we have multiple leads per day the "Facebook Spend By Day" will be in the data set multiple times. In a beast mode I want to get a look at the total Facebook spend all time. I am using this right now:…
Beast Mode: Why am I not getting the correct number of enrollments per academic year?
I created a Beast Mode calculation to extract the academic year based on term codes. For example, to derive the academic year 1955-1956, I identified these three term codes: 1555, 1561, and 1563. 1555 is Fall 1955. The 2 digits in between are the year. (The last digit ‘5’ represents Fall). 1561 is Winter 1956. (The last…
Multi-value Columns Gauge Card | Compare between Current Headcount vs. Dynamic Historical Month
I have a situation where I am trying to show how the Headcount moved by comparing Current Month Headcount with any of the historical Month which the user will select. The problem that I am facing is that when any period gets selected Current Month Headcount calculation becomes Zero. My dataset is very complex and massive…
CurDate Beast Mode Showing Tomorrow's Date
Is there a way that I can ensure the curdate function always uses EST time zome to return the correct date? For instance, at 8:50 pm, the cur date function is displaying 2/4 when I want it to display 2/3.
Custom Formula Default Selections for Slicer/Filter Cards
Currently, Domo’s slicer/filter cards require manual selection of default values, which can be limiting for use cases where the default selection should change dynamically based on the current date or other conditions. I propose the ability to set dynamic default values for slicers using conditional logic. For example,…
Need help with specific code that is not working in either beast mode or magic etl formula tile
Hi the following code I am using as a filter on my card and have it set to "on list" its called skus to be purged "CASE WHEN On Order = 0 AND (Future Demand = '' OR Future Demand IS NULL) AND (Future Books = '' OR Future Books IS NULL) AND (Reserved + WMAVAIL <= 10 AND WMAVAIL > 0) AND WAREHOUSE_CODE = 11 THEN 'On List'…

Beast Mode

Discussion List