-
Alert / Notification setting
Hi, I created a dataset using the email connector, and some of my colleagues are also sending data via email. Is there a way to send them a notification to confirm that the data they sent was received? I checked the notification settings, but I only see two options. Can you please guide me on how to send notifications for…
-
Convert to timestamp
Hi, I have a process_timestamp column with string values like this: 2024-09-17T14:47:41. I am trying to convert it from a string to a timestamp in the format 2024-09-17 14:47:41. I used the formulas below in my ETL, but they are not working, and I get this error message "failed to convert value from type string to type…
-
Automate file upload
Hello! I am receiving multiple CSV files via email, and I need to automate the process of uploading this data to Domo. Unfortunately, I can't use the email connector because they send many files in one email. However, I can upload all the files into a folder. Do you have a solution for this? Thanks!
-
Alert set up
Hi, I have a card that is filtered by product_id. I want to set up an alert, so that if the calculated rate for any product_id is less or equal to 10% then I get an alert. For example, there are 3 product_id 10, 11, 12, and the calculated rate is the summary number. I set up the alert, but it looks like I am getting the…
-
Email connector
Hi, we are getting data in excel format from a service provider by email. I was trying to use the email connector, but only the data on the first page is uploaded in domo while we need the second to the 4th page. Is there another way to automate this task in Domo? Thanks
-
Google sheet date format
Hi, I have a Google sheet with a date column where I am using the googlefinance function. When I import the data into Domo using the Google sheet connector, the date changes from "4/20/2024 23:58:00" to "45,402.99861111111" in Domo. Please do you know how to fix this date problem? Thanks
-
Filter in magic ETL
Hi, I am trying to filter a dataset using magic ETL. The logic involves examining each id in the id column and then return the row with the highest rank. This will remove duplicate ids. I have attached images showing an example: before transformation and the desired output result (after). Can we achieve this using magic…
-
Google Analytics advanced connector not working
Hi, I am trying to connect our Google analytics account to Domo. I am using the Google Analytics advanced connector, but the views are not showing. It should show 2 views, like what we have in Google analytics, but it is empty. I am using a free Google analytics account. Can you please let me know how I can connect the GA4…
-
How to add a filter - match values - contains to a dashboard?
Hello! I have a card with a word cloud containing a filter - match values - contains, where I can type a keyword and filter all the words that have this keyword. I would like to have the same filter functionality in my dashboard. How can I add this type of filter to a dashboard? I don't see this option in the filter chart…