-
Dataset View
Can you schedule a view to run daily?
-
What are best practices for combining huge datasets in Domo?
We have been using Domo for nearly a year now and are heavily utilizing DataFusion and Dataset Views to accomplish joining dimension tables to our primary fact tables. By the time we have joined everything we need, it is not uncommon to be looking at 300-800 columns and 50-100 million rows across 5-6 datasets. We often see…
-
What would be the downside of using Appended Data to capture M/M snapshots?
What would be the downside of using Appended Data to capture M/M snapshots? Let me explain. My EVP of Services wants to see Month over Month or Quarter over Quarter closure rates for client projects. My thought was to pull the project data from SFDC and simply COUNT projects in status 'Closed', and then the Appended data…
-
Need Advice on Approach: Producing "... to date" comparisons when data granularity is mixed
Ok... this is a mind bender for me, and maybe that's because I'm too close to it... (forest for the trees). Hoping the Dojo can come to the rescue and point me in the right direction. Here's the business question: How can I see how our sales are performing to plan and vs prior year? (YTD, MTD - and including vs the same…
-
Is there a way to combine/transform a Date&Time column into Domo?
So I've built a data set in another program, Midas, that I created a workbench job for and pulled it onto Domo. It has columns such as "IP Start Date" and "IP Start Time" and similar for discharge times etc. An end user is wanting to see patients broke down by Admit date, military time, and specific length of stay like…
-
How do detag a column
I incorrectly tagged a column in a dataset... is there a way to remove the tag? When I click on it, it doesn't allow me to do anything...
-
Quick way to determine number of unique values per column
I have a dataset with over 400 columns... and long story short, there are basically duplicate columns (4 different formats for each field) and I want to select the ones where there are actual values (as opposed to blanks or nulls). Is there a quick way to do this in Domo without manually having to go through? Maybe via…
-
Can I search for column names across all datasets?
How can I search ALL datasets for a word in the COLUMN name? For example, I want to see all datasets with a COLUMN name containing *address*. Search on the Datasets screen only searches within the dataset names.
-
How to use "IF" formula (like in excel) in DOMO
Hello guys! I have a database with information about customers, and their payments (1st payment, and Net_value). Each customer have a type of subscription, and each subscription have a specific rule. So if my customer is the subscription "A" i need to use the "1st payment", and if the customer is the subscription "B" i…
-
Combining Rows of Data with a common attribute
Hi, I have a dataset which is product data cross multiple years. In some cases the same buyer bought the product in year 2022 and year 2021 and I want to roll this up into 1 line. How do I do this automatically, matching on the word 'Buyer C' (because it's not feasible to manually match them with the size of the data) Any…
-
How to group data?
Does anyone know if it's possible to group data in DOMO. for example, my data is showing like this: but will like for it to look like this:
-
Find Datasets with No Cards & that are Not Used as Inputs (dataflows, dataset views, fusion, etc)
I'm working on a card to identify unused datasets. Datasets that meet the following criteria: No cards powered Not used as input in any other dataflow (ETL, Fusion, Dataset Views, etc/all types) I did find "Datasets" & "Dataflow Details" (Domo Governance Datasets Connector) that have most of what I want but does not…
-
Data Type Reference in Datasets
So I have been digging for a bit and I found a few threads that list the data types available in a dataset. But all the information seems to be embedded in other items. See this post https://dojo.domo.com/main/discussion/44484/datatype So I am looking for a very simple table that shows the data types available in domo.
-
Issue in creating pivot table
-
Change a Dataset and Replace All Downstream Processes With It?
Hi everyone, I'm working on updating some datasets in a new workflow. My example is switching from a dataset using an ODBC WB connector to a Microsoft SQL Server Connector. Is there a way I can change the dataset over (including all ETLs not only cards etc)? Either UI or API? Thanks,
-
Calculating percentage corresponding to blank cells
Hi all, I want to calculate percentage of the events count in my dataset like below Here, we can say for the month of August, there are 67 events with flag=true. Hence, we can see 100% displayed next to it. Similarly, for the month of September, there are 3 Outcome2 events with flag=true. And the percentage comes out to be…
-
Filling blank cells with 0
Hi Team, I've recently started domo to build reports and I'm trying to fill 0 in below blank cells in one of my reports. The thing is, in my dataset there's no data for August month for the highlighted rows. I believe that's why I see blank in Domo. Till here it's fine. Now, I'm trying to display 0 in these blank cells.…
-
Is there a way I can edit user's access to only see their locations data on my master card?
I would like to edit the access for users when I share this card, instead of creating a location filter.
-
Dataset/Card Certification History
Hello, I was wondering if there is any location in Domo where one can go to to view the history of a dataset and its certification status history. For example I have Dataset A and it is currently certified but a change was made in the ETL and it now has an expired certification. I now need to resubmit the certification for…
-
Filter a specific measure
Hi, say I am using a vertical group bar chat. For Y axis I want to show measure A (includes country A-Z) and Measure A with a specific filter say only country A, B, D. How should I go about it? as when I put country as the filtering, it just filters both bars
-
How to join to a table multiple times?
I'm struggling to replicate a simple type of join my company does all the time in SQL Server within a Domo DataSet view. Perhaps this isn't possible to do yet. I'm hoping someone can help out. Attached photo which has most of the complexity removed, but shows what I'm trying to do. We see "Transactions" in one table, and…
-
Table of contents on dashboards
On a dashboard, is there a way to create a table of contents showing what kind of sections or metrics are available here without having to scroll through the entire page? Not having to create a text box card at the top manually. when clicking on one item in the table of contents it automatically scrolls down to relevant…
-
Avg. Time between purchase orders
Hi, Domo newbie here. I am trying to find the average time between orders. The columns I have are Customer ID First Purchase date Last Purchase date Time between purchases I tried to using the group by function to find the average time between orders, but it seems to be returning the same value as the 'time between…
-
Outgoing email address
Hi, Sorry another question. I can see you can white label and brand scheduled reports users might setup. Can you also use your own SMTP server and change the from address as it wouldn't be ideal if the emails came from a domo address. Thanks
-
Example Dashboards
Is there a group where you can see sample dashboards?
-
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?
-
UK maps - long/lat
I'm looking to setup a UK map which shows the location of each site around the UK using long/lat, is there a specific way that I need to format the long/lat numbers as no data is showing with the data that I currently have? Thankyou
-
Increase timeout time to connect to API - JSON No Code Connector
I'm looking to connect to an API using the JSON No Code connector, the api takes about 40-80 seconds to generate the data. Is there a way that I can increase the timeout time in order to pull the data through?
-
Is there a way to count totals of unique combos within a pivot?
I have combined a few documents that have created duplicative shipping bill amounts due to unique identifiers that were part of the same shipment. I need to keep the rest of the data in rows that contain duplicative shipping bill totals but can't get a SUM of the UNIQUE bills. One extra complexity is that there are 10k+…
-
How do I create a rate with 1 row of data then filter it by unique cells of another row?
I'm pretty new to Domo and work in healthcare but essentially I have an excel style sheet of data. In 1 of the rows is the list of different admitting providers and in another row it specifies if the patient was inpatient or observation. There is a column/unique account number for every patient in this data sheet. I am…