-
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…
-
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 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…
-
Variables no longer carrying over datasets/cards
I used to be able to create a variable, and it would be available across all datasets and cards. I've recently noticed that variables no longer behave this way in our instance, and if I create a variable on one card, it doesn't even carry over to other cards in the same dataset. Is anyone else experiencing this behavior?
-
Optimizing Your Consumption: A New Governance Series 🔎 Session 2
Optimizing Your Consumption: Governance Strategies | Session 2 In continuation of our 3️⃣ Part Series , part 2️⃣ of these series we'll be covering ETL Best Practices and using the Governance Toolkit to automate the clean up process of your Domo instance. Reach out to your AE's if you have any extra questions or would like…
-
How can I get my navigation back when working in a Magic ETL?
Currently, when I am working in an ETL, the only way for me to return to the rest of Domo is to either run the ETL or open a new browser tab. Do I need to adjust my settings? I am tired of continually exiting. This is all I see when inside of an ETL. Domo to use Domo.
-
Trigger a workflow only when ALL the input datasets I selected have been updated
Most of our Magic ETL and Jupyter notebooks workflows require a trigger that triggers only when ALL the input datasets I selected have been updated. We update input datasets from Workbench. Larger datasets take longer to update than smaller ones. The Magic ETL must run only when all the input datasets are up to date, and…
-
Domo Community Declining - Oliver to Blame?
Hi my fellow Domo Sapiens, I've noticed a drastic drop in community activity now that the chat agent, Oliver, is present on the landing page and able to help answer questions. "Softball" questions (easy ones that I could answer) are less common now that Oliver handles the easy ones. While I do appreciate the efficiency of…