Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Is this doable? Seeing percent of total day sales by hour using Timestamp column.Hello! I have a problem that needs to be visualized and it was phrased to me like this: I need to s…
-
how can i filter colunms?I have data like below on excel sheet to monitor KPI of multiple products. Product 2021/02 2021/03 …
-
Reconnecting Disconnected Output DataSets and CardsWe are developing under several accounts (e.g. Dev1 and Dev2). In order to organize the ownership, …
-
Summary Number - Conditional Format Colors with Directional ArrowI've read a few posts here in the Dojo, and also read this Knowledge Base article: Sample Beast Mod…
-
Removing GUID from Columns.Hey all. Hoping I could get some help with this one. I am fairly new to DOMO but I have done some …
-
3+ Consecutive daysI'm creating a card where it shows the 3+ Consecutive days if the Delegate is No I only want to di…
-
Group Sales Data by Hour by DayHi! I have a dataset that has a timestamp as the date column. I need to sum the sales by hour for e…
-
How to append data to the output dataset?I have a workbench job that will run daily. It will get the data with current date. I then needs to…
-
Anything like Difference matrix, Difference between two pivots, difference within the value field?I've searched around but haven't had any luck finding what I need, but I am not sure if I've search…
-
Beast mode difference shows blank even when using coalesce@MarkSnodgrass and @GrantSmith, you both helped me with my last question and for the most part, it…
-
Count the number of times one day appears in a monthHow can I count the number of Mondays (also need it for Tuesdays, Wednesdays, etc.) in the previous…
-
Nested joins in Data FusionCan someone please help me to understand how to build nested joins using Data fusion? Should the li…
-
Comparing values based on their update in google sheetsHello, I am stuck with a very simple yet hard to design dataflow in domo. So just to elaborate my p…
-
Domo IDEAs Conference - Beast Modes - Rolling AveragesGreetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. Th…
-
Updating a DataSet Triggered by the Finish of a Glue JobWe are using a Connector to retrieve data from Amazon Redshift and display it in Domo. We use AWS G…
-
Handling multiple aggregation levels from source dataMy company uses syndicated POS data from sources like IRI, NPD, and retailer POS. There are many me…
-
Beast Mode for Aging BucketHi, I'm writing a beast mode to create the aging bucket, it's is showing results but it's has every…
-
What's wrong with this case when statement / how do case when's operate on the back end?Hello! I'm having a problem with a case when statement, and it seems like its not working because I…
-
Line breaks and special characters are being added to a webformWe use a webform for our Sales roster. We have had an intermittent issue with line breaks and speci…
-
Failed parse text 'NULL' from column 'Column Name' as type 'Date'Does anyone know how I can solve for the error msg below: Failed parse text 'NULL' from column 'Col…
-
Reg. Expression to replace a list of names with a single character.I have a column that is in a string format, and of course contains names. Majority of the rows are …
-
Can I dynamically group data to two periods (Current 12 month and Prior 12 months) ?Can I dynamically group data to two periods (Current 12 month and Prior 12 months) using window fun…
-
Changing a value to an integer in the ETLI have a column that uses an 'x' as a flag, any row that isn't flagged with an 'x' is left as an em…
-
Previous day values - Following Day Values Restart Calculation Each MonthHey guys, I have a dataset that appends each day to include the daily downloads, and resets the cal…
-
Assembler Upsert Date ColumnHi. I need to take a snapshot of today's data in order to compare it with tomorrow's data once it w…
-
I need help creating a retention chartI am trying to do an analysis to show users who came back to make 100 api calls after the making th…
-
Where can I find the logic for custom built dimensions?Hello, I'm having an issue tracking down where, exactly, I can find the logic for these custom-buil…
-
Swapping Pivot Table Rows with ColumnsHello, I am trying to create a table where the columns are a categorical variable and the rows are…
-
Time FormatHello, I am combining date and time in one column but once is combined the date format is ok but m…
-
Join IssueGood afternoon! I am having a join issue where only my inner join is working, but I would like to e…
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 468 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
- 173 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 398
- Beast Mode 369
- Dataset 336
- 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