Ask Magic ETL questions and get answers from Domo peers
Hi, I am currently building a dataflow and trying to get the best out of both sql dialect. I use Mysql to order my data (because redshift doesnt order properly) and then use another datflow in the redshift dialect to be able to use window function. What I am curious about is to know why Mysql does not support window…
Hi, I am trying to convert the "Date" from UTC to PST in the ETL. Currently, I created "Send Date PST" with the formula below. TIMESTAMP((convert_tz(`SendDate`, 'UTC', 'America/Los_Angeles'))) However, when I try to use it in the card and filter for the last 4 hours, my card is blank: It works when I do the same thing with…
Hello, I need some help pulling out email addresses from a text string. My goal is to place these multiple emails listed in the 'Description' column in a separate column, where they'll be separated by ','. Is there way for the search to end before the Sent Date info? Thank you!
Hi, I am wondering if this might be a glitch or what might be causing this problem. I have an ETL that I am trying to edit. The only dataset it uses is the calendar dataset. I am able to run it by going to the dataflow, clicking the three dots, then Run. (See attachment if confused) However when I click edit etl, and…
If I have 2 datetime columns (StartDate & EndDate), how do I find the duration (mins) between the 2 using Beastmode? Example:
I am trying to link 2 datasets to show scheduled appointments and web traffic in the same visit. The goal is to show what, if any, correlation there may be for traffic to specific ad campaigns and appointments for their related services. When I use datafusion or etl join, it gets messy because the only matching data I have…
Hey, I'm trying to select week id base on the current day and I wrote below case statement. But I'm getting error in here. Can someone help? (CASE WHEN week_id <= ( CASE WHEN CURRENT_DATE() BETWEEN '2024-02-10' AND '2024-02-16' THEN 1 WHEN CURRENT_DATE() BETWEEN '2024-02-17' AND '2024-02-23' THEN 2 WHEN CURRENT_DATE()…
CASE WHEN D's % of AOR = MAX(D's % of AOR) THEN 1 ELSE 0 END Some how this is returning the total for the column. All values are returning a 1.
Is there any way for me to mass rename columns? Instead of going into the "Select Columns" tile and going down the list 1 by 1 can I copy paste a text file somewhere that will do this? In any other case I would be fine renaming, but right now my dataset has an output of almost 700 columns.
This seems to be similar to the thread located here, but a little more extensive as we're looking to create a table that would compare several months as opposed to just two. https://dojo.domo.com/t5/Card-Building/hello-how-to-compare-month-to-month-with-secondary-axis-in-card/m-p/38214#M5099. And it looks as if a table…
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