Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Show last 12 months dynamically using beast mode calculation?I wanted to show last 12 months from June 2020 - May 2021 dynamically using beast mode calculation… -
Beast Mode to Add "Warning" for Data PointI have the Beast Mode below for a card that reflects IsShortAbandon "Good" when <=.07,… -
Append a dataset without using recursive designIs there any other way to append to a dataset without using a recursive design in Magic ETL?
-
Magic ETL error messageHello, can someone help me figure out how to fix this error in my ETL "failed to convert data…
-
Stop a Dataflow That is RunningAs you can see from the screenshot I have a dataflow that has been running for 16h+. Nothing in it … -
Sum specific product sales from one e-mailadressI've a data file which contains customer purchases. Something like: Product 1 - Email1 Product 2 - …
-
OneDrive Writeback ConnectorIs anyone using the onedrive writeback connector, and if so, are you able to write to excel tables?…
-
Beast Mode exclude or includeI have the below beast mode. (CASE when `vessel`like('%RB%') then 'exclude' when `vessel`like('%RO…
-
Exclude first Value - Rank & WindowI am currently calculating the contribution for my dataset and have already sorted my values in des…
-
Seeing more rows in ETL previewHi all, This is likely a basic questions, but I can't figure it out. . When I run a preview on my…
-
How would I filter date field for only the most recent date?How would I configure a BeastMode to filter only the most recent date? My data is machine name / la…
-
Dataflow fail notification bugHi, Over the last few weeks I've been getting notifications that various dataflows are failing. Ho…
-
Is there a Beastmode I can configure for Rolling 30 period?The caveat is the 30 day period I want to configure is Previous Month Second Tuesday to Current Mon…
-
Dynamic Report with RankingHi, I wanted to create a report that shows sales rank of each product by Store. However, because th…
-
Comparing two variables and measuring varianceSo, I am working with a dataset that contains questions from a form filled by two different users. …
-
How to add index number in the datasetHi Team, I have a dataset with around 1000 records. now I want to add one field in it name "id…
-
Domo Idea Exchange - Beast Modes - Business Days Prior to TodayGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th… -
Domo Idea Exchange - Beast Modes - Abbreviated Summary NumberGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th…
-
Domo IDEAs Conference - Beast Modes - Add Business DaysGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th…
-
Domo IDEAs Conference - Beast Modes - Time Difference FormattingGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th…
-
Domo IDEAs Conference - Beast Modes - Conditional FormattingGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th…
-
Domo IDEAs Conference - Beast Modes - Images and HyperlinksGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th…
-
Creating a separate column in transforming data using magic ETLI am using formula function to add a column that gives out values based on certain condition. I am …
-
Windowed functions in Magic ETL 2.0Does anyone know how to apply a dynamic range for windowed functions using SUM in Magic ETL 2.0? I …
-
Help with exclude formulaUsed this formula (CASE when `vessel`like('%RB%') then 'exclude' when `vessel`like('%ROLL%') then…
-
Demo Marketing Calendar added to DOMO-DOJOHi I'm Duncan Domo and I'm new to this!! So hopefully posting in the right place. Summary: I built… -
CASE WHEN X IS NULL THEN Previous ValueTried ETL Rank & Window and MySQL, but just can't crack this. If my field is null, then give me…
-
It's easy to remove Duplicates.....How do I KEEP only the Duplicates in a Dataset?I have a large dataset that I am constantly adding to, and the unique identifier for each item is a…
-
Does ETL Support the 'IN' Function in a case when?Does ETL Support the 'IN' Function in a case when? Does anybody know if this is possible? I'm getti…
-
Ranking x axis by year then month with a series sort by alphaI am trying to get an x axis to display in date order over multiple years while also sorting by a s…
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 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
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 427
- Cards 415
- Magic ETL 390
- Beast Mode 368
- Dataset 333
- Filters 183
- Card Builder 177
- API 172
- Dashboard 165
- Data Flows 163
- Workbench 149
- SQL 132
- Charting 132
- Date 126
- Analyzer 124
- Table 120
- Governance 103
- Visualization 101
- Domo Everywhere 98
- Admin 96
- Embed 72
- Pages 68
- Export 61
- Error 58
- PDP 55