Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Aggregate Multiple Text-based Columns to CardHello Domo Community! Long time reader, first time poster... hoping someone out there might ha… -
Summary Number with 2 metrics needing commas and roundingHi, I am trying to make a Summary Number for a card with a calculated field that will look like…
-
CSS Span doesn't look right- Table/Checkbox formatsI am having an issue where I put a CSS code with span and color and in checkbox and in the tables w…
-
Month over month comparisonI have a dataflow that returns the first day of the current month up to the current date and first …
-
Account Ledger Running Balance Beast ModeHi All, I am having trouble coming up with. beast mode to create a running balance for an acco…
-
HTML link to external softwareHello, I'm attempting to create a link on a table that will open up external software based on an …
-
Summary Number Issues with PartitioningHello, and thank you in advance for your help, I've been driving myself nuts with trying to do this…
-
Beast Mode "Share Calculation on DataSet" vs. Calculating in Data FlowHi all, Are there performance advantages to using the Beast Mode "Share Calculation on Dat…
-
MAX of SUM in Beast Mode Windowing FunctionsHello! Our org just had our windowing functions for Beast Mode turned on, and we're hoping to util…
-
Counts over time for things that have a start date and end dateHi, I work for a recruitment company where we have contractors working. Does anyone know how I cou…
-
Data Fusion not runningI've got two datasets 6.3M and 14.7M records. It's simple order and customer information tied toget… -
No data to set up alert?I would like to set an alert for when actual nb hours reach 85% of ave budget nb hours. When tr…
-
Sum Values based on duplicate unique values in another columnAfternoon all, Having a hard time figuring out this one out. I have a tabular report i'm conne… -
Change in MySQL calculationsHas anyone else noticed that your MySQL dataflows started to evaluate expressions differently? … -
Is there a way in ETL/Reporting to show the cumulative total for every monthI'm trying to show a dashboard where in I need to show the cumulative sum of the user count for eve…
-
Replacing Blank Values in DataflowI am creating an ETL dataflow in which I need to join my input dataset with other data sources via …
-
MySQL Dataflow Changing Column FormatsWhat I am trying to do is convert a bunch of time columns in my dataset that come over as text fiel… -
Beast Mode Calculation Timing Out in CardHave you guys had any problems with a Card Timing out using a Beast Mode calculation. I wonde…
-
Not sure what etl function to useI am trying to create individual columns for each contact type. Theya re connected to the prospect …
-
How to calculate other percentage in pie charts?I have to create a pie chart in which one field calculation is like this Sum(X) / Sum(Y) * 100 wh…
-
How to use datasets with duplicate column names in a dataflowUsing a JIRA connector, I import a dataset, which has a 1000 columns. There are two columns which h…
-
Grouping by the Hour and alerting based on count of usage per hour.Hello, I am trying to do a group by using hour of day. The date operator in Magic does not hav…
-
Single value Card - most recent dataI have a single value card that produces the number of hospitalizations today. My dataset is updat…
-
Calling a procedure in MySQL ETL flowI'm trying to create a pivot table output using a stored procedure, but I'm getting an error while …
-
Previous Period Date Range - Auto CalculationHi all, I don't have a ton of eperience with Beast Mode/ETL, but was hoping to learn a little more…
-
Convert a UTC timezone to Local TimeHello, Experts, I am looking for guidance on how to properly convert time that comes in as UTC … -
Clickable email link to Beast Mode fieldHi, I want to make a clickable email in a table. The email field is a formula, however, and I can'…
-
Uncollapse Columns or Dynamic Pivot or ??Greetings - I'm working on a Finance Dashboard and I've been given a data set in Excel that pulls …
-
Decimals with more than 2 pointsI have a file that calculates adjustments to salesperson goals. Occasionally the adjustments we mak…
-
A way to count records open (but not yet closed) per dynamic periodHello community, I have data that exists as such: RECORD ID, OPEN DATE, CLOSE DATE 12345…
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 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
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 413
- Cards 408
- Magic ETL 383
- Beast Mode 365
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 163
- Data Flows 158
- Workbench 146
- SQL 131
- Charting 130
- Date 126
- Analyzer 121
- Table 120
- Governance 102
- Domo Everywhere 98
- Admin 95
- Visualization 93
- Embed 72
- Pages 68
- Export 61
- Error 57
- PDP 55