Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Beast mode to show only one monthHave a dataset for fire drills we have several locations that run them every month i want to create… -
How do Dataflows impact Dataset Certification?I'm exploring the option of implementing Card/Dataset Certification for our company. I need a bett…
-
Beast mode for count distinct by concatenating two columnsHi All, I am trying to do the following beast mode operation: COUNT(DISTINCT (CASE when `ord_date`…
-
Day of week Beast Mode CodeHi All, I am trying to do the following calculation in Beast mode but I am getting some errors.. Ca…
-
Syntax of ANOVAF(), ANOVAP() and TTEST()These functions are supported in the Fx Tile in Magic. Does anyone have some syntax examples ? The… -
Generate Date Range Column from Two Date ColumnsHi all ! Im trying to generate a date column with a range of dates from two columns: Table I have … -
String to DateHi I'm trying to convert a string to a date where the string shows "day Month", ie &q…
-
Domo Python errori am using the python tile in domo magic etl i am trying to cast a column to a category but when i… -
DOMO acting SLOW!!!!!!!!!!!!!!!!!!Is DOMO acting slow for anyone else? This morning, it has been crawling.... and I can barely get a…
-
Python Tile Typecasting while Reading DataA quick question in the magic ETL python Tile API method read_dataframe can you include the dtype p…
-
Deduplicating a table based on the content of certain columnsI have a dataset that has about 20 columns in it. The first column contains ID numbers and a lot of…
-
Help with Formula/ Beast mode to concat values based on unique keyHi All, I am trying to write a beast mode formula from the input table below: to the output table B…
-
Replacing single quote/apostrophe with nothingI am trying to replace a single quote with nothing using the formula tile in Magic ETL, but it is g… -
Domo CLI - Return Limit for List-Dataflow Command?when running list-dataflow --filename filename.json, I believe that the returned payload only conta…
-
Calculated FieldHi there - I am trying to add another constraint to a layered case statement but it does not seem t…
-
Color Code a Beast mode column in the tableHi All, I have a beast mode column by the name ( % Aloc on 3yr sale) which I have renamed in the ta…
-
Automatically export Dataset from DomoHello Domo comunity, We are looking for automatic dataset export from Domo to email. Is there …
-
Is there a way to track who changed a dataflow?I'm looking through the various DOMO - Dataflow datasets and I cannot find any field that indicates…
-
ETL Option to blank fieldIm trying to get a field that has blank values to get data from another field is there another way …
-
Help with Beast code to do color coding on the data..Hi All, I am trying to do a color coding on two columns in my card (1 yr change % and 3 year change…
-
Formula cannot be addedHello, I am a a beginner user on Domo (used before on Alteryx). I have tired to add formula the th…
-
-
Help with Magic ETL to find the status of SKU items manufacturedI have a delay table (as below) where a SKU is identified by the combination of mmodel and srno and…
-
Historic Timesheet AnalysisI'm working on an analysis of our historic timesheet data and trying to calculate our employee util… -
Case using Between with TextHello, I am trying to use the statement: CASE WHEN `START_ZONE` BETWEEN 'A' AND 'Z' THEN `PICKUP_TE…
-
Dynamic Target Based on Current DateHello all, I am currently utilizing a gauge card with a target metric. What I would like to do is h…
-
Help with Magic ETL to calculate the distinct count of pickup numbers by plantHi All, I am trying to get the distinct count of pickup numbers by plant and pickupmonth year..Plea…
-
Forecast monthly expenseI'm trying to create a formula within ETL that will help budget owners understand how their expense…
-
Moving one column under anotherI have a table with 5 columns: column 1 is an ID, columns 2 and 4 are codes, and 3 and 5 are corres…
-
Sorting Year date Filter in Ascending orderHi All, I have a beast mode created as CONCAT(YEAR(`pickupDATE`),'-',MONTHNAME(`pickupDATE`)) which…
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 437
- Cards 418
- Magic ETL 400
- Beast Mode 369
- Dataset 337
- Filters 184
- Card Builder 178
- API 172
- Data Flows 169
- Dashboard 167
- Workbench 150
- SQL 132
- Charting 132
- Date 127
- Analyzer 126
- Table 121
- Governance 103
- Visualization 101
- Domo Everywhere 98
- Admin 98
- Embed 73
- Pages 70
- Export 61
- Error 58
- Excel 55