Ask Magic ETL questions and get answers from Domo peers
I am attempting to pull out a string using Reg ex. I want to get the card name, so text after the --- card_name: and between measurable_id. I am using .*measurable_id) but it is giving me an error message?
Hi all, I'm trying to figure out the easiest way to create a new column with slightly filtered strings. My "Team" column contains strings such as: Team Name A - EMEA Team Name A - AMERICAS Team Name A - APAC Team Name B - EMEA Team Name B - AMERICAS Team Name B - GLOBAL I want to create a new column, "Simplified Team" that…
Could someone help and explain what's causing this error? And how to correct it? Thank you
Hi all, I'm trying to create the following logic for column '?' based on the header column: context header: the original column I want to rank against temp: a constant 1 for the row number logic row number: a row number ordered by temp ascending (recommended on the forum) header identifier: a conditional column using 'CASE…
Hi, I know there's a STR_TO_DATE function but maybe I could use more insight because it's not working. I have a date field that looks like this: 8-1-22 I want to convert this to a date. How can I achieve this with a ETL formula tile? Thank you.
My date filters are on the struggle bus in the new year y'all. CASE when WEEK(`Week Date`) = Week(CURDATE())-1 then 'show' else 'hide' end = 'show' The filter is simply returning this current week instead of the previous week. I assume this is because we are in Week 1, and the previous Week was 52. What's a better formula…
We need to map the Date field so that every date value is the first of the month. The value mapper tile can do this one at a time, but we need to do this in bulk. Can anyone recommend the best approach using a function?
Hey Domo Smarties! [Annotated Screen Cap Below] What's the best way to filter out duplicate rows according to the latest modified date in an ETL? Desired Result: One unique entry by "start date" and "model" with the latest "ob modified date".
Hello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter Start/End Date. For example: Input: November 8, 2022 Desired Output: Previous Quarter Start Date - July 1, 2022 Previous Quarter End Date - September 30, 2022 Previous Two Quarter Start Date - April 1, 2022 Previous Two…
Hello, I am using HubSpot Connector to create contact reports in Domo. A custom HubSpot Date property is pulling into Domo in a strange format and I can't seem to get this formatted as a date using Magic ETL or Beast Mode formulas that I have come across in other threads. My first booked Calendly date field should in this…
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