Ask Beast Mode questions and get answers from Domo peers
I am trying to make an outlier flag that flags values 50% above of 50% below the budgeted, or daily goal mount. I made two threshold calculations(dailygoal / 2) & (dailygoal * 1.5). I keep getting an error message, but I am not sure what I am doing wrong. Any suggestions? Thanks, and my sql command is attached below. CASE…
Hello, In the beast mode how should I get the percentage of column totals like below, 50 hours worked is the 12 percent of the total hours (410). I need to create a column like % Hours so that I can make further calculated fields based upon that. Provider Hours worked Total Tickets % Hours % Tickets John 50 20 0.12 0.10…
Hi there: I need help creating these calculated fields (in Beast Model) where they change based on current year. I created this in EXCEL but am still learning SQL - any help would be much appreciated! calculated fields cy Sum `rtfs_amount` for each DISTINCT `Base Request ID`where `fsa_spending_year` is current year cy+1…
I am trying to create this as output in a cell: $50,000/ 2.0 year(s) This is my code: CONCAT(request_amount_recommended,'/',' ',Duration in Years,' ','year(s)') However, when I concatenate, I'd like for amount to be in US currency format and the number to be with 1 decimal. I get this "50000/2.014646 year(s)" Any help will…
Hi there: BACKGROUND: I have data is a list of grants with organization name, grant amount, status of grant. I have Beast Mode code: SUM(SUM(requests_amount_recommended) FIXED (BY organizations_id FILTER ALLOW requests_granted)) I think it works - the issue is that it is summing TOO much. Ideally, I want to edit this code…
I'm using sec_to_time(`SessionTime`) to convert an integer of seconds into a duration however when a SessionTime should end in a single digit amount of seconds say, 5 seconds "12:45:05" the beastmode field is displayed as "12:45:5." This creates an unnecessary period and shows an inconsistent format. The result should show…
What is the best way to try and generate a random number in a Beast Mode? I am doing a presentation and want to remove names from my column and just make a beast mode to assign a random number. I tried doing rand() but that was not unique. I also tried doing length of name * rand() but that was also somehow not unique.
Hello, I was hoping somebody could help me understand how to sum the following case statement. case when `Date` = max(max(`Date`)) fixed () then `On Hand by Day - DO NOT SUM` else 0 end I need the calculation to be dynamic and reference the date selected on the card. All attempts to aggregate the case statement fail and…
Is there a way in beastmode to CONCAT() a number with anything and not lose its thousands separator? In my beastmode, accounts_sending_campaigns_distinct and sum(`reach`) are both integers that I wanted to be displayed with thousand separators CONCAT(' <div style="font-size:15px; color:#EDEDDA;"> <div> <span…
In a mega-table in Domo I have a table like in the attached picture, and I want to add another value After "Inquiries", "Core Leads" and "MVA Inquiries". That value is a Dimension called "Creative Name". All of the Creative Names within a given week will be the same. So I'd just like the table to display that unique value,…
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