Ask Beast Mode questions and get answers from Domo peers
This is my first BeastMode to create and having some trouble. I am probably way off so just wanted to ask here to save some time. What I am trying to accomplish is to get a sum of current balance of those that are in the groups above 120 Days in the age group column. I'm wanting to Name the Column 120+ Here is my syntax…
I have a dataset that appends daily to build out a historical view. I want to be able to always show the latest record per date grain based upon the user selected date range and grain. For example, if a user selected YTD by month, then I would want to show the following values from the last day of each month SUM(values)…
I'd like to create a BeastMode 'MTD %' that can: Calculate the % of each GL account based of Total Sales Can be dynamically filtered by Month and Year variables Here's my MTD % Beast Mode: SUM(`Amount`)/ (SUM(CASE WHEN `Class 3` = 'Sales' THEN `Amount` ELSE 0 END) FIXED ()) And my MTD Beast Mode: SUM(CASE WHEN Fiscal Year=…
Hi everyone! I am currently exploring what is the best option for bringing Domo into powerpoint. Currently I am using a mac and want to import tables and cards into Powerpoint but with the tables I can see that powerpoint doesnt give the best formatting options ($, color formatting) the way excel does. Is there a way to…
Is it possible to create a Beastmode (or Magic ETLs) to show a column like % of Net Sales?
I am trying to determine if all letters in a field are capitalized. for example: String| Count ABC | 3 abc | 0 Abcd |1 How can I calculate the 'Count' in this example?
Hi Team, I was hoping to have some assistance on this request on creating a beast mode. There is a custom field that we have and want to remove characters from the drop down choices and then also remove all the other choices as well. We have drop down choices: Access Carrier- Circuit Not working, Access- Carrier-…
I have a table like this: Category | Actual | Budget Revenue | 4.50 | 5.50 Sales | 4,250.00 | 5,550.00 For this table, I have in a pivot table, and I want the revenue to be formatted with the ($), and the sales, I want to not have decimals. How can I do this in a beast mode? If I format this for the column on the card it…
I created 2 Beastmodes that I can drag into the 'Values' in the Pivot Table card: MTD = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN IFNULL(Amount * -1, 0) ELSE 0 END) MTD Last Year = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) - 1 THEN IFNULL(Amount * -1,…
I'm trying to count different text fields from a column called Reason and there are different reasons in that column. One row might have single or multiple reasons separated by a comma. Below are examples. 1) Reason 1 2) Reason 1, Reason 2, Reason 3 3) Reason 3, Reason 2 Beast mode using currently: CASE WHEN Reason LIKE…
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