Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in BI by (17.6k points)
How do you group data by percentile in Tableau, ignoring nulls? How to ignore nulls?

1 Answer

0 votes
by (47.2k points)

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.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Oct 16, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
asked Aug 27, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
0 answers

Browse Categories

...