Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Beast Mode works but not in SummaryI have created a beastmode calculation to show as my summary. The calculation works, however when I… -
Total the count of Attendees for last 7 days & last 14 days in Table ViewI am looking to find a way in Beast mode to do the following I have CustID and Class_Date and C…
-
sum column valuesI have a column total revenue which is calculated for each customer on a separate row, but I'm want…
-
Connecting to Pardot in hopes of getting email statsI've connect to Pardot in hopes of getting email stats. However I cannot get a 'send date' for my e…
-
Deliminator questionI want to count the information but don't want duplicates how can I do this and add the correct inf…
-
Calculate Age Using DOB and Interaction DateDoes anyone know how to calculate an age from a person's date of birth and a date of interaction us…
-
Is it possible to have a Table chart type with one of the columns displaying a barcode of a value?Hello, I have a rather archaic entry I have to do in one system based on DOMO data. I'd like …
-
Collapse and Merge ColumnsHi, I'm trying to join two datasets together with a single shared field. I can do this just fine, b…
-
R Script SharingHello, Appreciate if there are community members to please share a sample of R Script which you…
-
How to merge two rows in one?Hi, Let me show you what my table looks like and what I want to achieve this should be the easi…
-
Leap year in Magic ETLHi all, I'm working on an dataflow (Magic ETL) through which I calculate the MTD, QTD & YTD m…
-
COUNT(DISTINCT creates An issue has occurred during processing. We... ErrorI have created this first beastmode calc, and it seems to work just fine. Case when `Total On H…
-
Combine multiple distinct rows values in one cellHi, I am trying to combine the distinct value from multiple rows in a column with Beast mode. …
-
how do you format date for comparison to todayI have tried several iterations to compare the date field to CURDATE, CURRENTDATE, NOW and when I a…
-
How to get the second week Tuesday in a month?How to get the second week Tuesday in a month?
-
Levenshtein distance in MySQL dataflowHi, I am looking to implement the levenshtein distance function (https://en.wikipedia.org/wiki/…
-
Convert text into a numberHello, I have a problem with numeric data being recognized in Domo as text (word) data when I'm…
-
Can i write a nested "if" "and" statement in beast mode?here is what the excel formula looks like: =IF(AND(K5=0,L5=0),"remaining",IF(AND(K5=0…
-
How to join datasets without a unique IDHey All, Running into a problem, I have a IP address for a user, and wanting to reference the c…
-
-
Beast Mode Numbers Sorting ImproperlyHi all - I create the folling simple beastmode to find the number of days between two dates: D…
-
Sum of all instances of dates more than 30 days oldHello all, I'm attempting to sum all of the instances of dates that are more than 30 days olde…
-
Rolling Average CalculationHI There, I'm trying to do a rolling average calculation. Compare Average of previous 7 days …
-
Beastmode calculate percentage of actuals compared to target (NOT total)Hi, Ultimately I want to show utilization of billable & other hours worked, as compared to …
-
Create a new table from existing table with data for last few daysHi, Let say I have a table that corresponds to a Domo card. This table has a field with typ…
-
Is possible to send an E-Mail as final step of a DataFlow chain?Hi, We are developing a dataflow that needs to send an email to a list of users after all the s…
-
Calculate the number of days that an event take placeI have a giant data set with Order number, profit, coupons, campaigns etc. I have categorized each…
-
How to create a running total in ETL?How can add a number from the previous month in the ETL?
-
case when field is blank write something else display valueHave a field settlementID, I'm wanting to display when there isn't a value for that row to show pen…
-
Calculated field in a new Best Mode calculationHello, If a created a new calculate fied caled 'Data Calculated' can I use is for another calculat…
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 418
- Cards 411
- Magic ETL 386
- Beast Mode 366
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 165
- Data Flows 162
- Workbench 148
- SQL 131
- Charting 131
- Date 126
- Analyzer 121
- Table 120
- Governance 103
- Visualization 100
- Domo Everywhere 98
- Admin 95
- Embed 72
- Pages 68
- Export 61
- Error 58
- PDP 55