Ask Magic ETL questions and get answers from Domo peers
Hello, I just want to ask how do I join multiple Input Data from my email connector using the Join Data. I have a total of 8 Input Datasets. Thank you.
I have a column contains street address, and I want to transfer it into geo latitude and longitude using python script in Magic ETL This is my code and it's not working, anyone has any idea how to make it work import requests from domomagic import * def get_geolocation(address): api_key = ' ' url =…
Hi, I want to create a chart where, if a report is unfinished and the due date is more than 3 weeks away from the current date, it appears green. If the due date is exactly 3 weeks from the current date, it appears orange. If the due date has already passed, it appears red. However, I can only input numbers within a range,…
I have a dataset that comes in daily through an email connecter from my ATS. The report is replaced each day with new data. I want to see starts per day, which I can get. I also want to see total starts per week in trends; such as a 13 week trend etc. But my data does not have a week ending date on it. What is the best way…
Hi, I have two columns: Academic Plan (ACAD_PLAN) and Effective Date (EFFDT). Currently, I am using the Rank & Window and Filter tiles to retrieve the most recent EFFDT and, consequently, the latest ACAD_PLAN. However, when I apply the Rank & Window tile, sort EFFDT in descending order, and filter for Row Number = 1, I…
Hi All I have a challenge with a calculation which involves a few Beast Modes, one of which uses a FIXED BY function which I have converted to a numeric field using *1 at the end of the formula The calculation I need to create is (% of Revenue - % of Pricing) * Revenue to calculated a Delta however when I use the % of…
I'm working with citation data for different locations and want to create a column called "Previous Citation Date" for each location. So far, in Magic ETL, I’ve filtered the data by the days a citation was issued and used the Lag function in the Rank Tile to get the previous citation date, partitioned by location. However,…
hi I am working in Magic ETL and am having a tough time knowing how to do what I am trying to do. Below I have a dataset with 3 columns shown that I need. What I need to be able to do is keep the msp last run date on the left hand side but then pivot the `delinquent payment 2` into column names then show the loan count So…
Hey everyone, I’d like to use scipy.optimize in Domo to perform optimization calculations (similar to Excel Solver). Since MagicETL has a Python Tile, is this where I should implement it? Thank you!
Hi everyone, I'm working on a hotel lodging analysis and need to find something in Domo MagicETL with comparable capabilities to Excel’s Solver function. In Excel, we’ve used Solver to optimize the number of daily hotel room blocks (reservations made in advance) to minimize last-minute (adhoc) room bookings, reducing extra…
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