-
ETL calculation to work out hours taken from a start and finish timestamp
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 =…
-
Date on a CSV as text to convert to a useable fate format
Hello I have been given some data to process daily, it has a date column but its formatted as Text, and has a short month, for example it looks like: 01 Jan Data in DOMO looks like: There is another column that has the full month name and the year (as a month summary) so i have trued to split out the Short and Date Summary…
-
Google Analytics 4 (GA4)
Hello Sorry for opening a stupid but simple question, but with the switch to Google Analytics 4 (GA4) the old Universal connectors have now stopped gathering and pulling data. I have tried the following two dashboards: Google Analytics QuickStart Compatible data sources Google Analytics Advanced Connector Google Analytics…
-
Facebook Connector reporting an error
Hi all Quick question? I have the standard Facebook dashboard and connectors working but for the last 11 days all the connectors have been failing with the following message on all: "Domo is ready, but Facebook reported an error: Object with ID '1798614167058474' does not exist, cannot be loaded due to missing permissions,…
-
Importing a CSV using SFTP and double quotation marks to isolate the data
Hi, this is a bit of an odd question but will do my best to ask it. I have a CSV file i am pulling for a SFTP, the file is in a CSV format and pulls the headers and first cell but it stops. After each comma the data is wrapped in double quotation marks, for example: 12328354,"User Name","1","Company Brand, Town" from that…
-
How to calculate a ratio like 2:1
Hello, been looking at this one and cannot see how to make the calculation in a ETL or Beast Mode. What I am trying to achieve is a ratio or products sold, for example we sell 2 used and 1 new i want to display a ratio of 2:1. Is this possible? In my data i have the following available: 1) N/U = Text value of New or Used…
-
Email connector importing CSV file but keep having the error 'specified file type'
Hi all I have setup an email connector, its suite a simple one that my stocking system emails domo a csv file of all our stock in csv format. I can see the email landing in my outlook and can see there is a file attached and too is a CSV file. But when it lands in the DOMO email connector i get the following email message:…
