How do you group data by percentile in Tableau, ignoring nulls?

Question

How do you group data by percentile in Tableau, ignoring nulls? How to ignore nulls?

Answer 1

Hi Vaibhav,

You can group the column data into null and not null and then perform percent of total on the fields in the table.

1. Create a calculated field to group the column data as below. (Here Order id is the column i want to check for nulls, similarly you can give any attribute/measure )

2. Then use the group to display only those with Not Null by excluding them.

3. Now perform quick table calculation to find percent of total.

Hope this helps you.

Interested to learn about Tableau from top experts? Enroll in Tableau Course to get expert guidance.