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:

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 2,794 views

## 1 answer to this question.

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
• 630 points

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

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

## 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

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

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

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

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

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

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

## How to Link Dashboard with URL to enable it to open in the same explorer page

Add this to the end of the ...READ MORE

## Calculated filed with if-then

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

## How can I download tableau workbook with its data from tableau server?

In essence, no. Since the workbook is ...READ MORE