Discover best practices and find answers to your questions with advice from fellow Domo users.
We have some datasets on our Domo Workbench setup as Appends. They have grown very large over time as they take a snapshot of the data daily. The datasets are still used but we no longer need the complete history. We would like to do something like keep the last 2 years or maybe keep one reading per month or something…
Hello everyone, I'm seeking advice on configuring the Domo Email Connector for importing reports in a "month-to-date" format via email attachments. I want to a) retain the reports for previous months, but also b) replace the latest "month-to-date" report. Our goal is to achieve a combination of "Replace" and "Append" logic…
I'm trying to align some inconsistencies with our data. What I'd like to do is find any value that does not end with a '/' and append it with that character. Is there a case statement where we can look for a field that does or does not end in a character? I assume if I can do that, I can just append those without with the…
Appends should default to "Include All Rows" and not change every time inputs are added/removed. Huge quality of life upgrade!
Hi, I have two datasets. One has pacing data, the other has monthly data. All rows have unique IDs, however the pacing data may have either an ID from the old system (legacy ID) or the new system (new ID). Pacing: ID 1 2 3 4 11 Monthly: New ID Legacy ID 10 1 11 12 13 2 14 3 15 How would I go about joining these two…
I have two datasets. One is structured as the "primary" expense file, where each row is dates and other dimensions for each credit/debit. The next is credit card transaction details. They share transaction IDs in a column named Doc, share GL #'s, and share posted dates. The combination of all 3 of these things will result…
Hi here… When setting up a query to grab data from a remote datasource and append to data in DOMO. Is there a way to grab newer records based on the data that was previously imported. Page: DATA / <DATASET NAME> / SETTINGS / QUERY I'd like to run something like: SELECT * FROM myRemoteDataSchema.myDataSet ← remote dataset…
Hi I have created a date field in my dataflow using this formula to give me the current date: DATE(TODAY()) I am trying to use this date field to get a snapshot of the data every time the dataset refreshes. I have my dataset scheduled to refresh every Friday. The first Friday the dataset refreshed it gave me the correct…
Use case: I have callrail data that begins in 1/1/2021. Currently the dataset is updating everyday and has REPLACE as an update method. The dataset is now taking at least 1-3 hours to update. I thought about changing the update method to append but when I did, I had duplicate data from 2021. How can I change the update…
I have a large historical dataset to which I append records at the end of each day. I have been asked to correct the distribution of values for a small subset of the data over the past nine months. I can use the data repair tool feature to remove all of the data imports for that time, but this would force me to destroy and…
It looks like you're new here. Members get access to exclusive content, events and more. 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
Welcome to Domo's Community Forums! You'll find everything you need to get started in this category.
Questions or discussions related to Domo University, trainings and certifications
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).
All questions, news, and announcements regarding the Community Forums
Get the latest from Domo's Community Team.
Watch how our Customers are using Domo to solve their complex problems.
Old or outdated content that could still be found helpful.