Ask Magic ETL questions and get answers from Domo peers
I found that using the expression REGEXP_LIKE(field,'^[0-9]') will check if a string contains any digits. What I'm struggling to figure out is how to flag whether it ONLY contains digits and no other characters.
In this instance, I am getting Google Reviews 0-5 stars and averaging them overall time. But this is the all-time average ending in that quarter. I know I can group by quarter and year but that would only give me the reviews in that time frame. I want to have it calculate the all-time score up until that quarter. For…
Hi friends! We recently finished the code to quadruple the Magic ETL canvas size (double the width, double the height). This will be going out to everybody soon, but we wanted to give some of you early access and let you play around with it before we turned it on across the board. Email me with your instance URL if you…
Hi i want to create a date comparison in the table here. Does anyone know how to start with this?
My data seems to be disappearing between the ETL and the final data that it actually outputs. Here are some pictures to try to explain what's happening. The first image shows the preview on the final tile in the workflow (being the output file titled Work Numbers (Final)). The second image shows the same chunk of data,…
I have a table with a combination of fields and a target value. I want to concat all the fields (Retailer, Field, Target, Strategic Priority) and pivot the table so they are all columns with their respective Target Value underneath. I know how to do this with the Pivot option in which I manually create a new column for…
I noticed there is a difference between ordering using Rank format on a card, and using the Rank tile in a dataflow. If you use Show value as 'Ranks small to large', whenever there is a tie, the following ranked item will remain incremented by one. But when using the Rank tile, after a tie, the consecutive numbers are…
I am trying to join an ETL, but for the life of me cannot get the join to work. I have double and triple checked that the columns are formatted the same, trimmed on both sides just in case, etc and Magic ETL still won't recognize that the data matches. What should I do?
I'm in need of a formula that will allow me to pull only the LAST four weeks of "Ship Date" data so I can get a weekly sales average from said data. I've tried a few variations of trying to use the INTERVAL function paired with < = to no avail. I need to then take the sales average acquired from the above task and assign a…
Hi, I have a dataset with null values and text and I am trying to replace them with 0 and 1 respectively. But, when I try to write a formula using the conditions 'If Null' or 'If not null' I keep getting errors. Does anyone have any ideas? Thanks! Edit: I figured out what I was doing wrong.
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