-
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.
-
relating beastmode IDs between datasets
relating beastmode IDs between datasets Hello! I am having trouble relating beast mode ID between two datasets: the user logs and a Beast mode dataset available via the Domo governance dataset connector (https://domohelp.domo.com/hc/en-us/articles/360056318074-Domo-Governance-Datasets-Connector). In the "beast modes with…
-
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!
-
Confirmation Notification after resolving 'Failed to Load Data for ...'
Depending on your settings and business structure, there's notifications that get emailed out whenever a dataset fails in updating. Most of the recipients of these emails wouldn't be technical/in Domo backend and so it would be nice that when a dataset is able to import/connect again, a confirmation notification is then…
-
Period-Over-Period % Change in Multi-Value / Single Value Gauge
Hi all, Still new to DOMO (4~ months) so just learning the ropes. Please point me in the right direction if this is posted incorrectly or if im possibly not understanding something! I'm trying to accomplish a simple Period-over-Period % Change calculation and it looks like this is an ongoing question/problem and I…
-
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…
-
Links to Input/Output Datasets in Magic ETL Editor
Oftentimes I find myself having to open a new tab to navigate to the various input and output datasets when in the editing canvas for a Magic ETL. It would be nice if there were a link that would open the dataset in a new tab somewhere on the configuration dialog that appears after selecting the tile.
-
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?