Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Option to persist a beast mode formula as a new column to a dataset for exporting purposesIt would be fantastic to have an option when creating a beast mode formula that allows the new colu…
-
Alert Bases on Average for Day of WeekFor a daily alert, we can not merely measure the difference between two consecutive days because da…
-
Fill in missing datesI am needing to find a way to fill in some missing dates. My data looks like this. Project …
-
Filtering based on distinct count valuesHello, The discussions I've found that are similar to this seem to suggest using ETL, which I…
-
ETL/SQL or Beast Mode Data Merging AssistanceHi, I need some assistance regarding the best way to perform the following. We have a report which…
-
How to calculate week numbers based on custom week start dayQuestion Summary: I want to calculate the week number from a date based on a custom week start day.…
-
Index Data CalculationHi There, I'd like to index data but my beast mode seems to be off. Below is what I'm trying to…
-
OFFSET function in a table viewHey Dojo! I'm looking to create a table that will dynamically show change between the row and the …
-
How to: Use a custom date range that rolls everydayHey everyone, I am currently stuck at a point where I need to find the difference between curre…
-
How to create a beast mode for email open rateI wanted to draw a chart to show email open rate over time. For a specific email, it was send on …
-
ETL - adding a field based off a Case Statement HelpCurrently we have an Access Query that has an expression created to add a field with a value to our…
-
Point New Dataflow to Existing DatasetIs it possble to point a new Dataflow to an exsiitng Dataset? I have an exsiting dataflow and an ex…
-
Magic ETL - Lower Case to Upper Case JoinI've got some extral data coming in via FTP that contains a key field that sometimes has lower case…
-
Replacement Variables in Amazon Athena Connector QueriesHi, I am new to Domo and struggling with Append mode updates in the Amazon Athena JDBC 2.0 Connect…
-
Alert on status of dataset (SUCCESS or FAIL)Hi, Is there a way, I can setup a alert to send mail if the dataset run schedule is FAIL or SUC…
-
Leap Year FixI noticed that our DOMO was pulling different trend %'s as compared to our regular route accounting…
-
Help with recursive dataflowHello, Experts, I am looking at creating a data flow that will constantly update data from a da…
-
How to set up a Future Date FilterI'm trying to figure out how to set up a beast mode that will allow me to filter out historical dat…
-
Conditional formatting of Columns in a table view cardWe need more options to format columns in a card table view. In particular the ability to colorize…
-
How to calculate usage %This is what I have: Content ID and Product are meta data for a full list of documents. When an …
-
BeastMode: Field contains lower caseWorking on a exception report where item descriptions in our item file contain a lower case charact…
-
Filtering beast modes using Card Start and End Date parametersHey Dojo! Long time, no talk. I'm back with an issue that's giving me one of those awesome tension…
-
Sum and Avg calculations don't do anythingHi all, I've been using Domo for a while now and consider myself a decent-to-good user. With that s…
-
Calculate average age till Last month, Last week, last year.Hi Team, I am need to compare the average age for the current month and previous month . Now, the …
-
Extract 1 row / few rows from big dataset (>100M rows)When I try to extract the _BATCH_LAST_RUN_ from a MySQL dataset with 106M rows, the ETL takes 3h20m…
-
Finding the latest date with specific criteriaI work in the training area at my organization. We are trying to determine "What is the lates…
-
MySQL query for YTD Running TotalHi all, I'm having trouble creating a mySQL query that does a running total by a certain Group By …
-
Role Permission needed for PDP UseWhat permission is needed for a user to use PDP on a data flow? Our users do not have Can Manage D…
-
Surveys in specific Date RangeGood morning, I currently have a dataset being created from our Qualtrics connector that counts t…
-
Magic ETL EfficiencyHello, I have a simple Magic ETL that I use to filter a dataset from our company's source syste…
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 416
- Cards 408
- Magic ETL 384
- Beast Mode 365
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 163
- Data Flows 159
- Workbench 147
- SQL 131
- Charting 130
- Date 126
- Analyzer 121
- Table 120
- Governance 102
- Domo Everywhere 98
- Visualization 96
- Admin 95
- Embed 72
- Pages 68
- Export 61
- Error 58
- PDP 55