Ask Magic ETL questions and get answers from Domo peers
I am trying to run the following flow using the following SQL code: select adv.`Account`, adv.`LDGRDATE` Adv_Ledgerdate, cre.`LDGRDATE` Prorate_LedgerDate, adv.`Total_Amnt`, cre.`Total_Amnt` Prorate_Amount, adv.`Ledger Type`, cre.`Ledger Type` Prorate from `test_grp` adv left outer join `credit_prorate` cre ON…
Trying to convert null values in an numeric column in an Excel spreadsheet in order to perform calculations on that column. Currently unable to find a work around
Hi all, I'm confused as to why my magic ELT filters are not working properly. Is it something I am doing wrong? How do I go about fixing this? In the first picture, I am in the data set and have set a filter on the 'time_stamp' column and its filtering the data just fine. For whatever reason, when I go to magic ETL and do…
When setting up Indexes in my SQL dataflow, I notice sometimes that a few columns in the join are not made available for indexing. Why is that? What can I do to fix this? I suspect without the indexing, my dataflow is taking an inordinate amount of time. Also, in the Domo help on optimizing data flows with indexing, the…
@GrantSmith Hi Grant, I have used your date dimension solution for lots of PoP charts but like you have mentioned on your post doing month over month can be tricky. Thanks for your help so far on my domo journey. My problem. I have daily data and have a period type of 'Last Month' and 'This Month' I have the data in a…
Hello, I am trying to create a graph using Google Analytics, specifically on referrals (Acquisition -> All Traffic -> Referrals). However, when I connect and select which data to include, I am not pulling the right numbers. Does anyone have advice on which metrics to pull in? Thanks!
Hi, I'm trying to create a 'current year, current month' and 'previous year, current month' beast mode. To this point I have created a current year to date but am not sure of the syntax. I have watch multiple videos and have searched high and low through domos resources. Any help with the syntax would be helpful Here is…
Hi, I am trying to create a running total of fiscal year 2023 vs the same time in FY 2022 and FY 2021 but all on the same chart. Right now, I currently have this Essentially what I am trying to do is take the three green bars from July 1 of this year, combine them into one column and then do the same for the pink and blue.…
Hi all, First time posting here. I need to know how to correct date formatting within a dataset. The dataset was pulled from Google sheets. As you can see, in ETL the formatting is wrong and inconsistent. How can I correct the format in ETL and make everything streamlined and compatible in the analyzer? Thanks
Hi, I am going through the Data specialist practical test and am running into troubles. Here are my instructions: Up to this point, this is what I have done: Because I am not an admin on my company network, for those familiar to this test, I was unable to complete the join on the workbench due to accessibility issues.…
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications