Magic ETL

Ask Magic ETL questions and get answers from Domo peers

Recent Discussions

Transfer Street Address to Geo Latitude and Longitude Using Python
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 =…
Using Date in Face or Shape Chart Type
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,…
How can I add a Week Ending Date to my current Data?
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…
Magic ETL Filter Question
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…
Complicated Calculation involving a FIXED BY Beast Mode!
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…
New User - Help with Filling Forward Previous Incident Date
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,…
pivot tile?
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…
Can I use Python libraries in Domo?
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!
Equivalent to Excel Solver in Domo MagicETL?
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…
Magic ETL Question: Rank and Window and Filter
Hi, I’m trying to retrieve the current major for each student. Specifically, I need to select the ACAD_PLAN that ends with "BS" (for example: "BUSMBS"). Once I have those, I need to find the most recent EFFDT (effective date) that is less than or equal to today’s date, because I want to exclude any future majors.…

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Other Categories

Product Ideas
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ideas Exchange
Suggest & vote on new features you would like to see implemented in the Domo Product.
Connect
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Connectors
Connectors, Custom Connectors, Writeback
Workbench
Workbench, ODBC Writeback, Plugins
Cloud Amplifier
Ask Cloud Amplifier questions and get answers from Domo peers
Federated
Ask Federated questions and get answers from Domo peers
Transform
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Datasets
Ask DataFusion and Dataset Views questions and get answers from Domo peers
SQL DataFlows
Ask SQL DataFlow questions and get answers from Domo peers
Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Beast Mode
Ask Beast Mode questions and get answers from Domo peers
Visualize
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Charting
Ask Charting questions and get answers from Domo peers
App Studio
Ask App Studio questions and get answers from Domo peers
Variables
Ask Variables questions and get answers from Domo peers
Cards, Dashboards, Stories
Ask Cards, Dashboards, and Stories questions and get answers from Domo peers
Automate
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Apps
Ask Apps and DDX Bricks questions and get answers from Domo peers
APIs & Domo Developer
Ask APIs and Developer.domo.com questions and get answers from Domo peers
Workflows
Ask Workflows questions and get answers from Domo peers
Code Engine
Write, test, and distribute workflow functions with Javascript or Python
AI and Machine Learning
Ask questions about DomoAI and get answers from Domo peers.
AI Chat
Ask questions about using DomoGPT with your data
AI Projects and Models
Ask questions about organizing, managing, training, and accessing your AI models
Jupyter Workspaces
Ask Jupyter Workspaces questions and get answers from Domo peers
Distribute
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Domo Everywhere
Ask Domo Everywhere questions and get answers from Domo peers
Scheduled Reports
Ask Reporting questions and get answers from Domo peers
Software Integrations
Ask add-ons, plugins, and add-in software integration questions from Domo peers.
Manage
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Governance & Security
Ask questions about People, Groups, Roles, Sandbox, Activity log, Buzz, Teams, Approvals and PDP and get best practices from Domo peers
Buzz & Navigation
Ask questions about Buzz and navigation and get best practices from Domo peers
Domo Community Gallery
Watch how our Customers are using Domo to solve their complex problems.
Product Releases
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).
Domo University
Questions or discussions related to Domo University, trainings and certifications
Community Forums
Getting Started
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Community Announcements
Get the latest from Domo's Community Team.
Social Groups
Archive
Old or outdated content that could still be found helpful.