-
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…
-
Field contains apostrophes(') likely introduced through HTML encoding, showing differently in hover
Field contains apostrophes (') introduced via HTML encoding, causing inconsistent rendering between table cards (which display values as-is) and bar charts (where apostrophes are missing or altered in hover text/tooltips). Beast Mode REPLACE functions did not resolve. How to solve this functionality. eg: " "
-
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,…
-
Semantic modeling - support for repositories needs to be added
We are taking part in the semantic modeling beta. The feature is coming together nicely and we were looking forward to using it behind some of our dashboards. However, we're running into problems on this front: it's currently not possible to use repositories to deploy a semantic model from one environment to another. On…
-
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 ✨…
-
Add from Canvas
I received an email that add from canvas was added to my Domo instance, however I am not seeing the plus sign on the canvas in either existing ETLs or new ones. is there something I need to do to turn it on?
-
Add Magic ETL Runtime History to History tab
The current magic ETL history page for any particular ETL shows the run successes near the top of the page, in a style that looks similar to a history of git-commits. Hovering over a square shows the number of successful runs on that date. We would like to implement some method of process control visible to all domo users…
-
Set a time threshold on dataflow runs to alert/cancel
We have a dataflow that runs quite frequently for an embedded dashboard. It usually takes under 1 minute to run, sometimes around 2 minutes. But over the last couple of weeks it took over 24 hours to run and fail twice. So it's technically running for 24 hours, without updating the embedded dashboard, and then I'm only…
-
Configuring ETL to pull from 2 datasets
I have a card that uses two datasets (A and B). A contains master information such as name, description, location, total1, total2, etc. B contains detail transactions that make up the totals. The card presents data from both: Name, Description, detail1, detail2. Detail fields are from B and summarized on Name field from A.…
-
Fixed Input Tile - subsequent join doesn't recognize column schema
I've used the Fixed Input tile several times and have noticed when I create a fixed input and then connect it to a subsequent join, the column selection in the join references a different input dataset upstream instead of the schema of the fixed input. I can eventually get it to recognize the right columns by clicking…
-
Changing dataset update method from Replace to Partition doubles data
We've noticed that if we change the update method of an existing dataset to Partition from replace, we end up with two records in the dataset for every new one (and both of them look identical, down to the field we're using for partitioning): it was quite the shock to see a dataset I expected to have 91 million rows…
-
Allow Group Ownership of Magic ETLs in DOMO
Currently only Datasets can have group ownership, however it would be a great timesaver if a group can have ownership of an ETL in Domo. It would make ownership more streamlined and controlled.
-
Magic ETL | CTRL + A to select all tiles
Instead of zooming out in the dataflow to select all tiles and then using “Copy to Clipboard”, it would be useful to allow users to simply hover the mouse over an empty (“No tile”) area and press Ctrl + A to select all tiles. Benefits: In large dataflows, this avoids the need for an extra click and a long drag to select…