Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Beastmode Sales per day to reach goalMy president is asking for a sales dashboard. Total sales for Day, Month, and Quarter. Month and qu… -
Count Distinct Number ChangesI've run into a really weird problem, that I'm curious if any one has ever seen it: I have a be…
-
Max Value per Month on a Weekly Feed DatasetWe have a dataset that pulls information from SQL that gets updated by the managers once a week for…
-
Fun with string functionsI do a lot of string functions to look at URLs. If I want to use a SUBSTRING and INSTR Function wha…
-
new user with simple AR questionsCard #1 - my output shows total AR by customer. I would like it to show how much is current, 30 day…
-
Interactive DatasetCurrently we are looking for an 'interactiv' dataset which loads and updates data automatically fro…
-
Beast Mode Calculation in Summary Number: Average CalculationI wanted to create a summary number with a beats mode calculation that calculates the average time …
-
Average Probability for every useridHello team, I'm trying to make a beast-mode calculation or build a logic around the below topic t…
-
How Can I add data to a data source?I have a Data Input called 'datainput_new' that in itself is a dataflow. I want to insert rows of d…
-
Closing Rate % And FilteringSo this is the first time I have not been able to find a solution on other peoples threads, so here…
-
Convert_Timezone() functionThis is an optimization issue I have run into when joining tables on dates. I am left joining a ta…
-
How can I calculate SLA for a ticket and how far past SLA the ticket went before resolution?Hi all, I have a dataset that includes customer escalation tickets that have been or will be wo…
-
Determining if a record falls on the first day of a quarter and if not collect it in the next QuarteI have been presented with an interesting task, I have a dataset that contains all of our sales rec…
-
Group By value with Average aggregation calculating differentlyHi there, I believe I'm missing what is going on with my various attempts to Group By source d…
-
Best mode percentage change incorrect valueHello, Can anyone please help me figure out why the following beast mode calculation returns the n…
-
Rolling Average NumbersHey, I'm strugguling with 2 things and I haven't been able to find anything related. So I'm try…
-
HTML Color of text inside of beastmode calculationHello all, I am trying to change the backcolor of the status column, here is the beastmode I am us…
-
Active Record Count as of Certain DateI'm trying to figure out the best approach for a Beastmode or other suggestion, to count the number…
-
Anyone experiencing connectivity issues?Dataflows cant be accessed and they are failing at run. This is the error that comes up "We … -
Active users last x daysI have the following dataset ( see the attached screenshot). It shows the userID active on a given …
-
Counting unique orders each monthHello I'm trying to build a beastmode calculation that will only count users ordering for the f…
-
Add date row in ETL (or other) for dates that do not exist.I have a salesforce import and am pulling in records that are not created every day. But I'm trying…
-
Amount of Days in QuarterHi, I'm trying to create a formula to count the total amount of days in the current quarter. Se…
-
Rolling 13 month calculated up to end of previous monthI have this calculated field whcih is a rolling 13 months but I cannot figure out how to limit it t…
-
Count the number of working days consumed or remaining month to dateI am trying to work out a Beast Mode Calculation on a dataset that I have that will tell me how man…
-
Use a case statement to return a value in another columnHello - I'm trying to return a value in one column when there is a certain value in another col…
-
Pivoting multiple columns to one, while keeping correlating dataOk pretty sure I need to creat a pivot table of some kind, to move data that extends in rows across…
-
Using SUM and MAXI am trying to get a quarterly view of a value where Q1 and Q2 are full quarters and Q3 is a year-t…
-
Effect of adding new column to imported data on an existing dataset/dataflowGood afternoon! Not sure if I'm using the correct search terms but we haven't been able to find any… -
How can I filter data?Hello Dojo, I want to show data which contains tag "help_request" but not contains ta…
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