Ask Beast Mode questions and get answers from Domo peers
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!
Basically What the title says, I'm trying to figure out what I need to add to my beast mode to be able to switch between the unit type on the axis. I want to display Churn (%) as a percentage (without multiplying by 100) and show Churn (#) as a number. Attached is the beast mode that I have so far
Count Total Weight % of Weight 12x2pk 2,525,985 23.65% 12x4pk 169,092 1.58% 14ct 630 0.01% 16ct 8,505 0.08% 20ct 175,140 1.64% 22ct 239,400 2.24% 25ct 143,325 1.34% 28ct 395,640 3.70% 30ct 310,275 2.90% 32ct 1,196,370 11.20% 35ct 2,997,225 28.06% 39ct 787,185 7.37% 45ct 1,665,090 15.59% 52ct 68,355 0.64% If I have the…
14.76K is the total number of students (Both full-time and part-time). What would be the formula if I only want to count the Full-time values in the Full-time/Part-time column? And then if I want to change the count to percentage, do I need another formula for it? Thank you.
I have the following Beast Mode working for a comparison table (Period over Period is the name of the variable: CASE WHEN Period Over Period = 'Week over Week' THEN (CASE WHEN WEEK(Date) = WEEK(CURDATE() - INTERVAL 1 WEEK) AND YEAR(Date) = YEAR(CURDATE() - INTERVAL 1 WEEK) AND DAYOFWEEK(Date) <= DAYOFWEEK(CURDATE()) THEN…
Hi Domo, I am looking for a way to extract the string values in between stroke and question mark in a URL Example URL: https://dam-bc.com/content/67-making-AI-trustable.pdf?_gl=1*ckt29z I want to extract this part of URL: "67-making-AI-trustable.pdf" Ideally if I can do that with a beast mode formula would be great. But if…
Hi All, I want to create a column for YTD, YOY comparison by month and M-1. Example output is below: I have datetime in a format at yyyy-mm-dd Can someone show a use case for this?
Hi Everyone, I have a data set that shows where our tickets are being created and revenue. And I created 2 beast modes that separate where our tickets are being generated - CASE WHEN Source= 'G360' THEN 0 ELSE 1 END and CASE WHEN Source= 'G360' AND (Board_Name='Field Services - MAC' or Board_Name='Field Services - Repair')…
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