-
Two Data Sets, Differently Named Fields - Unable to create paired filter for dashboard cards
Domo community - need a hand on this one. I have two datasets: a) Client records (note: uses client UNID of "SGId") b) Events related to the Clients (note: uses client UNID of "ShowGroupID") Both sets have a common UNID that identifies the clients. One is named SGId and the other ShowGroupID as noted above. For the B data…
-
Add time zone option to inbuilt date/time functions
The Domo functions such as NOW(), CURRENT_TIME(), CURRENT_TIMESTAMP(), CURTIME() all return times in UTC. It would be great if these could all be modified to take additional optional parameter of time zone so that the return values are shifted to the local time appropriate to the given time zone (including daylight savings…
-
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…
-
Beast Mode Case-When Grouping Not Supporting Occurrence Count
Hoping for an assist on this. I have a dataset that includes users along with a log entry for each time they viewed something. I'm trying to create groupings of the number of views to better understand the users. I've had luck with using beast mode case-when in other situations, but for some reason, I'm unable to get it to…
-
Domo Sandbox: How to create a dashboard (AKA page) repo without creating beast mode copies?
I'd love to start using Domo Sandbox as a dev environment to edit dashboards and then promote when ready. We don't want users to view changes that are in progress! However, I've only gotten dashboard (AKA page) repos to work when they copy literally EVERYTHING on the page — cards and beast modes. My group only wants to…
-
Beast Mode- SQL code to count how many updates in 6 hour intervals
Hello, I'm in need of assistance please of creating a beast mode but can't seem to write it correctly. I have a table named updates with a column time_start that stores the timestamp of each update. the Rows will be the ticket numbers And I want to group the updates by 6-hour intervals, and count how many updates fall into…
-
Got a fun one for grouping Columns together. Need help building
This one will take some setup. I have a card by Style and Color, with values of Total AVAIL STK and then broken out by Size columns, and TOTAL WIP and by Size columns. The issue is when we filter to a style, we don't need to see the sizes it doesn't have. If we're viewing a purse, it only needs to show "1SZ" since it would…
-
beast mode to show how many updates every 6 hours
Hi everyone, I was hoping to get some assistance on creating a beast mode please. We have a data set that calculates how many updates a ticket has from when a ticket is open to close. And now we are trying to get a more precise count on when those updates are taking place. We are trying to get a count on how many updates a…
-
How can I write this formula in beast mode?
Hello, I am trying to write this formula from google sheets in Beast Mode DOMO but I can't get to make it work. Does anyone know how to write it correctly in beast mode? Take into consideration that Year and Tons are columns. (SUM(IF(Year = 2025, Tons,0))/(SUM(IF(Year = 2024, Tons,0))))-1 Thanks for your time in advance!
-
Writing a google sheets formula in DOMO beast mode
Hello, I would like some help writing this formula from google sheets in DOMO Beast Mode or any other option available in DOMO, please. Take into consideration that Year and Tons are columns. (SUM(IF(Year = 2025, Tons,0))/(SUM(IF(Year = 2024, Tons,0))))-1 Thanks in advance, and have a nice day!
-
MTD and YTD TOGGLE
HI Team, I have a date field and what I'm trying to do is write a beastmode that looks at YTD and MTD without years. I have successfully done that in 2 separate beastmodes to give my a 'Y' or 'N' toggle. However when I try to combine them into one where the user can toggle 'YTD' or 'MTD' the 'MTD' isn't the issue.. it's my…
-
Replicating multiple Excel Calculations as rows of data - Beast Mode?
Hello, I've got multiple datasets (actually customers) that we calculate a few things with separately. I was able to get all of the datasets (customers) combined so they could all be on one table: Typically what I do in excel is from those numbers I'll pull a few different things out: I'd like to basically mimic these…
-
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…
-
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?
-
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…
-
Dynamic Positional Inventory
Hi, I am looking to create a pivot table that is able to handle positional inventory dynamically. For example, if I have 3 weeks in my filtered range, I want to only show the data on the last week. I am using the below. CASE WHEN Week ending date = MAX(Week ending date) OVER () THEN SUM(ifnull(EOH Qty,0)) ELSE 0 END This…
-
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)…
-
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…
-
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…