Is there a way to create a chart that displays the percentage of null values across all datasets?
Best Answers
-
There isn't a simple way to get the total percentage of null values within your entire data warehouse. You could utilize a scripting language to query a list of your datasets then using each dataset ID you could query each dataset with the query endpoint and have it count the number of values in each. This would take time to query each dataset depending on the size of each dataset and the number of datasets you have.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hm. Perhaps you could create a template magic etl with a new column “Null Counter” you could add a column that uses the ifnull(column name, 1)? Then on that column name you could sum all rows that are 1, etc. You’d have to run every dataset you got through this etl example but perhaps it could work. Not easy necessarily, just an idea. :/
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0 -
I wonder if you could reach out to support to get them to give you at least a one time report on this. You can see the null percentage on a dataset when you go to the stats view on the data tab, so the information is there.
It could also be worth submitting an idea in the Ideas Exchange as a Domo Stats/Governance dataset to include this information.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
There isn't a simple way to get the total percentage of null values within your entire data warehouse. You could utilize a scripting language to query a list of your datasets then using each dataset ID you could query each dataset with the query endpoint and have it count the number of values in each. This would take time to query each dataset depending on the size of each dataset and the number of datasets you have.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Hm. Perhaps you could create a template magic etl with a new column “Null Counter” you could add a column that uses the ifnull(column name, 1)? Then on that column name you could sum all rows that are 1, etc. You’d have to run every dataset you got through this etl example but perhaps it could work. Not easy necessarily, just an idea. :/
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0 -
I wonder if you could reach out to support to get them to give you at least a one time report on this. You can see the null percentage on a dataset when you go to the stats view on the data tab, so the information is there.
It could also be worth submitting an idea in the Ideas Exchange as a Domo Stats/Governance dataset to include this information.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive