Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
NULL ValuesNULL Values seem to cause some confusion. First, when filtering on a field that has a NULL val… -
Percent Increase DecreaseHello, If I have many columns for ex: "2010 population" "2012 population" &…
-
Beast Mode - UTC to Mountain TimeHey! I need help with doing a beast mode calculation. I have 'Date SO Created" and it has …
-
Effect of adding new column to imported data on an existing dataset/dataflow and populating itHi, I'm trying to add an extra column to a dataset that I have an ETL on. What I'm hoping to d…
-
Beast Mode Help - Special Rounding Case (round at up at .25)Here is a video that gives an overview of what I am trying to do with a beast mode. https://youtu.… -
Count Occurrences in StringHow can I find a string within a String? My String looks like: COPD|ARDS|Pleural Effusion I am a…
-
I am looking for html language to hide metrics within a beast mode summary number calculationHey all, I'm looking for html language to use in a summary number beast mode calculation to hide c…
-
SUM of CASE in Beast ModeHi, I am trying to sum a column based on date value output from another case statement, but i d…
-
I need to be able to change the Salesforce value field ex. USD $10000 to a decimal in ETL...I need to be able to change the Salesforce value field ex. USD $10000 to a decimal in ETL, so that …
-
How to change/reroute specific values in a field and leave all others the sameI have a table card. It shows the amount of deals closed by each sales team. In some cases, sales r…
-
Beastmode to Group All Months into a Total MonthHello, I'm trying to use a multi-line chart where I already have my years broken out but want t…
-
How to exclude current (incomplete) week from cardI am building a card that show number of visits at our practice. I would like to exclude the curre…
-
mysql transform unknown columnI'm trying to do what seems like a pretty basic transform on a salesforce dataset in Domo and it's …
-
Cumulated sum in a quarter using Magic ETLHello, can you help me to calculate a cumulated sum in a quarter using Magic ETL ? In this exempl…
-
Multiple input datasets for a dataflow to startI have a dataflow that has 3 input datasets. The dataflow has to run when all 3 have updated. The…
-
Current Date BeastMode/ETL// Categorize Days to MonthsI made a beastmode to substract the current date- a fixed date value which return in # of days. Now…
-
Round to 4 decimal placesVia beast mode or magic ETL I need to round to 4 decimal places so I can group prices charged to cu…
-
Error joining data. The left input cannot include over 10,000 duplicates.I have a magic ETL throwing the following error message: "Error joining data. The left inp…
-
Convert text field to date formatI need to convert a text field to a date field. I have tried magic ETL which didn't work. I also cr…
-
Net revenue retentionI am trying to calculate a net rev retention from X month to Y month (typically 1 months prior). T…
-
Determine the Week of the month in Magic ETLI'm running a sales forecast dataset and want to be able to determine what week of the month we are…
-
Show sum of two averages in summary number (already exists in nested coumn)?Thought this would be easy but haven't been able to get it so that BOTH of the average times for a … -
Window functions missing from MySQLHi, I'm trying to use SQL windowing functions with DOMO data flows, but they are not recognize…
-
Inserting line break according to a characterIs there a way to break a piece of text into a new line in a table by when a character appears? Eve…
-
Syntax error near ASIn SQL Transform, I have... SELECT * WHERE (CASE WHEN (FcstName LIKE '%Fcst%' AND 'Rev Month' =…
-
Performance of UNION in RedShiftHas anyone used UNION successfully with RedShift in DOMO? I have a DF that seems to stall on the q… -
How do you sort a calculated field as text?Hi there! New to Domo and still learning.
-
Date Calcs in Magic ETLDoes anyone have any hints or suggestions as to running time calcs, like DateDiff (minute), for Mag…
-
Case aggregate within aggregateHi, I'm struggling with a beast mode. I'd like to know the count of customers that placed an orde…
-
Rank of CustomerI'm trying to use the Rank feature. I want to rank the Top Record of Each Customer. I have a cust…
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