-
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…
-
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…
-
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.…
-
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?
-
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…
-
Allow Window Functions in MagicETL Formula Tile
It would be helpful to be able to write MagicETL formulas using window functions, similar to in beast mode. While the Rank & Window tile is often sufficient, there are some use cases where having this feature in the Formula tile would simplify the dataflow steps: Using a sum window function with unbounded rows This does…
-
Run only when all input datasets have been updated
Please add a run trigger that will trigger only when ALL the input datasets I selected have been updated. That applies to both Magic ETL and Jupyter notebook. Currently, when setting a run trigger and adding a condition to run when selected input datasets have been updated since the last successful run, the dataflow will…
-
Partitioning & Magic ETL Workflow - Does a Formula in an ETL happen retroactively?
Hi! We created a Magic ETL for GA4 data coming in. We are created a schedule to pull data through the connector every 7 days that we want to partition by the date field to make sure we have all of the data. Right now the output is Partition but within the Magic ETL flow we have a formula that might be changed quarterly. My…
-
Formula Editor Scrolling
Early last year, I reported an issue with the Magic ETL formula editor where it fails to function correctly once the amount of text requires scrolling. Because my data is healthcare-related, I’m unable to provide a screenshot. When the editor scrolls, it no longer accurately tracks cursor position or properly highlights…
-
Pivot Woes - Losing Rows causes total to change
I'm trying to Pivot out the "Actual or Budget" column so that I can create a variance calculation I'm using ALL columns (Except Actual or Budget in the "Group By" section, but I'm still losing some values. I know that values are lost because I'm comparing the total of a field before and after the pivot. Any ideas?
-
Magic ETL Search and Replace
Domo recently added search functionality in Magic ETL, which has been a fantastic enhancement—thank you for that. Would it be possible to add a Search and Replace feature as well? Often, after a dataset and ETL have been in use for some time, business requirements change and field names no longer align with their current…