-
Can you remove duplicated rows of data in a data set?
We have a data set that is updated from a Google Sheet. I see that back in June we have duplicate entries for June 22 and June 23 in the data set, yet the data in the Google Sheet is not duplicated. Is there a way to edit the data that is in the data set to remove these duplicates?
-
Edit Calculated Columns in Saved Data Views
Once a calculated column is added and the data view is saved, it would be helpful to be able to go back into the view and make edits to the calculated column if needed. Currently a new column must be created and a new dataset view saved.
-
DataSet Copy
Does anyone know how the DataSet Copy Unload connector works?
-
YOY & Net diff Beatmode calc
I have kind of a unique YOY period that I am trying to create a report around. I am taking counts of leads that come through different marketing 'Marketing Sources', and only looking at the past 15 day window for each. This is straight forward. Take the counts for each source in the `Marketing Source` columns and use the…
-
Dataflow creation best practice and recommendation
A lot of the dataflow creation I do is taking 2 datasets that differ slightly and don't have an easy 1:1 comparison that makes joining the data very easy. usually I am using 1 report for almost the entire visualization, and puling a column or two form the 2nd report. Since the reports aren't in an identical format, and…
-
Dataset beast mode calculations
Is it possible to copy over beast mode calculations from one dataset to another? I have one dataset which is using most of the same fields from other dataset. I wanted to copy all beast mode calculations.
-
Google Ads
Hi Team, Does anyone know which connector I should use for google ads? Thanks, Yuvraj Chavan
-
Google Analytics Advanced Connector - dataset showing multiple rows per Month
I have datasets with Month of Year selected as dimension from Google Analytics Advanced Connector and I noticed that some of my datasets are producing multiple rows per month while some do not. When summing up the values, they do add up to the total except for averaged columns (i.e. Avg. Page Load Time, Avg. Session…
-
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…