5 Replies Latest reply on Jun 27, 2014 8:17 AM by bart.groots

Convert Null/Blank values to 0s

yingyingchen0 Dec 5, 2012 11:19 AM

i have a tableau workbook attached which I want to keep show which web_id for which service have null or 0 impressions values. I have tried several ways, including ZN, isnull, ifnull, iif(isnull([Impressions]),0, [Impressions]), and then tried to filter those have null/0 values, but none works.

Anyone can help here?

keep null data.twbx.zip 77.9 KB

1. Re: Convert Null/Blank values to 0s

Alex Kerin Dec 5, 2012 3:02 PM (in response to yingyingchen0)

What is your desired output from the data you provided?
Like Show 0 Likes(0)

Actions

2. Re: Convert Null/Blank values to 0s

yingyingchen0 Dec 5, 2012 3:14 PM (in response to Alex Kerin)

i want to show something like below, so i can easily tell which web_id is missing what service of impressions.

i also attached the data feed below, i pulled the data from SQL, or there is a better way i should pull the data?

	SERVICE
WEB_ID	maxpoint interactive video	Specific Media
gmps-abel	NA	12
gmps-advantage-il	NA	32,608
gmps-advantagechevy	NA	4,136
gmps-babe	NA	4,798
gmps-baird	NA	19
gmps-bale	NA	1
gmps-bankston	NA	1
gmps-beardmore	NA	1
…
gmps-young	NA	51
gmps-zanesville	NA	162
gmps-vandevere-chev	25,627	NA

BTW, the data feed looks like:

WEB_ID	service	impressions
gmps-state	maxpoint interactive video	410
gmps-country-il	maxpoint interactive video	528
gmps-homan	maxpoint interactive video	542
gmps-emerson-in	maxpoint interactive video	646
gmps-midway-pontiac	maxpoint interactive video	787
gmps-schimmer	maxpoint interactive video	999

......

gmps-state	Specific Media	1
gmps-country-il	Specific Media	3,155
gmps-homan	Specific Media	6
gmps-emerson-in	Specific Media	799
gmps-midway-pontiac	Specific Media	33
gmps-schimmer	Specific Media	9,677
gmps-harvard	Specific Media	242
gmps-riverside-il	Specific Media	2,435
gmps-billwalsh	Specific Media	203
gmps-roger	Specific Media	3,742

3. Re: Convert Null/Blank values to 0s

yingyingchen0 Dec 6, 2012 10:33 AM (in response to yingyingchen0)

I have found a way to do this myself. Thanks everyone for help. Not sure if I should close this question and don't know how.
Like Show 0 Likes(0)

Actions
4. Re: Convert Null/Blank values to 0s

Diego Ibarra May 16, 2013 1:23 PM (in response to yingyingchen0)

Tell us about the answer.
Like Show 0 Likes(0)

Actions
5. Re: Convert Null/Blank values to 0s

bart.groots Jun 27, 2014 8:17 AM (in response to yingyingchen0)

thanks for sharing
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Convert Null/Blank values to 0s

1. Re: Convert Null/Blank values to 0s

2. Re: Convert Null/Blank values to 0s

3. Re: Convert Null/Blank values to 0s

4. Re: Convert Null/Blank values to 0s

5. Re: Convert Null/Blank values to 0s

Actions

More Like This