My dataset has a Month column. I want to pivot the data so that the months become the columns (so a column for June 2024, a column for July 2024, etc). Using the Magic ETL pivot tile it seems I'd have to perform the pivot for each month separately. Before I go down that route, does anyone know an easier way to do this?…
I have a column in a dataset of production data. The column is formatted as follows: Production Cherry Tomato 12x1pt - Packed Beefsteak 15 LB - Restack Mini Sweet Peppers 14x4 FM - Packed I'm wondering if there is a way to pull the "12x1pt" "15 LB" and "14x4 FM" into a column for "Size". Given the varying amount of white…
Hi, I am new to the tools within the governance toolkit. I have been doing some research but wondering if anyone has any use cases for, or explanations of the following tools: Dataset Backup: Is this just a safety measure to take before you modify an existing dataset? If so, what would be the difference between this and…
I have a scenario where I have rows from multiple columns that I want to pivot into a multiple columns. Let's say I have three columns: 'Questions,' 'Labels,' and 'Values.' I tried pivoting the 'Questions' column into separate columns with values from the 'Values' column. Now, I also want to pivot the 'Labels' column into…
If I have a flow that is scheduled to run every two hours, and I do a manual run between those times, will the next run happen two hours from then or continue on the original schedule?
Hi. I have minute level data i am dealing with. I am trying to get total minutes that a post is open during a day. It can be post 1, post 2, or no activity. I am grouping by Date (Day) and Post then doing a difference between then Max and min timestamp to get total minute sin the post. This is how I want my data output to…
Does anyone know why I would this error when updated my ETL? I update this report each week, and received this error. I even defaulted to reports that have worked in the past. Is Domo having any issues today?
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…
It looks like you're new here. Sign in or register to get started.