Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Create a calculated column using beast modeAloha: I would like to calculate the following using beast mode, having the results in a new co… -
Beast Mode: Dependency IdentificationHi. I am trying to do a dependency status table for the project lifecycle. I currently have… -
An issue has occurred during processing. We are unable to complete the request at this time.Hi I am new to Domo and have no SQL knowledge. I am trying to get our YTD cases quantity with some …
-
DOMO Cheat SheetI made a cheat sheet for end users to create a card with beast mode functions. I hope it will be h…
-
Help with LEFT function in Beast Mode CASE StatementI am having trouble with the LEFT function in a CASE statement. It works as expected outside the CA…
-
Beast Mode to compare Values in 1 Column against 2 time periodsAfternoon, I have access to a dataset at my organization that pulls in competitor data. The…
-
Beast mode count distinct based on subset of dataHi - I am trying to count distinct patient ids based on a subset of data. My beast calculation is …
-
Tableau formula Conversion to domo questionHey all, I am trying to create a formulas in my ETL but keeps giving a syntex error. I'm trying t…
-
Datasets Which holds Certified Cards/Datasets and CCPA Certified Cards related InformationHi Everyone We need your help on below task. We want a dataset which is capturing the certified…
-
Adding row numbers to a table with a Beast Mode?Is there a way to add row numbers to a table with a Beast Mode? So there would be a column to the l… -
Beast Mode: Reverse Date CountHi All, I have a database containing project information updated on a day by day basis. A proje…
-
Domo totals are way higher than they should beMy Domo totals are way higher than then should be when I sum them, for example plays total should b…
-
Six Sigma score calculation in ETLHi, I'm trying to calculate the six sigma score in ETL, the excel formula is =NORMSINV(1-(((Errors…
-
Sharing calculated field in dashboard, and cards within onlyHi there, When I create a calculated field in beastmode, I understand I can share the field wit…
-
ETL using Append object not showing all recordsHas anyone noticed that all the other object/functions in ETL in the preview tab show the full numb…
-
Simple count of unique responses by locationThis should be easy I think. I have an app that produces survey response data in a pattern some… -
How to find position of string in Simple Domo ETL ( NOT in Beast Mode)Hi All, I have requirement where i need to find a position of character in Domo ETL (Not Beast …
-
Change color of the data label valuesI have attached an imagine of the card I'm trying to modify. I have a line + grouped bar chart.…
-
Calculate employee occurrences (absent, late, etc) from REHIRE dateHey all. Wondering if anyone would be able to assist with this. We have a card (simple bar chart) … -
ETL Magic - Join on Date Range?Hello Dojo, Looking for a solution to the following problem. I have a reference data set that…
-
DoMo trims leading zero while loading Text data into domoHi All, I am using simple DoMo ETL (Not Beast mode) and I have an issue with DoMo. I am loading…
-
Data Extraction from TeradataHi All, I need to create a DoMo Dataset by extracting a data from Teradata. Can anybody he…
-
Monitor last run of datasetsHello Community, We are looking for a way to monitor the last run of our email datasets. At the…
-
CAlculated Average to include in my datasourceHi All, I need help since I am not familiar with sql, but I need to a column with the calculated av…
-
Empty cells after aggregating and creating a case when variableHi I have a dataset that shows a sale/lost sale an agent made on a daily basis. Now I am using …
-
Summarize many columns in MySQLSQL newbie. We have a dataset which is sourced by a google-doc. The data has many columns with shor…
-
MySQL joins are not case-sensitive!I just realized that joins in SQL in DOMO are not case sensitive! This is a huge problem for me and…
-
Unsupported SQL type '{columnType}' for column 'VARBINARY'I want to assign NULL values to certain columns in a SQL transform: SELECTNULL as 'column_x',NU…
-
Tenure calculation using differences between 2 dates (magic etl)Hi, I am creating a new variable using the add formula icon where I am creating time period bin…
-
Create Task on Dataflow Output by RowHi! If this isn't the right forum to post this, please let me know. TL;DR: I'm trying to automa…
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