Ask Magic ETL questions and get answers from Domo peers
Hi, I am running into an issue where I am trying to join two datasets. Joining on a Unique ID is not an option as whoever set up this dataset decided not to include one. My next thought process was to join on date and name. Here is the issue I am running into. Dataset one has the full name for example Fredrick. Dataset 2…
Hello, I have a dataframe with a column named 'Screening Date' in that column are dates and null values. I want to create a new column called 'Completed' that looks through 'Screening date' and if there is a date in a particular row I want to Write "Yes" in my new column. If the 'Screening date' column is null I want to…
i have a large dataset that is too large on the SQL source to bring in monthly so I have to bring in daily. So, I need to find a way to keep a few months of data in Domo. What would be the best way to do this? Should I use recursion? Is partitioning another option? I'm not too sure how these work. Would someone be able to…
It would be great if DOMO could add user-defined functions as a feature. Is there any discussion of this becoming an added feature? It doesn't seem like it would be very complicated to implement, and won't make the software any less user-friendly for users who are not developing their own functions.
Hi - I'm looking to create a beastmode that is a filter - what that filter would do is display 2023 sales in January 2024 (excluding January), then starting February 2024 would switch to YTD. This stems from our YTD cards going blank at the beginning of the year. It is important to keep the cards YTD and to only display 12…
Hello, I feel like this should be straightforward, but I can't figure it out. During our master ETL, I have a lookup sheet that adds fields to the dataset (e.g. Account Owner, Region, Account tier (A, B, or C). However, if an account owner changes and I make a change to the lookup sheet, it's only updating new records…
I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column. Please see below: If FY is selected, then monthly data is shown for current fiscal year. and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.…
I'm Running MAGIC ETL to Transfer Data from Cloud Amplifier dataset (connected to Snowflake view with about 200 million rows) to a dataset without any transformation. Every time it takes about 1 hour 20 minutes to fetch data from Cloud Amplifier dataset (S3LoaderAction) as it seems it is doing full Data fetch all the time.…
Hello All, I am trying to find a better way to code this because I think the calculation may be faltering somehow. Alpha calculation is just a sum of amounts Beta calculation is just case pulling numbers from different fields. Mas field- what I am trying to achieve is simply to divide Alpha by Beta It seems to work somehow…
I have a client whose week starts on Monday. since the default week start day in Domo is Sunday, I would like to use beastmode to calculate week numbers with a start day of monday. I get a validation error every time I try to input a number in the [mode] portion of WEEK(date,[mode]). I'm referencing MySQL 5.5 documentation…
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