-
Lineage of a field
Hi in domo can you find the lineage of a field , as in all the data flows or data sets a field appears in .
-
How to calculate a % of line value from the grand total inside a table in domo card
I am trying to find the percentage of the cost of sales from the total cost of sales. I have used the following calculation in beast mode. (`Cost of Sales` / (SUM(`Cost of Sales`)) However, this calculation is not returning accurate values the lower cost of sales values have a higher percentage than the higher cost of…
-
Grouping data by month in table
Can someone advise on how I can create a table which groups the data so it is one month for each row? I tried Group by and it just formats the date column fields to the month-year. But continues to track each individual date separately.
-
Splitting up multiple-value fields into multiple rows
Hello, I have a dataset like this: ID Num 1 10 2 20, 30 3 40, 50, 60 I want to use Magic ETL to break these out so each row has one "Num": ID Num 1 10 2 20 2 30 3 40 3 50 3 60 Thank you
-
Views of Federated Snowflake Datasets
Last week, I created a federated connection to a table in Snowflake. I created a view off of that data set so that I could use it in Magic ETL etc. When I look back now, the view says last updated 7 days ago. There is no update button or update frequency for me to change. I want the view to be updated consistently as the…
-
Previous Months work
I'm running into an issue where I can get the amount of done work for last month but I need it to be shown this current month as previous months work to be able to calculate run rate. I have the correct code to get last months data. I'm using current date as a reference point so it's going backwards to look at last months…
-
I am trying to remove duplicates so that I only count the result of the last batch run
Hi can anyone tell me how to write the forumla for this? I tried to add a formula to the ETL but did not know what formula I would need as I wasnt successful with any I tried and I'm a novice! 😪
-
Reporting on a dataset e.g. duplicates, null values and data types
I was wondering if someone could help? I have a dataset containing 196 columns, I would like to know which of the columns are entirely null, which contains data, what level of duplication the field has and what type of data is in the field. There is a similar question here, but this is more about removing as opposed to…
-
How to get the time difference between completed and originated on 8 hour shift minus weekends
-
Datasets join issue
I'm trying to create a card that can be used to present to budget owners how much they have currently spent for the month compared to the budget they've been given. In order to do so, I have to create a dataflow that involves joining 2 datasets; One is Netsuite, which stores all the journal entry transactions, and the…
-
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