-
Calculate Previous Year metrics in DOMO
I have a requirement to calculate previous year's data (in monthly format - Month Over Month). So if user selects Fiscal year 2023, he should be able to get data for 2022. Only catch is that 2023 means Oct-22 to Sep23. So 2022 would mean data comparison between Oct-21 to Sep22. Any help would be greatly appreciated.
-
Filter Cards List by Dataset
As admin, I would like to be able to manage large groups of cards by dataset. Currently the cards view can be filtered by owner and/or page but not the dataset, which would help me manage the content of a particular dataset more easily.
-
Is there a way to create a chart that displays the percentage of null values across all datasets?
I want to know the percentage of null values across all datasets that we have, I am not interested in one particular dataset, I want to know the overall percentage.
-
How to erase all contents in a dataset without deleting the dataset
Hi, I have a data connector through the "DataSet via Email Connector" that reads the attachment from an email. I need to empty the dataset without having to change the email address. Does anyone know how to do it? I can delete this dataset and recreate one but I would prefer to keep the email address to avoid additional…
-
Sankey & Sankey Path Data Structure
Hi all, I am building a sankey chart to show the flow of transactions. Ideally I would like to use the Sankey Path visualisation. My data is structured with column names: from, from_type, to, to_type, value There are 4 stages to the flow. I would like to be able to filter the visualisation to show the flow for certain…
-
Demo Slam: Dataset Access Requests
Hi All! Hope you enjoyed my demo in the first ever Domo Demo Slam today. Here is a link to it if you missed out: As promised, here is the step-by-step write up to replicate what I've done in my instance. Enjoy! P.S. this is version 1, version 2 will include more data exploration options for end users. 1. Set up the Domo…
-
Dataset Groups
I would love to see a more organized way to group datasets together and limit the number of datasets that are in view during a search. We have too many datasets with similar names and it gets difficult to find them sometimes unless you remember and search the full name.
-
Is possible to made a "not in" condition in PDPs?
Usually I use PDP giving access to some areas, but for exceptions I can not just give access to everything, like Employees of Area A but not access to a specific employee out of 300 is posible to use a not in for a PDP?
-
Comparing Datasets to Determine Variance
Hello everyone, I am working on comparing data from a previous data input, Universal Analytics, to a new one, Google Analytics 4. Basically, there was an update and data is formatted differently. I am attempting to join the two datasets to compare the month of A ugust for variances, but the closest thing to a unique column…
-
Mimic Vlookup in Dataset?
As the title says, I am trying to mimic a vlookup on a dataset. I am using an ETL that is connecting different membership logs from SF. Basically every time a member leaves or joins it creates a new log. On one dashboard we are looking at data based on all the members who joined this year but also left this same time…
-
Dataset to display the underlying DB table/view in Overview Tab
It's good to know the underlying databse table or view on which the dataset is created in order to backtrack any issues. In case developer of the dataset leaves role/org it's difficult to find the datasource table/view name.
-
Warnings for Exports w/ .xlsx that are over 100,000 lines is Gone - please reimplement
For the first 3 years at Domo there has been a warning about exports over 100,000 lines for .xlsx saying "there are possibly missing lines of data as you have reached the max data exported via .xlsx." The issues for us here is that people are going to be working with large data sets and then never know that data is…
-
Data transformation ideas around old/new user data
HI, we're migrating from username sign in, to okta that uses email as user id. we have an existing user info data with user id as username (xfsgsbss) but we would have a new data with user id as email(fdhsvbsjsbsjsh@email.com). I want to be able to join both old and new data and make sure the right attributes goes to them,…
-
A way to identify/report on hidden datasets
Found out that when users add certain full service apps from the appstore to your instance, it can result in "hidden datasets" existing in your platform. These datasets aren't visible in the datacenter, nor do they appear on any Domostats reports. Per support, Domo has an api endpoint that can be searched by dataset owner…
-
How to create a rate by specific selection criteria in Domo
Hello again community. So I work within a healthcare organization and I have a domo grouped/stacked bar graph built currently from an etl that has columns regarding patients readmission start date, account number, discharge date and attending providers(previous admission). The card breaks down the readmit percentage rate…
-
Effect of DataSet View Calculated Columns on Performance
I want confirmation that if I shift over a bunch of dataset view calculated columns to run in the dataflow instead of on the dataset view that I can potentially boost the performance of my dashboards. Currently, the dashboards run okay, but filtering takes a while. The dashboards are heavily leveraging COUNT(DISTINCT()),…
-
Does the API's dataset/export method work?
I'm building a PHP client library for Domo, and I'm currently having trouble with one of the endpoints. Specifically: API Docs: Endpoint: /v1/datasets/{dataset_id}/data Method: GET According to the documentation, if I call that endpoint with the GUID of a dataset, it should return CSV content to me in the response body.…
-
Dataset ownership for users groups
Being able to designate groups and/or several people as owners of datasets, dataflows
-
Ways to visualize datasets impact beyond first level
The direct impact and total impact information (about datasets, dataflows, cards and alerts) is only available by consulting the elements individually in the Domo interface, however it would be very useful to have this data in the DomoStats tables. The main use case is for the platform owners to have a centralized place…
-
Is it possible to calculate ROAS and WoW change in the same beast mode formula?
I'm working on a pivot table and I want to show the % change of ROAS from last week vs. two weeks ago. My dataset does not contain a 'ROAS' column so I'm trying to calculate it within the WoW beast mode formula. If I breakout the formula below into two parts (LW ROAS vs. 2WA ROAS), the first part will correctly give me…