Ask Beast Mode questions and get answers from Domo peers
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 ?
I'm getting the following error in a domo pivot table. "Warning multiple errors encountered for same location in pivot table indicated by ****." I know it's related to a faulty aggregation due to the fixed function beast mode below. But unsure about the fix.
Hi there, I have a table with Year and Value. Can you please help with the YOY % value - as an additional column? The dataset is by by date & time but we group by year. Year Value YOY % 2022 5 2023 6 20% 2024 8 33%
I am using the below calculation to find the employee who is having 3 or more than 3 PR. once I have this data then I want to total the count COUNT(CASE WHEN Attendance Check = 'Present 3 or More Days' THEN 1 ELSE 0 END) on the above calculation, i tried with the SUM function as well but it is still same. It is passing the…
Hello! I am trying to write a beast mode that counts a row of data if a date is present. The first row of my beast mode is working, but I am having issues with the second row. Basically, if a move-in date is present (or is not null), I want to count that row in this calculation. I am new to writing beast modes so I am not…
On some charts, for my summary value I need to add a custom Project Count Beast Mode, which is just this: Value1+Value2+Value3 etc… However, if any of the values are null, the count no longer works. Is there a workaround without having to exclude it from the Beast Mode? Thanks!
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