Ask Magic ETL questions and get answers from Domo peers
I am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I was recently creating a dataflow and some cards from that dataflow and decided to test something out. I created the card using a column from that dataflow and then proceeded to change the name of that column in the dataflow.…
Hi all and happy Monday I have some data i am pulling in via a SQL workbench that gives us a time clocked onto a job and another column for clocked off the job. The data is in a the format 2022-12-23T14:27:20. So i am trying to generate a calculated column that gives me the hours taken per job, for example: Clock on =…
Hi there, I'm wondering if it's possible (with Magic ETL or beast mode) to creation functions (like rank and window) that can lag value from Column 1 to Column 2, where both columns already exist. Full context: We have 3 columns. Monthly total, Last month, Year to date. I'm trying to generate a new YTD total every month by…
This… into this via magic etl
Hi Domo team and users, I am using an HTML table for my card, because I need to implement some cell specific conditional formatting (not shown in this screenshot) and only HTML Card works out for this. But while using this visual, there is no option to consolidate the repeating vales in a column. Any insights on this is…
Basically the title. I am using a dataset that pulls Month of the Year instead of Date, as the User count with the Date metric isn't accurate. However I have run into issues trying to convert Month of the Year into a date format. Here is the original format: As you can see, each month is numbered from 1-12. I used Value…
Hi All, In my ETL I am loading 2 columns for Credit & Debit, as part of my ETL I want to do Credit-Debit to get a column for amount however the data being loaded is recognising the Credit & Debit as text. I've tried to use the alter columns tile in my ETL to convert to an integer however it doesn't appear to be working.…
Hello, I have a data set that holds labor hours and wages for positions broken down by day of week. So for example, there are columns for Sunday through Saturday. Position 1 will have 0 hours in Sunday and Saturday columns and 8 hours in Monday through Friday columns. There is also a budgeted hourly wage. So what I can get…
Hello Team, I have a date column named 'Fiscal quarter start date' and another Beast mode with calculated value for 'Customer Survey' I want to create a beast mode in which I will compare the Customer survey of the Current Quarter with the second last quarter. I tried to create a Case statement but unable to get results…
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