-
Filtering and Adjusting Cross-Month Records in MagicETL
Hey Domo Dojo Community, I'm working with a dataset containing reservation start (RSD) and end (RED) dates in the format of MM/DD/YYYY. I need to identify all records where the reservation spans across two different months (i.e., RSD and RED fall in different months or years). My objective is to filter out these…
-
Can Domo Workbench Support TCP/IP Over SSH for Secure Database Connections?
Hi everyone, I'm working with Domo Workbench on a remote desktop (RDP) and need to securely connect to a MySQL database hosted on a private network. Typically, this is done via a TCP/IP connection over SSH, which adds an extra layer of security by encrypting the connection between the client and the database. However, I'm…
-
How to Use Partitioning to Retain Data in a Monthly Rolling Window Dataset
Hi Domo Community, I’m currently working with a dataset (via MongoDB Connector) that operates on a 12-month rolling window, where data older than 12 months is deleted on the 1st of each month. Long story short, I cannot change this configuration. But, I would like to retain some of this older data using partitioning before…
-
How can I efficiently identify specific columns in a large dataset using Domo’s AI/ML tools?
I’m working with a dataset that has 1308 columns, and I need to identify 5 specific columns that contain data like street addresses, credit card numbers, and property IDs. Or, at the very least, Domo provide 2-3 potential columns for each of the 5. The challenge here is that I'm unsure how these columns might be labeled…
-
Handling "Replace vs. Append" Logic with Email Connector
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…
-
Extracting Data from SharePoint Excel spreadsheets
Hello everyone, I'm in the process of setting up financial reporting in Domo. Our FP&A team processes financial data and then stores it in two specific Excel sheets within our SharePoint. I'm looking for the most effective method to extract this data into Domo, creating a dataset that can automatically update with new…
-
Required Role Level for Reverting Dataset History
Hello, Domo Community! I'm in the process of delegating dataset management tasks and need clarity on permission levels. Specifically, I want to understand the minimum role level required for a user to access the history of a dataset and use the "revert to this point" feature. I've developed some reports and plan to allow…
-
Breakdown of Yes or No Values
I am looking to create a graph or table that shows a breakdown of who answered yes and who answered no in a specific state. E.x. in GA 100 people took the survey, 45 answered “Yes” and 55 answered “No” in FL 50 people took the survey, 20 answered “Yes” and 30 answered “No” What graph/table would you use to display this in…
-
Trimming and converting a Date/Time Field
My goal is to filter all times between the hours of 9PM-5AM, but the data in my field looks like this: 2021-12-31T21:20:49 How would I trim this field to get the time exclusively and possibly convert it to 12-hour format? Thank you for your help
-
Pull a list of all datasets in Domo?
I'm trying to pinpoint duplicate information, datasets no longer used, and consolidate data. Is There a way that I could pull a list(s) of all the datasets and/or dashboards that are in my Orgs Domo? Thank you
-
Count amount of dates in a row
I have two fields in a table, ‘DateOfStay’ and ‘Market’. ‘Market’ is representative of an airport and its nearby hotels. I’m trying to calculate how many individuals are staying at a market on a specific day (DateOfStay). Any insight on how I can approach/achieve this? E.x. On 2022-03-01, 3 people were staying at a hotel…
