Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
chart data creation questionhi all - I would just like to know how to add the highlighted section in DOMO(column B). I…
-
filter rowsI am trying to run a filter rows operation on one of my datasets for when field gn_id = '2013159', …
-
Modifying a Summary NumberI have a column in my data sheet with values like 0.202321. I display the AVERAGE of those values b…
-
Date FormatHi, The date in my data set is formatted as YYYY-DD-MM. As shown below: By default domo …
-
calculate exactly like Pivot tables in sqlHello, I have sanpshot coming daily which gives the information of how and what sales we did for t…
-
Time Intelligence in DOMOHello, Is time intelligence possible through Beast Mode? Meaning is row level context possible …
-
Date Wildcards in ETL?I need to create a data flow where results are limited to the current month. Right now I'm usin…
-
Dynamic Annualized Number- Using Hard Coded Number Now for the MonthI have a beast mode that is currently using a hard coded number for the month (i.e 7 for July) and …
-
Exporting Unique Values of ColumnI'm trying to export a list of the unique values in a given column. For example, I have a dataset o…
-
Partition By Beast Mode as a FilterI created this Max('Value') that is grouped by a certain NamingKey using the Partition By. I …
-
Add Rows Blend not workingI'm trying to combine two datasets together. Given the size of one of the datasets (62MM rows), I w…
-
Beast Mode If StatementLooking of help with a Beast Mode. What is the Beast Mode for including in the "count" o…
-
Issues with Converting Text to DateIn the Dataflow, I actually concatenated the MONTH('Date Column') and Year('Date Column') but when …
-
How do I replace text with unicodeHello, I'm trying to replace some characters in my table using Unicode Characters such as :whit…
-
Simple JSON parsingI have a field in a table that contains values stored in a JSON string like this: {"enable…
-
MYSQL Transform: Replacing date on historical input based on update of second inputI'm looking for the best way to do this. I have a SQL Transform with a recursive input and a second…
-
Adding totals based on titleshi, I am trying to group together user totals based on their adjacent column title I have tried…
-
Keeping historical track of live dataHello, I'm working with data from our CRM. To simplify things, let's say we only have one Pipeline,…
-
add leading zeroIs it possible to add a leading zero to a field if it has a specific number of digits....problem I'…
-
Calculating 2 Previous MonthsHi Guys, Trying to sum previous month value and the month prior value to display in a Comparati…
-
Add Column Error in MySQL TransformHi, I'm trying to map Google's LocationCriterionServices IDs to some Geo data from Adwords. I k…
-
First day of the weekHello. I have an excel output which has data fed everyday. that contains all information about how …
-
Getting beast mode to calculate 10% value of a columnHello Domo masters, Help Needed. I am trying to build a card that would display projects in a …
-
Card and Beast Mode to Isolate Best Performing StoresHi all, I need some ideas and help in trying to isolate best and worst performing stores based on …
-
Newly created dataflow getting failed with error message "Unable to update to Dataset"Hi Team, I am facing one issue from yesterday i.e., Dataflow getting failed with error message &qu…
-
User retention Beast Mode HelpHello, I'm looking at my dataset on our platform users and am trying to make a domo card that shows…
-
Combining values in 3 columns into 1 new columnI have 3 columns of dates (for example purchase date of: Column 1 - Apple , Column 2 - Pears, Colum…
-
Rounding a date/time field to the nearest half hourWe have a date/time field that I'd like to accomplish the following with: * Split the date and …
-
YOY in table card beast modeHow can i display YOY Sales Data side by side in table card using beast mode. I am using this beast…
-
Excluding weekends (using DATEDIFF function to identify employees first 3 days as training)A search for Exclude Weekends and Exclude Weekends using DateDiff Function returned a few results, …
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