-
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…
-
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…
-
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…
-
beast mode for total active tickets per hour
Hi Everyone, I was hoping to get some assistance on writing a beast mode for getting a table to show total number of tickets per hour. Something like the one below: I have something like this so far- DATE_FORMAT(Date_Entered_UTC, '%Y-%m-%d %H:00:00'), COUNT(TicketNbr) but getting an error when trying to submit it. Any…
-
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…
-
How can i achieve the below grouped calculation in a beast mode?
Hello Team, How can i achieve the below calculation in a beast mode. sum(MAX(SUM(`metric1`) OVER (PARTITION BY `Metric2`, `metric3')) OVER (PARTITION BY `Metric2`, `metric3`)) If its not possible in domo beast mode then can you please suggest a way to achieve it in any other feature?
-
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…
-
Sum True
This sounds so dumb and simple. But I'd give my left leg to be able to sum a true/false column and have it give me a sum of True (basically treating it like a 1 and 0) without having to do a beastmode calculation.
-
Multi-Column Value Chart not showing values
Hi I've created 2 case statements to look at current and previous month using an integer rank column created in the ETL based on the Year and Month (202505 = 1 and 202504 =2) When I look at the output data set, these numbers are formatted as an integer as expected and when I create case statements that reference these…
-
Why does my beast mode not work and returns me error "a column in the calculation does not exist'
CASE WHEN Current = 'True' AND group roles LIKE '%Housing%' THEN TRUE ELSE FALSE END I confirm that the above column names are correct and are working otherwise in beast mode.
-
Date_Format Fiscal week number and Year
Hi All, I am using the Graph by capability in DOMO Visualize and I want to get a filter to display WEEK 24 -2020 , WEEK 25- 2020 ......WEEK 17 -2022 in descending order I tried this DATE_FORMAT(`SHIP_DATE`,'%Y-%w') ....But its not correct..Can you please let me know how to go about this.. Thanks, ozarkram
-
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam
-
Summing by groups in beast mode?
I'm running on 2 hours of sleep so I think I am just overthinking this right now but I essentially have a large dataset of event attendance by members Here is a sample of my data: Event Date Event Name Member ID Member is Registered for Event Parent Group Location Type Apr-25 Event 1 1 0 Primary Primary Apr-25 Event 1 2 1…
-
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…
-
BeastMode to show an end date that is at least 6 month ago or older
I want to show records where the Program End Date is at least 6 months ago or older — in other words: Include: End Dates before or equal to 6 months ago Exclude: End Dates from 6 months ago up to today Exclude: Future End Dates How can I write this in a Beastmode?
-
Display warning when saving shared Beast Mode
I like that Beast Mode Manager gives the option to lock a beast mode that is shared to the dataset, but sometimes there are legitimate reasons for non-owners to be able to edit the formula. It would be helpful to simply show a warning to make sure users are aware that changing the beast mode will impact other cards as…
-
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…
-
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…
-
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?