-
Can output dataset be the same as an input/existing dataset in Magic?
I am trying to join form responses on a dataset to update the approval status of some journal entries, but don't want to create a completely new dataset. There are cards built to show statuses based on the input dataset, so the idea is that the form responses approving the entries would just update the status instead of…
-
Enhancement Request: Wildcard Column Search in ETL
The current ETL search functionality is useful, but it becomes limiting in complex pipelines where column names include prefixes and suffixes. In large-scale ETLs with multiple datasets, joins, and transformations, locating specific columns during logic updates is time-consuming and inefficient. Requesting a wildcard-based…
-
Dark Mode - AI Generate Formula
When using dark mode and using "Generate Formula" in Formula Editor, the text typed in is also black so you can't see what you type.
-
Magic Power User Feature Ideas
I love magic and a lot of the new upcoming beta's like add node from tile will be a big help. I've created a custom chrome extension that I use to add features/fix bugs in Domo. I've got a few ideas from it that I think would fit within the ideas for power users. - Easier Re-order Select Columns Allow for the re-ordering…
-
Add which dataset triggered the Magic ETL to the execution details
Something really helpful is to add which dataset triggered a run on the details view of a Magic ETL run. A lot of times flows have many triggers and being able to quickly figure out which one can be valuable to make sure that run has the data needed or if it has ran due to some other dataset, etc.
-
Preview Row Count Estimates Can Round Differently/Strangely
My coworker, Nathan, sent me this meme which I think explains things pretty sufficiently. I imagine this is just a case of rounding up vs rounding down leading to the discrepancy. I doubt this would happen very frequently, but 1,000K does require a bit more mental effort to process 😂
-
Add AI in Formula
Add the "Write with AI" feature to the Formula tile in Magic ETL, similar to what's in the beastmode editor
-
Creative assets from Facebook
Has anyone had luck pulling in creative assets (links to content or embeddable content) from Facebook? I've tried many different configurations on the Facebook Ads Advanced connector and I assume I need a few different tables and some ETL work - but if anyone has some pointers on what components to grab I would be…
-
The Math Isn't Mathing
I need to move some beast modes into Magic ETL to help solve a total/subtotal issue. In my attempts to do that I've come across an unusual issue. I have a formula that doesn't seem to want to work. Budget SFM/LB (SUM(Budget Sales Dollars) - SUM(Budget COGS)) / SUM(Budget Pounds) This beast mode works just fine in a card…
-
Community JSON Template Library with Input Mapping
It would be awesome to have a "repository" of sorts, similar to GitHub, for JSON files for magicETL dataflows, paired with mapping instructions for inputs. This would be great for commonly used / needed dataflows, for example, anything having to do with governance that utilizes the out-of-the-box domostats and…
-
Editable Tables in MagicETL
I am trying to use the data from an Editable Table in MagicETL, but it keeps getting an error. I copy/pasted about 2000 rows of 2 columns into the Editable Table. Is there something special I need to do to use the Editable Table in MagicETL?
-
Lag to set a forecast
I am trying to use actual values to project forward. For example, I have a table that has Month (12 rows: January 1, 2026 - December 1, 2026) and a column 'Actuals' that is filled in For January, February and March. I can join that table to an Assumptions tile that has month over Month factor for all twelve months in the…
-
How to Update Historical Data in an Append-Based Magic ETL?
Hi, I’m working with a dataset that is updated monthly through a Magic ETL, where new data gets appended to the historical dataset. I now need to make a one-time correction to the existing historical data in that output dataset. However, when I try to create a new Magic ETL for this, it generates a separate dataset instead…
-
3 Datasets for Sales $ - how do I connect those 3 so that I can add a variance column quickly
In DOMO, I have: Dataset A: Sales $ at order level, daily (millions of rows) Dataset B: Sales $ at order level daily (millions of rows) Dataset C: Sales $ by Month (100 rows) Goal: I want to compare the Sales $ between these 3 sources quickly. Option 1: Create ETL, grouping Sales $ by Month for Dataset A and B, then join…
-
Add Concurrent Editing Lock / Notification for Magic ETL Dataflows
Currently, when multiple users work on the same Magic ETL/Dataflow, changes made by one user can unintentionally impact others. It would be helpful to have: A notification when a dataflow is being edited by another user A locking mechanism to prevent simultaneous conflicting edits An option to rerun or restore ETL data…
-
Plotting daily attendance
A recent question posted hours clocked using a bar chart. Just as I was reading their question, I had a similar need. I thought possibly others might benefit from the way I choose to handle this. We were counting hours a doctor was working vs hours the staff was working to identify whether we had areas over staffed. In…
-
Add a Dynamic Transpose Tile to Magic ETL
I have a dateset that is received with field headers in column 1 and data in column 2-X (varable amount of data elements). I need to be able to dynamically transpose that dataset (flipping columns and rows) so the data elements are stored in rows and the field headers are Row 1 allowing me to easily append data refreshes…
-
BUG - Constrained Joins not working
Noticed a few weeks ago that the constrained join feature on the join tile (one-to-many and many-to-one) in Magic ETL does not work, allowing joins that should fail to process. This is a big deal for us as we use the join constraints to ensure we don't have any cartesian joins in our data. This bug has huge implications…
-
Annualized Trailing Twelve Months Financial Reporting
I need to know if there is an easy way to create, either within Analyzer or using an ETL, that will allow me to create a financial report showing an Annualized trailing twelve pivot table (or just a table). The attached example is showing a trailing twelve months (one month per column), but I want the columns to show the…
-
Expanded Search in Magic ETL
First, I want to share that the search functionality within Magic ETL has been very useful. I would like to propose an enhancement to further expand this capability. Currently, when searching for a value such as a Product ID or specific field name, the results return locations where the string explicitly appears. However,…
-
Showing which dataflow outputs are complete or still processing
When a dataflow runs, whether it's a SQL or ETL dataflow, if there are multiple outputs, the dataflow will say it has completed its run when the first dataflow output completes. So even if another output is still processing, the dataflow looks like it's complete. It makes it difficult to know when a dataflow output has…
-
Label ETL execution "Successful" only after all outputs have been indexed
Current behavior: An ETL execution with multiple output datasets will be labeled with "Successful" status after any one of the outputs has finished indexing. If outputs vary significantly in size, larger outputs may not finish indexing (and therefore will not have new/updated data available) for some time after the ETL…
-
Dataset dropdown for tile inputs and ETL update triggers should be searchable/filterable
In Magic ETL, the Inputs configuration tab for certain tiles includes dropdowns for selecting input datasets for that tile, but the width of the dropdown is limited and cuts off longer dataset titles, and the dropdown items are not in alphabetical order. In this scenario, or when there are a large number of inputs…
-
Tip of the week #30: JSON Expander Tile for Working with JSON Data 🧩📊
Working with JSON data often adds friction to your DataFlows. Nested structures, arrays, and long text fields usually mean custom parsing and extra logic. The JSON Expander Tile in Domo Magic ETL makes this much easier by letting you visually explore JSON structures and expand them into clean columns in just a few clicks ✨…