-
Adding values from two datasets
Hi, I'm looking to add values from two datasets into one value. One dataset is Completed panels in 2022, the other dataset is Completed awaiting power in 2022. What is the best way for me to do this?
-
Adobe Analytics JWT v2 Connector Multiple Segments
Hi, I'm wondering if there's any way to apply 2 (or more) segments to an Adobe Analytics report built through the JWT v2 connector. I realize a possible workaround is to just go and create a new segment in AA which combines the rules from the 2 or more segments, but this is not always feasible based on the number of…
-
Pendo connection: how to add a date column to a dataset?
Hello! I have created a Pendo connection to domo but a date column was not pulled over with the data. I was wanting to add a column to the dataset and put the date that the corresponds with the data but am struggling to do so. Does anyone have any ideas on how to do this?
-
Has anyone pulled data from ActiveCampaign?
I am working on getting data from ActiveCampaign into Domo and wanted to see if anyone has succeeded in this.
-
A connector more reports every report put data in a different dataset
Hi to all, i wish to have a connector where every report make a call to a different endpoint of an API so i wish that every report write the data in a different dataset. I know how to build different report but I havent found the way to put the data of a report in a specific dataset and the data of another report in an…
-
Comparing two datasets for missing sites
Hi, I'm looking to compare two datasets from Smartsheet to identify which sites are missing from one dataset. For example, show me all sites that are in 'Master Schedule' but aren't on 'Secondary Schedule', both sheets have identifying numbers in column 'URN'. What would be the best way for me to do this? Would I join…
-
How do I change the data from being horizontal to vertical using a calculated field?
My data is currently horizontal so each column has a different month with the totals below (example below). I would like the data to be vertical so that it is easier to display the data visually within domo. I have placed an example below. I am not sure how to make a calculated field to display the date and totals…
-
Workbench Job to DOMO stuck on "Connecting"
I have a workbench job that has been in the "connecting" state on the DOMO side for over 4 days. Is there anyway to kill it? The job on the workbench side has already been stopped.
-
Can someone give me DDX Bricks examples which use traditional SQL (using JOIN) to query?
I want to use traditional SQL to query to fetch data from database in ddx bricks. My sql query contains INNER JOIN. Can it be possible? If yes, please refer to some existing example ddx cards or give me some example where using join and access result parameters from array-of-objects format are explained. Thanks in advance.
-
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…