Ask Magic ETL questions and get answers from Domo peers
Hi All, I am using the sum function below which is throwing an error..can you please advise.. CASE WHEN YEAR(`DATE`) = year(CURRENT_DATE()) THEN SUM(`CURRENT_INVENTORY`,`NONCURRENT_INVENTORY`,`OLD_INVENTORY`) END
Hi, I have a dataset and every row has a date. I want to add a column using ETL that indicates what week that is (starting mondays). So for a row with 3/28/2022, the new column would have "week of 3/28" and for a row with 4/1/2022 it would also say "week of 3/28" since 3/28 was a Monday. A row with 4/5/2022 would say "week…
I am building an ETL and have noticed when I attempt to filter data by dates greater than (or greater than or equal to), Domo will filter everything out. I notice however when I select less than (or less than or equal to), it properly filters out.... What is going on here??? Is this a glitch?
I'm attempting to build a table, which pulls from a order history dataset and includes the following key columns: Account Number, Order Src (CSR, EDI, or DCX). When I create beastmodes (e.g. CSR $ = case when `Order Src` like 'CSR' then sum (`order_line_total_price`) end) to break down the orders for each account by their…
Hi All, I am trying to remove the text after space from the below example ..Can you please let me know how to do the same.. R17245 20 should return just R17245 FG789 32 should return just FG789... Can you please let me know how to achieve this in beast mode..
Hi All, I have a dataset that has the the different schedule codes by date at a PO number level..I am trying to identify the records from the most recent monday and compare it to the immediate last monday and then flag the combination of (POnumber /schedule_code) to be old (meaning this combination existed the last monday…
I'm trying to create a variable that I can reference a beast mode calculation, but it keeps on telling me "This calculation contained a syntax error". Is it not possible to create variables in Beast Mode? Or am I just messing up the syntax? I've tried: set @month=1 set @month:=1 select @month=1 select @month:=1 But none of…
I am trying to get a geolocation based on the IPNumber. Dataset a: ipaddress ipnumber (translated from ipaddress) Dataset b: lowIPNumber highIPNumber Country Region City I would like to add the Country, Region, and City values to an output dataset: ipaddress ipnumber Country Region City where a.ipnumber >= b.lowIPNumber…
Beast mode calculation needed.. If 'Model' value contains blank then ignore those column of data and take of rest of rows model example 1 20 2 --- blank 3 40 here we need to ignore 2nd rows
Hi, I am pulling in data from Pipedrive and need to use Calculated Fields to convert Pipedrive Field ID's into text. Is there a way that I can do this once instead of doing calculated fields for each metric?
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