How to ignore null values in your chart

0 votes

I am trying to bin my data based on Age in Tableau. There is a skewed distribution in my age column and I would like to group my data based on percentages. Here is the code that I have:

IF [Age]<={FIXED :PERCENTILE([Age],.2)} THEN "<20th" 
ELSEIF [Age]<={FIXED :PERCENTILE([Age],.4)} THEN ">20-40th"
ELSEIF [Age]<={FIXED :PERCENTILE([Age],.6)} THEN ">40-60th" 
ELSEIF [Age]<={FIXED :PERCENTILE([Age],.8)} THEN ">60-80th" 
ELSEIF [Age]<={FIXED :PERCENTILE([Age],1)} THEN ">80th" END

I was looking at the counts of my dataset and it looks like the count distribution is equal. This is how it looks like:

Age distribution count

It looks like I am getting an equal distribution of ages because I have null elements. How can I remove all the null values when I am generating this graph?

Aug 20, 2018 in Tableau by AwesomeSauce
• 860 points
3,013 views

1 answer to this question.

0 votes
If you right click on the bar for your "Null" age bin and hit "exclude" that should remove that bar from your graph by filtering out whatever data qualifies for that bin, assuming that is the intended result.

If that isn't the intended result, then you likely have null values for the Age column in your actual data source. To confirm, right-click on the Null bar and hit "View Data" and click the "Full Data" tab. It will show a more detailed view of what the data from the source actually looks like.
answered Aug 20, 2018 by Nitish
• 630 points

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
3,102 views
0 votes
1 answer

In Tableau, how to pass measure/dimension to action filters that are not in the chart?

Hi Sindhu,  You can choose the fields that are ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
5,573 views
0 votes
1 answer

How to show percentages on the slices in pie chart in Tableau?

Hi sindhu, You can manually move the labels ...READ MORE

answered Mar 13, 2019 in Tableau by Cherukuri
• 33,030 points
11,743 views
0 votes
1 answer

How to have some values in filter to be static and some to be dynamic

Hi Nithin, 1. You can form group ...READ MORE

answered Mar 18, 2019 in Tableau by Cherukuri
• 33,030 points
594 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,925 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,616 views
+2 votes
1 answer
0 votes
1 answer

How to reduce time taken to compute filters in Tableau?

You can apply the context filtering before ...READ MORE

answered Aug 20, 2018 in Tableau by Nitish
• 630 points
1,630 views
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 8, 2018 in Tableau by Nitish
• 630 points
1,035 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP