-
Google Analytics Advanced Connector - User count does not match with GA
I'm using the Google Analytics Advanced Connector and I can't seem to get the correct/exact count of Users when comparing to Google Analytics/Data Studio numbers. I'm aware that Google Analytics aggregates the Users differently compared to the Sessions/Pageviews depending on my selected dimensions (i.e. in order for me to…
-
Alerts not sharing in Buzz channel for specific datasets
I have alerts set up and shared with a Buzz channel on several cards but the alerts only post to the channel for specific datasets. I still receive the notifications regularly otherwise. Does anyone know why this is happening? The data and card permissions are all the same.
-
Data Stuck in "Storing" Mode
Hi All, Domo went down for a second earlier today when it came back up it appears that some of our datasets are stuck in storing mode. I was wondering if anybody had any experience troubleshooting this issue.
-
Adobe Analytics OAuth 1.4 connector - Update a dataset hourly
-
Email connector not finding link
Hi there! According to the KB article for the Email Connector this should be working correctly, but here I am :) I receive a nightly scheduled XLSX report from a third party reporting tool. They recently stopped attaching the report to the email and instead put it a link to a page which then downloads the file from AWS.…
-
Datacenter Autotags: Manual vs Scheduled, Append vs Replace
I have been trying to have the discipline to tag my datasets as I set them up or adjust them, based on these important major categorizations: Scheduling: MANUAL vs SCHEDULED Update Type: APPEND vs REPLACE It would be excellent if Domo could auto-apply the appropriate tag based on those attributes, upon creation/update of a…
-
How can I compare YOY data with an offset of a couple of days?
Hello, I'm 100% new to DOMO and I'm looking for some assistance. I'm trying to compare data from 2021 against data from 2020 using DOMO with a dataset connected combining data from multiple Adobe Analytics sources, and other accounts. Specifically I need to compare promotional revenue data for a Memorial Day promotion. I…
-
How to add index number in the dataset
Hi Team, I have a dataset with around 1000 records. now I want to add one field in it name "id". it would be starting from 1 and end with 1000. I don't have an idea how to add it. Please suggest a better way. Thanks in advance :)
-
Workbench Job Hanging, Dataset stuck on 'Preparing'
I have a scheduled Workbench job to update a dataset that typically takes 30ish mins to run. The job started yesterday at 1:37pm and has been stuck on 'Preparing..' in the Result field (on the History tab) since then. I just canceled the workbench job and started a new manual run. It started a new run, but the history tab…
-
Asana Connector - Get hours allocated to a task
Using the Asana connector I have gone through all the available datasets and can't find the hours allocated to a task anywhere. Use case: Use Domo to create a table of team members's resourcing levels by hours on a daily basis.
-
How do I create a Merge Key for Azure Synapse SQL Connector?
We have a large dataset that we update daily, we want to change from the "Replace" update setting to the "Merge" setting. It asks for a "Merge Key Location" - the input field just continuously tries to load something How do we switch to the Merge update method?
-
Deleteing intermediary Dataset values after final OutputDataset
Hi I Am new to Domo we have a lot of very large etls that are broken down in stages. after each stage an intermediary dataset it created to the pont we have billions of rows in datasets that are only used as staging tables. my question is these tables take up space. once the final table is created, how can we delete all…
-
Linkedin Report
Hi Guys, Need your help, Does anyone know which connector I should use for "Linkedin Campaign Reporting". I am specifically looking for the below fields in my DataSet. Campaign Group Name, Campaign Name, Total Spent, Impressions, Clicks, Leads, Cost per Lead, Reach, etc
-
Does ETL Support the 'IN' Function in a case when?
Does ETL Support the 'IN' Function in a case when? Does anybody know if this is possible? I'm getting an error I just want to make sure that it's not my syntax.
-
Aggregating Rows
I have a dataset that breaks everything everything out by rows. any time there is a rental, or vacate it adds a value in to a new row with a siteID for a store. the data refreshes on a daily basis, so it site 3196 has 4 rentals in a day it would repeat site 3196 on 4 different rows with a value of 1 in the rental column…
-
Export very large dataset (million or row) in CSV as chunks
Is it possible in DOMO using python or postman to export whole dataset but break files(CSV/Excel) so we can have 5 million rows in each exported file.
-
Is it possible to use while/do loops in MySQL in Domo Dataflows?
I have data that has varying rows of data for each identifier, from one row to 26. For each identifier, I have four different columns that change with the various rows. For each new identifier, I want to loop through the rows that follow that have the same identifier and build the row out with the unique values in these…
-
Joining or Appending Data Help
I have a dataset (dataset 1) with individual rows as a specific job (with an identifier key) with details including year and country of operations. I have created cards to show the total number of jobs per year. I have another dataset (dataset 2) which shows historical revenue by Year and Country but it is not specific to…
-
Unique Values Pulling Through twice
I've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my columns there is a value labelled "Test". For some reason it is pulling through as two unique values when it should only be one. I have tried to use 'replace text' but whatever I replace it with it pulls through again as two…
-
How can we use similar function as Vlookup??
I would like to offer a volume discount price for each company A, B, C and calculate total biil. There are 2 datasets like the below. When we sell 250 of Products to Company A in 2021 Feb (Dataset B), I would like to apply Price 4 USD on the price list for Company A (Dataset A). Then the total bill will be 1000 USD. If…
-
How to implement commands from the Command Line Interface Tool in Python, specifically api requests
Question: Is it possible to execute command line interface tool operations within Python, specifically the 'list-dataflow' command? Elaboration: The 'list-dataflow' command in the command line interface tool returns JSON structured metadata for a dataflow. My guess is that this command is just making a GET request to a…
-
Avoid BeasMode Duplication in Bulk Switching cards
Hello everyone I want to try Switching all cards powered by a DataSet in Domo. This dataset is a really important one which has around 5000 cards, and many of our important reports and beastmodes are there. So I don't want to mess it up!. I created an identical dataset with same column names and I read in Domo Knowledge…
-
Is there away to pull the Ticket updates dataset in Zendesk using any othe the Domo connectors?
I've been working with the Domo Zendesk Support and Zendesk Support Upsert connector with almost not problem to the the data I need with exception of the Ticket updates dateset (https://support.zendesk.com/hc/en-us/articles/360022182114-Metrics-and-attributes-for-Zendesk-Support#topic_sq4_mhq_4y). Has anyone had any luck…
-
General question on data from different datasets on the same card.
I have a card that is on a finished page. There is another metric that I want to add to a specific card that already has data displayed from a single dataset. This new metric is in a completely different different dataset that isn't attached to this page at all. Is there a way to pull in this metric to this card without…
-
How can I create a new column with extracted numbers in SQL or ETL
I have a column called 'description' which can contain multiple elements. One of them is 'Order #1234567890' (or other digits). I want to create a new column that just extracts the numbers in SQL or Magic ETL (so that I can do Beast Modes etc. on it afterwards). How can I create this column? Numbers may exist in other…
-
Exporting a dataset using script.
I want to connect to a dataset in my instance and download a dataset using a python script, how do I do it?
-
Import multiple files into single Dataset
Every day a new Excel file is dropped into a shared network folder. Every file is in the same format, and each file contains one day's data. Is there a way, using Workbench or any other method, to transport all Excel files from one local folder into a single Domo DataSet? Since a new file is added every day, every file…
-
Data Labels Font Color
I have some bar/column graphs that I would like to apply data labels with white font, instead of the default text color, for better visibility. Is there any way to do this? Thanks! Jamie H.