Ask Beast Mode questions and get answers from Domo peers
Hi! I am trying to fix this beast mode calculation to group properly. I need the time to group 12am-6am and then show 7am-7pm as separate lines and then group 8pm-11:59pm. The opened date column i am using is in this format '2023-10-22T07:18:17' which is why I am trying to use the beast mode, but the grouping doesn't seem…
I have read several varying degrees of opinions on when a Beast Mode is actually calculated. I thought a Beast Mode, attached to a card or assigned to a dataset, is calculated at the objects rendering, regardless of if the Beast Mode is actually being displayed on said card. So if I have 20 total Beast Modes, some only…
Hi there, My team wants to create a beast mode that looks at total views in the first 30 days per asset since the video was published. For example, a video was published on March 1, 2024 and we want to know how many total views did it generate through March 30, 2024. We created a couple of sample beast modes that are…
CASE WHEN SUM(Total Weight/Units Received) > SUM(Weight (MIN)) AND SUM(Total Weight/Units Received) < (Weight (MAX)) THEN '1' WHEN SUM(Total Weight/Units Received) <= SUM(Weight (MIN)) THEN SUM(Total Weight/Units Received / Weight (MIN)) WHEN SUM(Total Weight/Units Received) >= SUM(Weight (MAX)) THEN SUM(Total Weight/Units…
I was trying this beastmode formula, and it is giving NULL value for the latest date but when i am putting this formula as filter and selecting this option "Not in" the data shows like "No Data in Filtered Range" CASE WHEN Date = MAX(Date) OVER () THEN 'NULL' ELSE Date END
I used Rank & Window ETL to Rank Districts 1-46 based on a performance value. I need to use the "Colors" feature in Analyzer to color code rows based on a "Tier" I created in a Beast Mode, which is calculated based on percentile. The Beast Mode is as follows: In the preview, this works. Ranks 1-11 are D, 12-23 are C, etc.…
Hi all, I have a beast mode calculation created which I'm trying to find out the monthly average of open tickets between 5 boards for the past 15 months and this is what I have- SUM(COUNT(TicketNbr)) OVER (PARTITION BY Board_Name ORDER BY last_update)/ DAYOFMONTH( last_update ) But I think the calculations are off. Is…
Hello, I am trying to group values into ranges in DOMO, but can't seem to get my beast mode to work. Am I doing something wrong? I am trying 2 different methods: 1. case WHEN `Sale Liability` >= 50000000 AND <= 100000000 then '$50M-$100M' WHEN `Sale Liability` >= 100000000 AND <= 250000000 then '$100M-$250M' when `Sale…
I have a single value card and I'm using the following code to format the dollar value as I concatenate several values into one text value for the card to display. Do you know if there's a way to have the font color display red if the value is negative? Here's a snippet of the code: CONCAT( '$', CASE WHEN…
Is there a way to create a column that can help identify a duplicate from another column? Below is a list of loan ids that we have and some of them have coborrowers but some dont. I dont need to remove the duplicates but I would like to create a new column that can identify quickly which one is a coborrower. Is there a…
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about DomoAI and get answers from Domo peers.
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications