Ask Beast Mode questions and get answers from Domo peers
Hello, I created a card where users can filter multiple IDs at once. This is useful to quickly filter the card based on the account IDs that we got from another card. Users can simply highlight all the Account IDs, copy and paste them in the Input Text Box The variable is called enter_account_ids. Is there a better…
Hi community, I'm new to domo and need some help. I have a simple data set (see below). I want to only view rows that have an order date. if it's blank, i don't to see it. I was hoping to use the filter but I can't figure out how to exclude blank dates, i only get options to filter by various date ranges. Or, what would be…
I got this code to work, well kind of. Its only returning 110 CASE When Actual bid 2 >2700 THEN 120 When (model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%') THEN 110 ELSE 110 END Tried this CASE When Actual bid 2 >2700 AND model LIKE '%250%' OR '%2500%' OR '%350%' OR '%3500%' THEN 110 when 'actual bid 2' <=2700 then…
The specific task is to identify if a truck is a F-250,350, 2500, or 3500. The Column is "model" that I'm looking for the partial match in the model column. I keep getting syntax errors. CASE WHEN `model`LIKE ‘%F 250%’ OR `model` LIKE ‘%F-250%’ OR `model` LIKE ‘%F250%’ OR `model` LIKE ‘%E-350%’ OR `model` LIKE ‘%E-250%’ OR…
I'm trying to solve a problem where I want to compare the average of two columns based on the value of another column. A simplified version of my data table looks something like this: Score A | Score B | Score C | Survey Type 10 | 20 |19 | pre 14 | 26 |23 | post 7 | 6 |8 | pre 10 | 10 |12 | post I want to calculate the…
when I create a calculated field using this formula and this is created as Ranking CASE WHEN RANK() OVER (PARTITION BY SUB_CATEGORY_TXT ORDER BY SUM(SALES_LC_AMT) DESC) >=6 THEN 1000 ELSE RANK() OVER (PARTITION BY SUB_CATEGORY_TXT ORDER BY SUM(SALES_LC_AMT) DESC) END now when I drag and drop Ranking to filtering, it says…
Hi, I am trying to figure out what the best way to create a running sum would be. I know there's an option on a table, however, I am trying to create a line bar. Would the best way to go about this in an etl or a beastmode? For example 1-30-24 should be the sum of 47780 + 42874 instead of just the 1-30-24 revenue.
Hi I'm trying to create a Rank, but sometimes it works others it doesn't don't know why, I have customers and I want to be able to filter by the top 5 customers based on Shipments I have tried multiple formulas and the validation works, sometimes the table works but the filter does not work: This are the formulas I have…
I would like to create a beast mode that calculates the % of the way we are into a campaign. In Excel, I would calculate this as =(TODAY()-'Start Date') / ('End Date' - 'Start Date') Here's what I have so far (I want this to return a %): (SUM(IFNULL(CURDATE(), 0) - IFNULL(`Start Date`, 0)) / NULLIF(SUM(IFNULL(`End Date`,…
I have 2 Beast Modes that are returning inaccurate results. If I place each Beast Mode in a separate column in my table, they both return their respective values of 01 or 02 for every line even though they are opposite and even though not every line meets either criterion. Any suggestions? Thanks! CASE WHEN GL Group Code…
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