-
API and download large dataset
Hello -- I need to extract data from a 20M row dataset. I can download smaller datasets, but when I try to download a large dataset, I get a timeout. Can I apply a filter (like date) to the download request for the larger dataset? Thank you
-
Number of dashboard visits
Hi! I am facing an issue, and I wondered if there is a way to solve it. I manage many dashboards, and the client wants to see how many users visit them. I know there are five datasets belonging to DomoMetrics, but none deal with the dashboard visits, so the DomoStats cannot help me either. I am saying this because I…
-
Report to show how many cards use the same specific dimension
Hi Dojo - Good Day! Just wondering how I can create a report in DOMO to show how many cards use the same specific dimension in one dataset. for example, I have a Employee Information Dataset and I want to know how many cards use the dimension employee ID Thanks In Advance!
-
Historic Timesheet Analysis
I'm working on an analysis of our historic timesheet data and trying to calculate our employee utilization (actual hours per day/8), so that we have a historic benchmark and can compare to projections for future utilization. The challenge I'm running into is actually cleaning the data. It's generally well-structured - in…
-
Moving one column under another
I have a table with 5 columns: column 1 is an ID, columns 2 and 4 are codes, and 3 and 5 are corresponding names. I need all the codes in one column, and all the names in one column. These means each ID will now have 2 rows, one for each code/name. How would I go about moving data from one column to another in Magic ETL?
-
Take large text input as field for filtering?
I have a slicer card to filter zip codes for a large data set. There is a search bar field for finding zip codes to filter by, but say I had a large list/string of zip codes and I wanted to select all of them for filtering. Is there a way to paste this list into a search field to filter them all, instead of selecting each…
-
Set default formatting for a field (on cards) on the dataset
I hate adding currency fields to cards in DOMO, super frustating.. EVERY time I have to do this: format Set currency to $ remove decimal places I'd like to set this once (as a default) at the dataset level.. then be able to override in card if I need to.. Save so much time..
-
ZIP code leading zeros being removed in dataset
I have a dataset and one of the columns is ZIP codes. The leading zeros are being removed when uploaded to DOMO. Any way to change the column's formatting or to prevent the zeros from being truncated?
-
Is Certified Field
Hi Team, It would be great if we have a field to track if a card and Dataset is Certified or not? Thank You, Kiran Cheruku
-
How to group rows and make columns that count specific values?
Hi! This is a difficult one to give a title but basically, here is what I am trying to do: I have a dataset that combines a dataset of user profiles and a dataset of our assets that are assigned to each user. What this does is make it so every single entry for a user's individual assets gets its own row. So basically, if…
-
How to remove a decimal in an area dimension column?
I have a column that showing the dimensions of a unit. 5x5, 5x10, etc.. the column is in a text format and the data is coming in to Domo in a strange way, it looks like: What I want is just the more standard: 5x5, 5x10, 5x15, etc.. In the ETL how could i get rid of the .0?
-
Maximum Number of Rows that Can Be Displayed on a Card
In a card, the data display is limited to 100,000 rows, but if the DataSet has 1,000,000 rows of data, does anyone know which of the following will happen? 1) If the data after filtering is within 100,000 rows, it can be displayed normally. 2)Regardless of the content of the filter, the error of over 100,000 rows will be…
-
How to find number of data sources and magic ETL used in Dataset
Hi Team, We are trying to create a report with list of datasets with data sources used in that data sets and magic ETL used in that data set. Is there any way to pull this information ?
-
How can we find data sources and magic ETL used in dataset ?
Hi Team, How can we find total data sources used in our dataset with all magic ETL used for that data sources ? Is there any way to pull datasources and magic ETL used in data set ?
-
More easily jump to a Dataset's Dataflow
When in a Dataset I want to easily jump to the dataflow that created the Dataset. It's sort of hidden over here. Why not move the "Edit Etl" down to this section?
-
See underlying data sources for a dashboard
**posted in wrong topic but leaving up because of the answer** I'm looking for a quick way to go to a dashboard and then find out which data sources are being used for any of the cards on that dashboard. If that dashboard has something like 20 cards it would be nice to be able to see a list of the data sources used. I know…
-
See underlying data sources for a dashboard
I'm looking for a quick way to go to a dashboard and then find out which data sources are being used for any of the cards on that dashboard. If that dashboard has something like 20 cards it would be nice to be able to see a list of the data sources used. I know I can go to the data source, and then see which cards it is…
-
How do I get support for the Workfront data connector
I have a connection to workfront that has stopped working. The history suggests reaching out to Workfront, but workfront said to contact domo. I guess the connectors are supplied by third parties? I haven't been able to google up the identity of the third-party provider. Also, was unsuccessful in creating a Domo support…
-
How do I open the datasource editor
I'm trying to edit a dataconnrctor by following the directions for 'Editing a Datasource from the home page' found here: https://support.google.com/datastudio/answer/7178497#zippy=%2Cin-this-article. (1) Sign in to Data Studio. (2) At the top of the Data Studio home page, click Data Sources. (3) Browse or search for the…
-
Trying to condense / group rows to remove nulls, any help appreciated
Hello, I am working on a data flow that needs to perform various substring functions to isolate data from a large xml string. I have gotten it close, where the data is linked to the log / time / user in in the sql database, and i am able to separate values into appropriately named columns. I would like to know if/how to…
-
Governance datasets with Dataset source name
Hi , we are using the azure gen2 data connector, is there a governance dataset that contains directory name and Select File name . so we are not duplicating the same dataset twice. i have looked in the Gov Datasets and i cant find any field that relates to the settings section.
-
Google sheets alternative? Migration Strategy
We have been on a google based email platform since getting DOMO, we have utilized the google sheets connector to connect and import several datasets for ETLs and cards. We will be migrating away from google based email and will have Microsoft office 365 moving forward. Admittedly, I don't have much of exposure to anything…
-
Historic Gas Price Datasets
I'm looking for a dataset that has historical gas price averages at a state or county level. I was able to pull in National level data but I'm looking for more granularity to create something similar to Gas Buddy or AAA's heat maps.
-
Overwriting an Existing DataSet with Workbench
In our team, we have a couple of engineers developing in Workbench on different PCs. When I exported a job from one Workbench, imported it to another Workbench on a different PC and ran it, another DataSet with the same name was created. Is there anything I can do to overwrite and update the existing DataSet?
-
Data Warehouse Summary Values
Can someone tell me what is counted as 'DOMO MAGIC DATA' in the summary metrics shown in the top right of the data warehouse screen? I've read the documentation on the Data Warehouse page and watched the little video but it doesn't specify what that is counting. I originally thought it was dataflows so I created a test…
-
Deleting a batch
I have 2 batches in a dataset that need to be deleted. The batches are easy to identify and the 2 just need to be wiped out entirely. I am wondering if it is possible to just go in a delete a batch, and what would be the best way to do this?
-
Configuration Options for Dataset Copy Dataset Connector
I need to copy a dataset from one instance to another. On the first run, I need to copy the entire dataset. Subsequently, only the new/delta data in the source needs to get appended to the dataset in the other instance. I would like to avoid loading a complete refresh to the destination dataset every time new data is added…