Ask Beast Mode questions and get answers from Domo peers
Hi! I need help to use the beast mode function. I have the following columns: Name, Ref #, Paid Amount, Savings Amount and Bill Amount. I want to get the Ratio of Each Name using this formula: Paid Amount + Savings Amount / Bill Amount Thank you!
I am currently having a column with different data types ( there are null, text, percentage -ve numbers, numeric values ) indicated as text column. The dataset displays %, -ve values. However , when cards are created, they only display the numbers but not the %. I tried creating beast mode for certain rows, however i get…
I have a data set of invoices that I want to compare in a bar graph where one bar is October and the other bar is November. I suppose I can do this with a beast mode but I think my syntax is off. Case when Title LIKE '%OTT%' Then 'OTT' AND MONTH(Date) = CURRENT_DATE(MONTH(Date)) THEN 'Current Month' Case when Title LIKE…
I know how to do a basic CAGR formula between two static years: power((sum(CASE WHEN Fiscal Year = 2024 THEN Amount else 0 end) / sum(case when Fiscal Year = 2020 then Amount end)), 1 / 4) -1 Is there a way to construct a CAGR calculation that responds to user filtering or changing the timeframe? I am trying to think of a…
How do I write a calculation to return the same date but for next month? For example, if the date showing is December 4, 2024, how do I return January 4, 2024?
Hello, is there a way to drillpath to an existing card using beastmode or any other domo features that might work? Thank you!
I've written this syntax to calculate a new column called Priority companies COUNT(DISTINCT CASE WHEN (Company Name IS NOT NULL) AND ((Activity types LIKE '%attended event%' ) OR (Activity types LIKE '%email engagement%') OR (Activity types LIKE '%webcast attended%') OR (Activity types LIKE '%webpage visit')) AND…
I have 2 variables 'Year Selector' and 'Month Selector' that are being used as filters drop down selection in an App But also used within a YTD BeastMode: SUM(CASE WHEN Year Selector = Fiscal Year AND Month Number >= 2 AND Month Number <= CASE WHEN Month Selector = 'January' THEN 1 WHEN Month Selector = 'February' THEN 2…
Hi, I have a URL field in my dataset where the data in certain rows have UTF-8 characters instead of normal html characters… For example…. https://www.theverge.com/2024/11/26/24306815/google-gemini-spotify-extension-rollout-android is showing up as…
Hi, I am trying to reset the running count every time the week ending date changes. Any idea on how to do that in a beast mode as the basic setting just continues to accumulate.
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