Skip to main content

Show Rows with No Data

By default, Holistics will not present items with no data when exploring the dataset.

For example, you have 2 models users and orders, the relationship between them is 1 to many. If you want to understand how many orders each user has, you will add in 2 fields: users.name and count(orders.id). However, we will exclude users that have not made any purchases.

The Show rows with no data feature let you include data rows and columns that don't contain measure data (blank measure values).

Show Items With No Data

How to set up?

In order to include items with no data, you can toggle on the option Show rows with no data  under STYLE > Others in our Visualization Settings. Please refer to the video below:


Let us know what you think about this document :)