Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Using IN Beast Mode for multiple matches won't SUMI've got a Beast Mode I built and it calculates as expected except that instead of returning the su… -
A column in this calculation does not exist when it doesHello guys, I am trying to get a calculated field with case when. However, the calculation kee…
-
Days since last WednesdayHello. I'd like to make a calculated fiield to show datediff('end date','last thursday'). how do …
-
Table, compare several month-over-monthThis seems to be similar to the thread located here, but a little more extensive as we're looking t… -
Combine multiple results into one row/cellHow to take multiple results and combine them into one row, see attached.
-
Replacing IFNull value based on a separate keyHello and thanks to anyone who responds to this in advance. I'm relatively new to using DOMO an…
-
Beast Mode Help: Summary number to show % of transaction typeI have a dataset where there is a column name 'Ship Via Group' that contains three distinct values.… -
Removing duplicate from group by strings separated by commaUsing the ETL tool, I've got a column that is ALMOST exactly what I need. I'm trying to identify t…
-
Missing value for divisor in formulaHi all, I work in a consultancy firm and for us a key metric is billable utilisation (amount of…
-
Attendance Occurrence CountWe've been able to accomplish a good portion of the original request within dataflow w/transforms r…
-
Nested Concatenations in Beast ModeWhenever we use nested Concatenations with Case Statements, every Concatenations gives a break line…
-
Finding quartiles and outputting the data within each quartileHi I'm trying to break a dataset down into quartiles for Recency, Frequency, and Monetary (each… -
Redshift vs. MySQL vs. ETLHi Everyone, This Knowledge Base Article suggests guidelines for when to use certain In-Domo pr…
-
Beast Mode: Calculations from multiple fieldsHello Dojo! My question is whether we can create a beast mode calculation to index values from …
-
How can I find column name across DOMO?I have a field called "User Name". How can I find Datasets/DataFlows contains this "…
-
Easy Way to Measure Time in Business Days?Is there a fairly simple way to do this or will I be looking at a fairly complex workaround? I am a…
-
How do I identify the second lowest value? I.e. MIN('COLUMN') +1?I'm trying to sort my API calls by time and label the order in which they took place, however I'm n…
-
Activiey after a certain time in a DateTime formatted columnI am trying to see activity completed after 5pm, regardless of the day. I am not sure how to even b… -
MySQL Transform Only New DataHi, I'm trying to use a MySQL dataflow to transform data as it arrives (every minute via Stream…
-
list all beastmodesis there any quick way to get a list of all beastmodes that have been shared on a dataset?
-
Track Attendance OccurrencesHi. We've been asked to track occurrences (absence, late in, early out) for a rolling 30 day period…
-
First and Last Name in a single Column, when there is not Last NameI have two beast modes that take the `name` and break it into two seperate "colums" So I …
-
HTML in Summary NumberHey all! HTML is not enabled in summary numbers correct? -
Adding a column to a datasource in Domo Workbench breaks ETL transform (Redshift SQL)Hello! I was hoping anyone might be able to help me out with this. I am using Domo Workbench to…
-
help with margin formulaIm running the following formula to produce my margin %, and want when 'override_payee_id' = 'MEADB…
-
Using FROM_UNIXTIME CorrectlyHello, I think this problem is an easy fix, but it has proven difficult for me. I've imported s…
-
Beastmode Percentage CalculationHi There, I'd like to do a percentage calucation of the following beast mode. COUNT(DISTIN…
-
How to Create a Dynamic Pivot in Dataflow ?Hi, I have a dataset that I would like to pivot on a certain column value, development month, t…
-
replicating Google Analytics’ Time Format in DOMOI want to show Time on Site (and ither metrics that report in minutes and seconds) the way Google A…
-
Calculated Field to Calculate Fraction of Hours between Two TimestampsI am trying to calculate the number of hours (w/fraction, e.g. 36.25) between two datetime stamps, …
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