1 Reply Latest reply on Oct 10, 2012 3:15 AM by Andy Cotgreave

Null values in dashboard filter

Hunter Schimpff Oct 9, 2012 2:31 PM

I am trying to represent data points in different performance categories for schools over a two year period. One school has a N/A data point for year 1 because it didn't exist.

When I build my dashboard, "Null" appears at the top. I'd like to get rid of Null from my filter, but still be able to see year #2's data point for that school if it is selected.

I think Null is appearing because of this 1 school.

Any suggestions?

1. Re: Null values in dashboard filter

Andy Cotgreave Oct 10, 2012 3:15 AM (in response to Hunter Schimpff)
Try this:
Right click on School in the Data Window and select "Create Set"
In the set, exclude the Null school
Now drag the set onto the Filters shelf on your view
You should now find that the Null school is missing and has also disappeared from your filter.
Like Show 0 Likes(0)

Actions

Tableau Community Forums

Null values in dashboard filter

1. Re: Null values in dashboard filter

Actions

More Like This