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