-
Adding and Removing Users from Datasets in Workflows
I'm trying to change the the dataset owners of a list of datasets from their original owner to a single output owner. I have all the inputs on a flat file but and will use the loop over template but need help on the function to add dataset owners itself. Do i create a dataset variable off of the dataset name or the dataset…
-
Overage Execution Rows Protections
Just had a user accidentally do a join that we identified 7 hrs after the process started that was up to 72 billion rows. It was going to top out over 300 billion, but we hit cancel. However, that overflow credit usage topped out over 3,000 credits, which is not the kind of mistake you'd like your team to be making. So,…
-
Combining Filtered Rows to one table
Hello, I am using one dataset for all three cards shown below. I have them on separate cards right now as they each are filtered to different things. Is there a way I can combine them so they would all show on one card/table together with one heading but show the three rows one under another with their filters still…
-
MapBox - No Background
I'm in well over my head but here goes nothing… In my first attempt at using Bricks, I downloaded the MapBox Donut Cluster Bricks. I got it connected to my MapBox account and have a dataset with quantities for each Lat/Long value. However, there is no "backdrop" for the chart: It's working in that the donuts each have…
-
Conditional Gateway Tile
Greetings, I would like to propose the addition of a tile that enables early termination of a dataflow without writing to the output dataset when specific conditions are met. A key use case for this feature would be terminating the dataflow if the input dataset contains zero rows. In such cases, the process should end, and…
-
Blend/Fusion Removed?
Hi, does anyone know if Blend/Fusion features were recently removed? We have processes using them and we cant we find data fusion/blend in any of the transform menu options? We also have MagicETLs that take those fusions as inputs to materialize them in some instances and we're presented with an error on the inputs saying…
-
🚨 Calling all BI & Analytics users! 🚨
Shape the future of Business Intelligence and analytics by joining the 2025 Wisdom of Crowds research survey from Dresner Advisory Services. 🗣️ Share your insights on BI deployment trends, Cloud Computing, Self-Service BI, Data Science, and more. 📄 Receive a complimentary report of the findings as a thank-you! Don’t miss…
-
Drilling from Table Card
One of the most common questions I answer from Domo users is why a drill doesn't work as expected on a table card depending on where the user clicks. For example, a user would look at the table below and click "200" to drill to transaction detail for Customer B. Instead, they receive an error message saying "An issue has…
-
Calculating YTD for each week in table
Hi, I want to replicate a table that looks like this: My dataset currently has date, impressions, and goal, and in ETL I've mapped the dates to a week by joining with another table. How would I use beast mode to find the impressions to date for each week, as well as the delivery percentage of goal?
-
How do you add lines to a pivot table?
I am sure this is easy, but how do I get lines in my pivot table? I believe it has to do with duplicate fields, such as the dates. But is there a way?
-
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…
-
How to Find # Customers with X Miles
Hi Team, I'm hoping to find the number of customers within a given radius of a given business location. For example, how can I find how many of our customers are within 50 miles? What about within 100 miles? In order to capture ##% of our customers, how many miles do we need to travel? These are the types of questions I'm…
-
How do I initialize DDX Form Brick with Existing Dataset and then sync it to an AppDB collection
I was tinkering with the DDX Form and Dataset Brick and I want it where the table initializes with an existing dataset using domo.get(`/data/v1/${datasets[0]}`); and have it update into the new/existing app collection that is syncing to the brick, domo.get(`/domo/datastores/v1/collections/${collectionName}/documents`). For…
-
Extended DataSet information on DOMOStats
Can we get DOMOStats to include some of the additional information available on cards like in the API or CLI? While DOMOStats is great, there are some key funcionalities it lacks that are already available through the API and CLI and that would be a huge help when it comes to managing the instance. Some of the top of mind…
-
Alerts in SPC charts
Good morning, Not so long ago, for the SPC charts there were alerts that trigger when the control chart rules were met I am not able to find that feature anymore when setting up the alert
-
Why would a dataset that comes in daily sometimes change the date format?
I have had this data set come in daily now for 6 months or more, and now for the second time in 1 month the data is wrong, and it seems to be an issue with the date format. Any reason why the date format would change? The correct format is 2025-03-24, but yesterday some of the dates formatted to 3/25/2025, therefore…
-
Dynamic Positional Inventory
Hi, I am looking to create a pivot table that is able to handle positional inventory dynamically. For example, if I have 3 weeks in my filtered range, I want to only show the data on the last week. I am using the below. CASE WHEN Week ending date = MAX(Week ending date) OVER () THEN SUM(ifnull(EOH Qty,0)) ELSE 0 END This…
-
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…
-
How to Modify PDF output?
I want to give customers a pdf of their dashboard - but I don't want that first page that comes up attached - basically a "first page" saying my company and theirs. The reason is that the end customer is my customer's customer. I don't want any front page on the report all at. Is there any way to format pdf outputs?
-
Dataset Replace Function in Code Engine and Workflows
We have access to the append rows function in workflows via code engine natively today. This is useful, but it would be far more efficient to have the replace dataset function available. We worry about credit usage looping over a results set over and over again to append rows to a dataset. It would also simplify the…
-
Magic ETL Preview Single Tile / Run to Here
One of the biggest gaps in Magic ETL vs SQL dataflows in not being able to just run a preview of a single tile. I also wish we had the Run to Here option. For example, maybe I only want to run a series of tiles from a particular input dataset before it is joined to another dataset. The point is that it is inefficient and…
-
Snowflake retiring single-factor password authentication in Nov 2025
Snowflake has announced it will block single-factor password authentication by Nov 2025. (). This effectively means that connectors that require only username and password will no longer be able to connect to Snowflake starting Nov 2025. Customers who wish to connect their Snowflake data to Domo will need to use a…
-
Multi-Select/Checkbox Functionality in Search Bar for 'Select Columns' Tile (MagicETL)
When using the 'Select Columns' feature with a dataset that has many columns, it becomes a time-consuming process to search for and add each column individually. It would be incredibly helpful if we could implement a multi-select or checkbox functionality during the search for columns. For example, as shown in the image…
-
Moving Sub-Dashboards from One Dashboard to Another
Hi, I am trying to move a sub-dashboard I created under dashboard A to under dashboard B, is there a way to do it? The reason I have to created the sub-dashboard under A first is it is a copy of an existing sub-dashboard under A. I need to replicate it to be a sub-dashboard under B. I have tried to move it under 'Manage…
-
Last value in a given time period
I'm trying to write a beast mode to give me the last value depending on how the time data are grouped (e.g. by week, then value on last day of each week; by month, then value on last day of each month). I believe I could do this in magic ETL but then the end user can no longer choose the time grouping they're interested in…
-
Querying a Notion Database
Hi I am trying to create a JSON connector to query a Notion Database, Everything works ok, but I have a problem with pagination. In Notion pagination is cursor-based. How can I configure this?
-
Connect to Notion to Extract items form Database
Hi, I am creating a connector via JSON to connect to a Notion Database via API. The pagination in notion is cursor-based. How can I configure this?
-
Ask to copy AI Dictionary Definitions to the Column Definitions in the dataset
My descriptions in my AI Dictionary setup tend to be pretty close to what I would like for them to be in my column definitions. It would be cool if we had a checkbox (similar to Save to Dataset) that asks if you want to save that description to the column definition in the dataset as well!
-
Best Study Plan to Pass SPLK-5001 Exam in Short Time
Preparing for the SPLK-5001 exam (Splunk Certified Cybersecurity Defense Analyst) in a short time requires a focused and efficient study plan. Below is a step-by-step guide to help you pass the exam: Step 1: Understand the Exam Objectives Exam Blueprint: Review the official Splunk SPLK-5001 exam blueprint to understand the…
-
Bulk Add Filter Cards into a Layout
Currently when adding your page filters as Cards to a new App/Dashboard the fastest way to add multiple is to 1. Create New Card 2. Select Dataset 3. Change Chart Type to Filter 4. Add Dimension 5. Save 6. Click on the card & Save As whatever your next filter name will be 7. Open the new card 8. Change the dimension/beast…