12 Replies Latest reply on Jun 23, 2016 4:23 PM by Ivan Young

Hide Blank Cells

Gurpreet Singh Goraya Jun 27, 2016 8:54 AM

Hello ,

My Tableau worksheet has a lot of blank cells. I want to hide or suppress all blank cells/rows/column. Here is the screenshot of the worksheet. Please advise. Thanks

1. Re: Hide Blank Cells

Veronica Simoes Jun 23, 2016 1:43 PM (in response to Gurpreet Singh Goraya)

Hello,

Could you share the workbook ?

Bests

Veronica
Like Show 0 Likes(0)

Actions
2. Re: Hide Blank Cells

Gurpreet Singh Goraya Jun 23, 2016 1:46 PM (in response to Veronica Simoes)

Hello Veronica,
I am pretty new with Tableau and not sure how to share the workbook when connected with oracle data connection. Please advise
Like Show 0 Likes(0)

Actions
3. Re: Hide Blank Cells

Veronica Simoes Jun 23, 2016 1:52 PM (in response to Gurpreet Singh Goraya)

Hi Gurpreet,

Please extract a sample and save as TWBX

Bests
Like Show 0 Likes(0)

Actions
4. Re: Hide Blank Cells

Gurpreet Singh Goraya Jun 23, 2016 1:57 PM (in response to Veronica Simoes)

Thank you Veronica, I have attached workbook.
Like Show 0 Likes(0)

Actions
5. Re: Hide Blank Cells

madhuri.tanniru Jun 23, 2016 2:01 PM (in response to Gurpreet Singh Goraya)

Hi Gurpreet,

Could you please put the measure CNTD(BookingID) in the Filter shelf, and then from the Filter dialog, select "Special > Non-Null Values"

Please see if this helps

Thanks,
-Madhuri
Like Show 0 Likes(0)

Actions
6. Re: Hide Blank Cells

Gurpreet Singh Goraya Jun 23, 2016 2:06 PM (in response to madhuri.tanniru)

Sorry Madhuri, it does not work for me. All existing values disappear as soon I used special > Non-null Values condition. Thanks
Like Show 0 Likes(0)

Actions
7. Re: Hide Blank Cells

Veronica Simoes Jun 23, 2016 2:19 PM (in response to Gurpreet Singh Goraya)

Hi Gurpreet,

The data source need to be extracted.
So, Go to Data Menu , select de data source and click on extract data ...
After that, save as twbx.

You can choose a few rows to extract

Bests

Veronica
Like Show 0 Likes(0)

Actions
8. Re: Hide Blank Cells

Gurpreet Singh Goraya Jun 23, 2016 2:34 PM (in response to Veronica Simoes)

Thanks again Veronica, I have attached worksheet with partial data extract.

Gurpreet
Like Show 0 Likes(0)

Actions
9. Re: Hide Blank Cells

Rahul Ahluwalia Jun 23, 2016 3:06 PM (in response to Gurpreet Singh Goraya)

Looking at your partial data set, you do not have any blank rows. For each column, there is at least 1 row that is populated; thus, you cannot eliminate any columns. Likewise is true for rows. What exactly are you trying to accomplish in terms of metrics? Maybe there is a better way to approach the problem.
Like Show 1 Likes(1)

Actions
10. Re: Hide Blank Cells

Gurpreet Singh Goraya Jun 23, 2016 3:11 PM (in response to Rahul Ahluwalia)

Thank you Rahul. You are right. Maybe I will approach differently.

Gurpreet
Like Show 0 Likes(0)

Actions
11. Re: Hide Blank Cells

Veronica Simoes Jun 23, 2016 3:23 PM (in response to Gurpreet Singh Goraya)
Follow what i think you want.
You have to show Dropoffaddressname as a filter and select the option show only relevant values

Partialdata_solution.twbx 599.2 KB

4 of 4 people found this helpful
Like Show 3 Likes(3)

Actions
12. Re: Hide Blank Cells

Ivan Young Jun 23, 2016 4:23 PM (in response to Gurpreet Singh Goraya)

Definitely more readable when all dimensions are in rows.
2 of 2 people found this helpful
Like Show 2 Likes(2)

Actions