-
MagicETL Recipes
We all have ETLs where we use common logic over and over again. I propose an idea to enhance MagicETL with something called 'Recipes'. A user could create a new recipe within Magic, add a series of tiles into it that do some common logical steps and save it with a given name (e.g.. 'Strip Whitespace and Split String'. Once…
-
How to create YTD, LYTD, LYLW, etc columns from a FISCAL CALENDAR
I have a dataset that has sales per item going by each week (yyyyww) for the last three years, only I can't use things like YEAR(CURDATE()) or YEARWEEK(CURDATE()) because the yearweek we're getting from the dataset is based on a fiscal calendar (Ex: The first full week of august is the first week of the year, so July 29,…
-
Company Turnover %
I am trying to calculate the company turn over %. We are pulling data from Salesforce into Domo. We have a custom object that lists all employees. These employee have an active/inactive status and a termination date. I am trying to figure out a way to calculate the total ACTIVE by INACTIVE YTD based on that term date.…
-
Pivoting into multiple columns
My dataset has a Month column. I want to pivot the data so that the months become the columns (so a column for June 2024, a column for July 2024, etc). Using the Magic ETL pivot tile it seems I'd have to perform the pivot for each month separately. Before I go down that route, does anyone know an easier way to do this?…
-
Magic ETL Join Tile
Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper. If I join the datasets, I get different results based whether the words in…
-
Pivoting multiple columns with the same column values as its values
I have a scenario where I have rows from multiple columns that I want to pivot into a multiple columns. Let's say I have three columns: 'Questions,' 'Labels,' and 'Values.' I tried pivoting the 'Questions' column into separate columns with values from the 'Values' column. Now, I also want to pivot the 'Labels' column into…
-
Changing the input datasource to multiple ETLs at once
I have a table that powers multiple ETLs and I want to change this table in all the ETLs to another table without changing it individually in each ETL. Is there a way I can do this or view what ETLs are powered via Domostats ( I know I can check this in the Lineage tab) but I want it in a table so that I can analyze the…
-
Annotate part of an ETL dataflow
Is there a way to annotate part of an ETL dataflow like the following
-
How to get Gross Sales from Shopify?
My team and I are in the process of building datasets from Shopify's API but we are not able to get the gross sales amount to match with the gross sales amount in the Shopify's dashboard. Does anyone have any insights on this? We selected the report "All Orders". We have played with all columns, total_price,…
-
Where is my data going??
My data seems to be disappearing between the ETL and the final data that it actually outputs. Here are some pictures to try to explain what's happening. The first image shows the preview on the final tile in the workflow (being the output file titled Work Numbers (Final)). The second image shows the same chunk of data,…
-
Dynamic Pivot
I have a table with a combination of fields and a target value. I want to concat all the fields (Retailer, Field, Target, Strategic Priority) and pivot the table so they are all columns with their respective Target Value underneath. I know how to do this with the Pivot option in which I manually create a new column for…
-
Form Builder and Form Viewer Transformation
I am trying to use submissions we get from forms in DOMO via form viewer/builder apps and turn them into usable datasets that we can create cards with. Right now the form submission data puts the label in one column and the value in another and I would like to make it where the data looks like this: Date: | Model: |…
-
Optimizing Magic ETL with Mini ETL grouping windows to expand within complex ETL.
When Magic ETL becomes complicated, should we have a feature that suggests and organizes features into mini ETLs for the data sources? These mini ETLs could then expand into a larger window within the main ETL. This would allow us to minimize it later and continue the process without needing to create multiple output ETLs…
-
DomoGPT...?
Hi, can someone explain how to access DomoGPT chat box?
-
Magic ETL Join Tile Alterations Field Search
We have really appreciated all the quality-of-life updates to Magic ETL over the past few months! I have a few ideas to improve a pain point we frequently encounter when building ETL's. Some of our standard schema is verbose and requires field name prefixes when ingesting from certain systems. When we attempt to alter…
-
Get latest data from Ingestion in ETL grouped by month.
I have ingested a data which is regarding the Employee HC. Its per month. I have uploaded first 6 months of data in my ingestion dataset. In my dataset, I have used the append method to update. I have to prepare an ETL to power a new dataset. The dataset is supposed to have data for all months of all clients. The ingestion…
-
Magic ETL Organization Tools
Thinking it would be great if Domo implemented some organizational tools within the Magic ETL. We've got some rather large ETL's, that get quite complex, and organizational tools (organizing tiles into buckets, with ability to minimize bucket, add descriptions to bucket, etc.) would help my team and company scale. Having…
-
Rank
I noticed there is a difference between ordering using Rank format on a card, and using the Rank tile in a dataflow. If you use Show value as 'Ranks small to large', whenever there is a tie, the following ranked item will remain incremented by one. But when using the Rank tile, after a tie, the consecutive numbers are…
-
ETL not joining despite matching columns
I am trying to join an ETL, but for the life of me cannot get the join to work. I have double and triple checked that the columns are formatted the same, trimmed on both sides just in case, etc and Magic ETL still won't recognize that the data matches. What should I do?
-
PRODUCT RELEASE SNEAK: DataFlow Sharing Modal
As an active Community member perk, we will be providing insider sneak peeks for the Dataflow Sharing Modal features we will be releasing on Monday July 22nd 🥳 Historically, when users wanted to share a DataFlow with another user or group, it was often difficult, time consuming and frustrating as you often run into…
-
Save and Run vs Save As
Bad idea to change the Save options in the ETL. I've been shooting down to the bottom option "Save and Run" for years. I've already duplicated multiple datasets working fast, have to back track, delete the duplicates, and update the actual ETL.
-
Snap to Grid functionality in Magic ETL
Aligning the tiles in magic ETL can become quite cumbersome without any grid or guides for the tiles to line up with. It would be great for the default behavior of tiles to snap to a grid or show guide-lines that signify when tiles are aligned.
-
Solved ETL - Replace Null Values
Hi, I have a dataset with null values and text and I am trying to replace them with 0 and 1 respectively. But, when I try to write a formula using the conditions 'If Null' or 'If not null' I keep getting errors. Does anyone have any ideas? Thanks! Edit: I figured out what I was doing wrong.
-
Joining on table multiple times
We are working on building out our backend in DOMO and are trying to build a relational database instead of having individual queries for everything. We are connected to NetSuite through Analytics Connect. The raw table we are bringing in has columns for employee, service tech, service manager, etc. In NetSuite, these all…
-
Data Import Help
I have web app that will not share data. No APIs, not even export capabilities. I could use some help with ideas of how to make this work. Here is what the website looks like on the website: And Attached is an excel file where I highlighted and copied the data into an excel sheet in three different way (Paste, Paste…
-
Blank Brick Dataset Schema
I created a blank brick to track office locations in the path of hurricane Beryl. My ETL produces a dataset with latitude and longitude in decimal. Now my blank brick is showing these values as integers. They are not integer. How do I force the blank brick to re-evaluate the schema. I tried reloading and reassigning. I…
-
Budget to Actual - Multiple Dimensions & Different Datasets
I have a budget dataset with the following columns: _Account _Subsidiaries _Department _Doctor _Location (Not in Use) _Headcount Resources _Placeholder 4 _Year _Period _Scenario _Currency _Measure _value I have an actuals dataset with the following columns: Appointment Date Status Appointment Type Patient Account Number…
-
ETL and Beastmode
Hello, hope someone can help me. ========= I have a card level beast mode and filter: Company Name NOT IN "AAA" Destination - AAA Filter NOT IN "Exclude" =========Here's the beast mode for Destination - AAA Filter:CASE WHEN Destination like '%AAA%' THEN 'include' WHEN Destination like '%Tipp City%' THEN 'include' WHEN…
-
Grouping dates of service to match a pay period
I have two data sets one with employee pay information that is bi-weekly. And one that has information about the employee's work services they provided The one with employee work data has dates that show when the service was performed (Date of service) and how many hours it took to do the service (Billable hours). What I…
-
Order By
Why does the order of elements change every time we run an API or an ETL? If I put a select column tile on an ETL, immediately followed by an output, I would expect the output fields to be in the order of the select column tile. I'm currently working on a complex aging flow and running the flow makes the dataset wonky and…