Ask Magic ETL questions and get answers from Domo peers
I have a datasource that looks like this (with ~50 different products, so having just four separate filters would not work): What I need is a table, filterable by product (using OR functionality, if C & A are chosen Customers 1, 3, and 4 should show), with the number of software seats for that customer, and a grand total…
I am trying to create a line chart with the year as a series. The data points are per month with a cumulative average. Data: Year Month Closed Cases Total Cases % Cumulative % (Cum. Math) 2022 1 50 100 50% 50% (50/100) 2022 2 100 150 75% 60% (150/250) 2023 3 100 100 100% 71.43% (250/350) etc. across multiple years where…
Hi, I need to round times to the nearest minute. Not rounding up or down, but nearest minute. Any ideas on how to use formula ETL tile for this? Thanks!
So, I've got a dashboard in which I'm trying to show the population over time at a facility for one of my cards. So, x-axis should be a date, and y-axis should be how many people were present at the facility that date. The dataset we have has a row for each client, and two of the columns are date admitted and date…
So I'm using a grouped bar graph and am looking to try and calculate the difference between two of my columns that were created. My company calculates the average spread on loans broken down by lenders we use. I was able to separate those average spreads by product by adding the products to the 'series' drop-in at the top.…
Hi, I have a dataset like this: ID Value 1 5 1 6 1 7 2 23 2 24 2 25 I want to write a ETL formula that creates a third column saying the greatest value for each ID is: ID Value Greatest 1 5 7 1 6 7 1 7 7 2 23 25 2 24 25 2 25 25 Thank you
Hi All, I want to fill the nulls in column A with the values in column B (or C if B is null). A case statement did not work here so I am aiming to achieve this by combining the columns and then separating them by delimiter. Unfortunately, by separating them we are - of course- back to square one. I was able to use this…
Hi , Can you please help to resolve issue . I have requirement where current year - previous year variance should be shown based on Global date filter selected from dashboard . Example : when 2022 ( This year selected from Global date filter) sales variance between 2022 and 2021 to be shown . when 2021 ( Previous year…
Hello Domo community - Good Day! Basically, we want to capture the data from the previous month on the current week. for example, the start of the week is 8/28 and the end of the week is 9/3. we want to capture all data up to 8/31 only. and then data for 9/1 to 9/3 using the start date 8/28 or end date 9/3. Thanks
I was trying to get a total number using Count with Rank & Window in Magic ETL but I can only get a running total instead of the grand total repeated across the rows. My output looks like this: jane doe, item a, 1 jane doe, item b, 2 jane doe, item c, 3 But I wanted this: jane doe, item a, 3 jane doe, item b, 3 jane doe,…
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