Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Find the percentage of count of value by categoryImagine there are 3 colums Country column - USA, UK, FR Purchase_status - Issued, Refund Count of… -
Compare to text lists and highlight differenceI have 2 lists and am trying to highlight differences i.e. Value owned Managed v… -
Adding Columns in Calculator and losing valuesI am adding two columns together in a Calculator function and where one column is blank, the sum is…
-
How to use partition by clause in Domo SQLI have following columns: Kingdom, Animal, Age, Weight Each row can be repeated multi…
-
Finding "earliest" date when one of them might be NULLI have a dataset with a key field (loan number) and a series of dates. Within the ETL, I have to c…
-
Case statement when two different fields are nullI need to filter a data set down to results where both the SQ and SQ_1 fields are null. How would I…
-
Time to Second Sum AggregationI am having an issue with summing 4 different time to second functions. I have 4 different souces o…
-
Alerts for when Data Sets FailCurrently if a data flow fails I receive an email alerting me to this occurance. However is there a…
-
Beast Mode Period-over-Period issuesOkay, so I'm trying to do 4 Beast Modes, and I cannot seem to get the right data. I'm trying to fi…
-
MySQL Rank over Partition/Window FunctionsHello! I know there was a post in September 2018 talking about how Domo's MySQL version doesn't sup… -
How to add color to hyperlink in beast mode?CONCAT('<div style= ""><a href="https:`,' "target="_blank"&g…
-
Case When Aggregation compared to another AggregationI am looking for a way to get a count of accounts that have had a note closed within 4 days of it b…
-
I need to export a list of attributes from my data tableIs there a way to create and export a list of attributes from my data table? I don't want the enti…
-
How to do generate_series in a SQL dataflowHi, I'm trying to elimate the need for a database between our production system and Domo by doi… -
Recalculate the transformation of the dataflow based on the specific time range selected in the cardHi everyone! I am trying to create a card to show the number of active customers. Active custom…
-
Beast Mode division calculation not workHello everyone, I've read other related posts and tried with my case but still failed, see if …
-
trouble with str_to_date in beastmodeI'm having complications formating an existing date column to my liking with the beastmode function…
-
Converting text to date in ETLHi all, I'm trying to convert a text into a date field in magic ETL, and I'm running into error…
-
Beast Mode to change value in Column A based on Value in Column BHi there! I have a table that includes a Site ID column and a Site Name Column. I want to change t… -
Historical Database I inheritedHi all. I'm dealing with CRM data, and have a snapshot of all of our data that is appended to a…
-
Beast mode as filterI created a beast mode to calculate $/visit, in my table chart, I wanted to show $/visit when it is… -
Counting characters in ETL?Hi there, I know there's a way in Python to count characters similar to LEN() in Excel, but I d…
-
creating a formula for quarters based on value received at month levelfor quarter 1 where month = jan , feb , march if data = 1 , then sum = sum+1 else sum = s…
-
Issue changing string date to date in MYSQL ETLI'm working on a query where I'm fed in a month name and need to change that into a date. I've form…
-
Average Data before Combining in ETLI'm trying to create an end result of comparing Rain to Sales by Day. I pulled Rain data from t…
-
Split dates in single column into multiple columnsI want to take a column that contains dates and split it into at least 2 columns to find the date d…
-
Adding Days to DateI am trying to add 7 Days to my date in SQL Transform. When I simply do Date + 7, the date is larg…
-
Sorting question, why are values of zero counted highest?Hi, I am sorting a table of highest to lowest based on yearly sales. An issue I have is t…
-
Magic ETL ExclusionI'm looking for an efficient way to only keep contacts that appeared in the year 2018 and exclude c…
-
combine multiple fields from one table into one main fieldhi everyone! I'm working with a dataset in which every new transaction creates a new 'transaction …
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