Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Replicating multiple Excel Calculations as rows of data - Beast Mode?
Hello, I've got multiple datasets (actually customers) that we calculate a few things with separately. I was able to get all of the datasets (customers) combined so they could all be on one table: Typically what I do in excel is from those numbers I'll pull a few different things out: I'd like to basically mimic these…
Previous Month Last Year value Formula
Hi Everyone I'm trying to calculate a sum of values for the previous month for the previous year (February 2024 in this case) so that I can compare the difference to previous month for this year I've made a few attempts but have had no success What is the best way to do this calculation for last year previous month? Thanks…
REGEX Tutorial to Validate US Phone Numbers
Hi everyone, I wanted to create this discussion post to share a methodology I created using Domo's Regular Expressions in Magic ETL to parse and validate US phone numbers. This validation process follows the basic standards set by the North American Numbering Plan (NANP) and helps identify valid US phone numbers from a…
Fix ROUND() in ETL
It was noticed that ROUND() function rounds down in ETL when the last decimal is 5. It acts correctly in the card's beast mode.
How to calculate Months between two dates with DATEDIFF?
I was trying to use the formula DATEDIFF(month,date1,date2) to calculate the months between two dates based on the function details that shows up in Magic ETL (which I have pasted below). In the Unit form, the difference is returned in the specified units from the first argument until the second. For example, DATEDIFF(day,…
Seeking Best Practice Advice: Reporting Financials in Domo
Hi community, What is best practice for reporting financials in Domo? Currently, we have raw financials, account by account, fed in through a simple CSV. There are no summaries in this CSV, so I have to aggregate them with Beastmodes to get to summary numbers. For example, EBITDA is calculated as such (see code below) This…
When a value in column B appears multiple times against a value in Column A concatenate those values
Hi I'm really struggling with my dataset as I have a many to one relationship between the DIVISION and CUSTOMER columns which causes issue with grouping later in the ETL How do I write a formula which will affix the Customer name with the Division name if the customer appears against 2 or more Divisions else if the…
SUBSTRING Query (9 day n00b question)
Hi I've only been using Domo for about 9 days so still very new to this but I am trying to use the SUBSTRING function to return the values in my ID column to ignore everything before and including and underscore as this value varies in character size (example EN_, ENR_, ENO_) How do I get the ID column to return the values…
How to shift first week of year from December to January?
The card pictured below is filtered to 2025 - however, Domo's default week starts the prior Sunday which still lands in the month of December. I would like it to show a January date instead for the first week of 2025. I would ideally not like to use week numbers over actual dates on the x-axis. Has anyone else experienced…
Overlapping Date Beast Mode
Hi everyone! For context, I am making a card that flags overlapping contract dates. I want to make sure that the first order finishes its duration first before having another order. I only want to partition the overlap flag by customer and by the same business unit. Please see the Excel visualization sample I made below.…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.