Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
ETL: SQL Set column typeIs there a way to set the column type of while you are creating the column in mysql? I have a colum… -
Delete/Hide RowsHello, I have a page of cards with a page filter, however, I need to limit what can be seen/sel…
-
Grouping/FilteringHello, Our main POS system allows salespoints to be assigned to salespoint groups. Salespoint grou…
-
Adding a field with mySQLHello, I'm trying to add a new field to an existing data set via mySQL (my first time doing thi…
-
Is there a way to use vector style data groupings in Beast Mode?I am trying to find a quicker way to use grouped data values in a column to filter an issue. Let's…
-
Issue with basic calculation causing card to error outI am trying to do what I normally would think of as a basic calculation in beast mode, but it is co…
-
How to deal with the 1st of month for "Current month" filterHello all, Context : Each day, we feed DOMO with the data of the day before (for exemple today,…
-
ETL: Calcs based on date rangesI am using Magic ETL to load data. My data has columns for customer, month, product and revenue. …
-
beast mode within a beast modeHello, I'm creating a card based upon the changes in tenure buckets of our sales reps. I am usi…
-
Transform task renaming Table + Adding "Create table"Whenever I try to run own of my data flows automatically it bombs. When I check the dataflow t… -
Setting Goals for each Quarter in Bar ChartI am trying to set goals for each individual quarter. My data is currently represented as a stacked…
-
Issue getting Last_Day(`Date`) working properly in mysql queryHi, I have a MySql dataflow that I'm having an issue with. I have this query that I'm working …
-
Beast Mode CodeI am trying to write the following Beast mode code If a date field is blank then "CAPA Phase&…
-
Using Total as figure in Beast calcThis might be obvious, but I couldn't find how to do this. Is it possible to use the total figure (…
-
Updating Brand New SQL TableWhat I'm trying to do with this sql data flow is to add to my data two additional columns based on …
-
Beast mode divide by zero errorHi, I am stumped on a divide by zero error. I am calculating the weekly index by comparing weekly …
-
Multiple date columns (count) from single dataset - using 12 month calendar NOT from dataset?I've read several posts on things simialr to this, but not sure that this exact issue has ever been… -
year over over comparisonI trying to build a line graph that is comparing previous years. X axis is showing months y axis s…
-
Summary dataset (from detailed dataset)We have a dataset (agent hours) that contains cumulative/summary data by status/day, and a beast mo…
-
Using a Beast Mode Calculation in Summary NumberHi, I'm trying to create a beast mode that will allow me to use CASE WHEN COUNT as a summary numbe…
-
Employee Tenure Based On Hire DateWhat is the Beast Mode Formula for calculating employee tenure using their Hire Date? I am trying …
-
compare field with current dateI'm trying to compare a field birth_date which I have converted to just show the month and day as D…
-
How do I use Fiscal Year in a Beast Mode?I'm looking to create a case statement to indicate the fiscal year that a transaction occured in. H…
-
Find Most Recent DateHey all, I am trying to find a way to locate the most recent date in a table based on rows of multi… -
Get value from a column for the most recent date on the datasetHow do I pull the data for the most recent date from another column in the dataset using beast mode?
-
Filters on Calendar WeekWe have Weekend Dates to be filtered for viewing Sales, But Business is used to filters Like betwee…
-
Percentage Calculation per Opportunity OwnerI am trying to determine the percentage of opportunities (by count) in (A,B,C Stage) / (D Stage) pe…
-
HTML/CSS issue (Summary# data showing on separate lines)Did a lot of reading from previous posts about using HTML/CSS in Summary#'s and wanted to give it a…
-
Concat percent sign (%) after a beast mode calculation. Syntax ErrorHi, I created a BeastMode calculation to create a basic percentage value. However, when I try …
-
Avg. Created OpportunitiesHi, I'm trying to create a Beast Mode calculation that will let me see the average opportunity …
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