Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Magic ETL - filter with not inPlease forgive me if this is a stupid question but until this point all of my dataflows have been i…
-
Summing a field based on filter criteriaI am trying to create a summary number showing the percentage of the total that is "open"…
-
Hour-over-Hour for the past 24 hoursHi, I have been trying to figure out how to graph performance of applications for each hour in …
-
HTML in Textbox Cards Type isn't Available ?Hi All So im trying to use HTML to format the conditional colour in text box cards, but it neve…
-
Beast Mode Syntax errorHi, I would greatly appreciate some help with this beastmode. The idea is to calculate what % …
-
Adding Chart to Table Cards Using Beast ModeDear All I stumbled upon this amazing knowledge base article, which is contains information abo…
-
Trying to calculate with multiple conditions in Beast modeI have this created in excel and it works perfectly, unfortunately, translating it to a case statem…
-
Benchmarking leads against an averageI have a dataset that aggregates all contact us form submissions submitted within my website for al…
-
Historical ComparisonsHello, We have completed our 2nd full year in Domo and we are starting to see performance issue…
-
Conditional FormattingHello, I've seen some other posts about conditional formatting, but they involved html and I have e…
-
Sum by using unique values in a different columnHi there, I'm kinda stuck here, I've read other similar threads on this topic but I don't think…
-
ETL内でSQLを書けるようにはできないのでしょうかSQLで全てコーディングできるといいですが、 SQLの知識もあまりないため、ETL活用させてもらっています。…
-
Can we use variable and temporary tables in MySQL data flow ? Something similar to storeprocedure?Here is the problem that i am currently facing. I need to Alter table column name at run time dyna…
-
DataFlow - Quickbooks - Picking up EditsGood Morning, Experts! I wanted to resurrect a question I had asked previously. The questio…
-
Renaming Input ETL datasetHello, I was wondering how in ETL mode, how to change the input dataset name. Whenever I input a …
-
Does anyone know how to solve "invalid data" in output dataset?I tried to join two datasets. Everything looks fine but the invalid data in the output data. The pr…
-
Beast Mode Help: Calculating Hit Rate (Projects & Quotes)Here is a short video overview of what I am trying to accomplish: https://youtu.be/Dz_uXS1OGco In…
-
Replace dataset that has many beastmode calculationsHave a very large dataset (5M rows) from a connector that we need to clean up by exporting the data…
-
Date Trunc in RedshiftDomo Community, I am trying to rewrite this calculation in Domo but keep getting a "FROM&q…
-
Are beast modes in dashboard cards calculated/updated client side or server side?Are beast modes in dashboard cards calculated/updated client side or server side? If someone is vie…
-
how can I exclude one min and one max in a datasetbasically, its a survey dataset that have a score of 1 to 10.. every quarter, we need to exclude 1…
-
Running total: ETL or MySql?I want to create a running total that resets every year. I've seen posts for doing it with ETL and …
-
Use Beast Mode to Change Column Header NameHow do I create a beast mode statement to change the name of a column header? For example: Column…
-
Best mode - combine MTD and YTDHi there! I have a problem with beast mode. I think the solution is easy, but I can´t figure out t…
-
Decimal to DateTimeMy data for date is being imported as decimals in a text format. How do I convert this 43497.241179…
-
Waterfall chart with annual values at each end and variances as waterfall stepsI'm trying to create a waterfall chart, where the first bar in the waterfall is the absolute value …
-
How to check date between two Dates?I want to check Pick up date between two date columns . See below. I am getting an error Invalid f…
-
Count Number of Log Ins this Year (2019)I would like to create an insight card that divides the number of Last Logins in 2019 (125) against…
-
Splitting columns with custom deliminatorHi, I'm trying to split my column in my data flow and the data in the original column is formatted …
-
way to split column name into first and lastHello, Is there a way to split a field if I have into 2? I have a field name, for example Bob S…
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 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
- 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