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! 😪
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…
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…
Can you schedule a view to run daily?
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? 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…
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…
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…
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...
It looks like you're new here. Sign in or register to get started.