Ask Magic ETL questions and get answers from Domo peers
Hello all looking to make a case statement, I could be using the wrong one. I want to have a Beast mode that states when a specific month then it states what the goal is, picture below. Thank you in advance
Is there a way to see a description of the changes made to every version of Magic ELT Dataflow? When I check DATA>VERSIONS, I don't see anything under the description.
Scenario is as below Got order table which has got historic data about order quantity on each day for last 2 years. 3 columns, Date, Period Type (e.g. Normal, Christmas, Stocktaking sale, Mother's Day, etc.) and Order Quantity for each day Got Period type for next 1 year assigned to different dates. Want to forecast order…
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. Problem with adding a filter is the removed values need to be in another line on the chart. Case When sum('value') - (when ID='Liability' Then sum('value')) End or Case…
Hello - newbie here - I need to know how to only include data that falls within my defined start and end dates columns. There are multiple flight dates, so I need to be able to bucket the daily delivery data within those defined dates. It just pulls in all of the data for each flight and I cannot seem to get it to work. I…
Hello, Is there an equivalent way to count rows in a partition with unbounded preceding and unbounded following? I see that "unbounded" is available in the 'preceding' option but not in the 'following'. I simply want to count all the rows within the specified partition and reflect to the respective rows, but the step 4…
Hello All, I am trying to find out an alternative of Vlookup kind of scenario in Domo. I have 2 tables - Employee Headcount Country Mapping Employee Headcount Table contains all employee related demographys such as ID, DOJ, DOB, Country, etc. But it does not have Region and Sub-Region data in it. For that purpose I have a…
I am using data pulled from Salesforce, but I want to show the bookings per month compared to the goal per month (essentially a chart using a scale marker that changes) The issue is that the goal is different every month. Is there a way to automatically build this in using Beastmode or a new DataFlow?
Here is my formula that is currently working! (CASE WHEN SKULabs Cost >= 25 AND SKULabs Cost<= 50 AND line_items_product_id THEN '25-50 Bucket' ELSE 'not 25-50' END ) I'd like to add at 'Qty On Hand' > 1 in this formula but I'm unsure of where / or if there can be 2 "THEN" statements. I'd like to be able to subtotal my…
Hi, I need help coming up with logic for this problem. I have a dataset that looks like this: ID Source 1 A 1 A 1 B 1 B 2 A 3 B I want to only remove rows from source A IF that same row is also in source B. Otherwise I want to keep rows unique to source A and unique to source B. The output should look like this: ID Source…
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 DomoAI and get answers 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