-
Group By value with Average aggregation calculating differently
Hi there, I believe I'm missing what is going on with my various attempts to Group By source data in order to gain an Average aggregate of a score. I take the entire dataset and when I place it in a table card and AVG the score, the calculation is correct but anytime I use the Magic ETL I was presented with a different…
-
Pivoting multiple columns to one, while keeping correlating data
Ok pretty sure I need to creat a pivot table of some kind, to move data that extends in rows across an unknown number of columns, and bring it all into one uniform column. The problem I have is keeping the associated row data when you move the data into one column. See below ---> What I have: What I need: How do I do this?
-
Map empty/null Date and Time using ValueMapper
Hi, I would like to map empty values of Date and Time to another value (for example, current date and time) using ValueMapper. Is there a way to do so? Thanks.
-
ETLで日時に9時間足す方法 UTC→JST変換
UTC日時をJSTに直すため9時間追加したいですができず、そのために ETLの後に DataFlow SQL を入れています。 ETCで時間の計算や、タイムゾーン変換はできますか？
-
Magic ETL Trim left of decimal
I noticed there isn't a ton (easily found) info on the different Regex to use to trim off data. My use case was I had a file using a numbering system before a product. So instead of saying Lowe's, Home Depot, Walmart it would sayd 1.Lowes, 2. Home Depot, and 3. Walmart. I found some regex that drops the period and what's…
-
Magic ETL Issues on Internet Explorer 11
Please weigh in if you use Internet Explorer 11. I thought this was a common issue, but I learned it may not be. Magic ETL does not work properly in my IE11 browser. Please let me know if you have IE11 and either have or do not have this issue. Thanks!
-
Funnel Card using Column Aggregates?
Hi, as the title sugests, I am having trouble creating a beast mode that I can use to funnel the totals of several different columns.What I would like to do is create a funnel for marketing emails, columns are 'email delivered', 'email opened', 'email clicked', and 'email bounced'. Each row in the dataset is an email…
-
Appending snapshot data to historical dataset
I am attempting to schedule a dataflow to append the week's data to a historical dataset which contains the previous week's history. The auto-updating dataset, call it: "projects_prod_daily" runs everyday as a replace data update. The historical dataset, let's call it: "projects_append_weekly" contains a history we…
-
Append Issues (Not matching & not appending)
We have two Append issues which cropped up this week that I'm wondering if other people have run into. It's worth noting that WoW, our process and dataflow *didn't change* which makes this especially baffling. Not Matching Columns We upload an excel sheet via the file upload connector using the append method. This week,…
-
Merging Legacy and New POS Dataset
Hello, Experts! I am reaching out in hopes that I get some guidance on the best approach for building out an ETL. Our company is undergoing a point of sale transition and things are going well. We currently have legacy data in one dataset and new data flowing into Domo separately. My CEO is wanting to see week by week…
-
Optimizing Domo Dataflows
* If you are struggling with long run times * Join big datasets at Domo Fusion speed and use them in ETL * Consistent failure of ETL after mulitple hours * Want to work on a subset of a big dataset * Create Views in Domo
-
Common Beast Mode & ETL Questions
Once you are logged into the Help Center, you can move seamlessly between Domo University Training, Knowledge Base, Community and Support (using the head navigation menu) . Knowledge Base articles are a great resource to answer many general questions. KB articles answering the most common Beast Mode/ETL questions: * Beast…
-
New Data Privacy Solution - Beta Testers Wanted
Domo has partnered with Anonomatic (Anonomatic | Protecting PII for Data Privacy and Compliance) to enable Domo customers to combine, aggregate or mask anonymous data at the individual level with no risk of loss or exposure of PII. With the PII Vault and Anonomatic's plugins for Domo Workbench Workbench can now completely…