Ask Beast Mode questions and get answers from Domo peers
My dataset has these columns: year (int), month (int), target, actual I created a BeastMode to return the current month (Aug) value for both target & actual, but instead of showing an actual value for Aug, it shows 0. CASE WHEN month = MONTH(CURRENT_DATE()) THEN target ELSE '0' END Since I want to see the variance for…
I am hoping someone can tell me a simple fix for why my beast mode calculation is returning an incorrect value. What I am doing is not too complicated, but it is not working and I could use some guidance because I am new to Domo. I have created a column to show the total amount by Quarter using the following calculation:…
My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule. In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim. Below is an example…
I have an existing simple bar chart that is displaying a count of daily activity. The current fields are Date_StatusChange on my X axis and COUNT of Status_Desc as my Y axis. I'd like to aggregate all dates prior to Aug, 25, 2024 as "Carry-In" so I can display a count of everything prior to that date as "Carry-In" and…
Hi, I have a dataset that looks like this: Network Hour Date Avails A 1 1/1 2 A 2 1/2 4 B 1 1/1 6 B 2 1/2 8 C 1 1/1 10 C 2 1/2 12 C 2 1/2 12 The number of avails is the same for every row that has the same network, hour, and date. I need to write a beast mode that calculates the number of different rows that have the same…
Sounds like ABS can make a Negative value a Positive value, but how can I do the opposite? Need the result from this Beast Mode to be converted to a negative value: SUM (CASE WHEN DATE(`BatchTimestamp`) = DATE('2023-11-22') AND YEAR(`Month`)=2024 AND `FinancialCategoryName` LIKE '%CAPEX%' AND `Portfolio 2024_p`='Rejected'…
There have been many times where I am writing or troubleshooting a beast mode and when I come across an error, I have to individually go through each line to figure out where the issue lies. Most of the time it usually stems from a CASE WHEN statement and I’m forgetting an END or a parentheses. I think it would be great if…
Hello, I'm looking for a way to subtract the MAX values between consecutive months across a 12 month period, then display that difference for each month. Currently I am subtracting the MAX and MIN values for each month which is working as expected. Here is a snapshot of the card I'm using: Here are the beast mode…
I have a simple beastmode that I want to return the current time. The problem, is that it don't update. How can I get the NOW() function to update on some time interval or when you open the card?
I am trying to create a WoW variance at the type level for my data below. I have tried using a case statement with a fixed by statement by Domo keeps complaining. Is this possible ?
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 Jupyter Workspaces, R & Python Tiles, AutoML and get best practices 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