Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Domo IDEAs Conference - Beast Modes - Running TotalsGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th…
-
Average Lead TimeHello, I am trying to get the average of lead time between submitted and approved this is my formu…
-
SQL Row size too largeHI, I got an SQL dataset that was working well for over a month and yesterday I got the error m…
-
Beast Mode vs Formula Tile on Magic ETL 2Happy Friday Dojo Community! Does anyone know why a Formula would be validated by Beast Mode but sh…
-
Pivot tile returning results slightly less than expectedI have a dataflow with 2 outputs. I branched off some appended data to one dataset, and then I took…
-
MySQL - Creating new column via LEFT JOINHello! I am having trouble creating a new column (Dummy) to identify rows that I need to remove fro…
-
Create a summary number as calculation aggregate sum expense minus aggregate sum reimbursementsHello, I am trying to create a beast mode calculation to show balance remaining after (sum of all …
-
Does anyone know how to convert Google Analytics "Date Hour and Minute"?Does anyone have a solution they are using in a Magic ETL to easily convert Google Analytic's Date …
-
How to find number of data sources and magic ETL used in DatasetHi Team, We are trying to create a report with list of datasets with data sources used in that data…
-
Creating an "unassigned" row for gantt chart visualizationI'm working on a gantt chart visualization for resource assignments, and trying to add an "una…
-
How can we find data sources and magic ETL used in dataset ?Hi Team, How can we find total data sources used in our dataset with all magic ETL used for that da…
-
Is there a strategy to manage data that would allow 2 owners?Is there a way to have two owners for a dataset? We had a previous user leave the company. Now we h…
-
Framed Sum in Rank & Window Magic ETL not treating zeroes properlyHi there, I'm trying to produce a rolling 12 month total for each month in a dataset, but I'm findi…
-
Formatting Multiple Summary Numbers with CommasProblem To build summary numbers with multiple metrics, one needs to use the CONCAT operator, w…
-
Adding Budget Rows to ActualHello, I have an original cases database in DOMO each row has a case submission and case start, and…
-
Comma Separated Field to Child TableI've written a connector to query a remote API, the data has come in correctly but each row can hav…
-
Getting Previous Year Actual Sales to PopulateHey all- I'm sure this will come off relatively simple but this one has me stumped. We switched E…
-
Magic ETL Nested Case StatementHi all, I am trying to create a nested case statement (I 've provided an over simplified one that I…
-
Averaging multiple Percentile rankingsHi Everybody. I am stuck with a problem. First of all, thanks to Jae Wilson for the percentile rank…
-
Combining datasets by looking for strings in one columnI have a couple datasets... 1) Product IDs with information 2) Google Analytics data with URLs that…
-
Levels of Data in separate columns, bottom top approachHello, I am working on a request to provide all level of parent values for each individual child va…
-
Number of Months Left As Displayed in TableIs there a dynamic beastmode that counts the number of months displayed in a table?
-
Rolling PercentageI want to have a rolling percentage of a value across a series of values. I want to be able to cho…
-
Invalid date in MySQL datafow using HubspotHey there, I'm attempting to join HubSpot data with another datasource using a MySQL dataflow but r…
-
Trying to condense / group rows to remove nulls, any help appreciatedHello, I am working on a data flow that needs to perform various substring functions to isolate da…
-
Curved line + stacked vertical barHi, I have two question for the card of Curved line + stacked bar(Vertical bar) I would like to c…
-
Does Domo have the equivalent of a SQL Server "View"?Maybe I've spent too many years deep in SQL Server. SQL Server has the concept of a "View"…
-
2 editors for 1 etl in domoIs it possible to have two people have the ability to edit an etl?
-
How to indicate the values of two columns on Y axisHello, When I use the card of Curved line + stacked bar, it is possible to indicate the values of …
-
Adrenaline Dataflow: Inequality Correlated Subqueries UnsupportedHello, I'm attempting to perform a correlated subquery using an inequality as shown in the below ex…
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 414
- Cards 408
- Magic ETL 383
- Beast Mode 365
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 163
- Data Flows 158
- Workbench 146
- 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 57
- PDP 55