How to remove NULL from tableau dashboard?

Hello Friends, I am getting lots of request on how to remove null from our view. So, today's blog is about that.

We are getting three types of null into data.

1) Null as measures.
2) Null in Dimension as String 'NULL'.
3 Null in dimension as Blank ''.

Below image is for the reference. If you see in other three sheets, we have remove all type of nulls one by one. If you get all three null in your data then apply all three steps.

Let's start, how we can get this done in our data.

1) Null as measures.

• Drag My Ranking measure to filter shelf.
• Select Non-null values from Special Tab from popup filter window.
• Hit Ok.

2) Null in Dimension as String 'NULL'.

• Drag Superhero Name dimension to filter shelf.
• Select Exculde and then the NULL values from popup filter window.
• Hit Ok.

3) Null in Dimension as Blank ''

• Drag Superhero Name dimension to filter shelf.
• Select Exculde and then the Null values from popup filter window.
• Hit Ok.

I hope this blog will be beneficial for you. If you have any question, please comment below.

Tableau New Features in 10.3

Hello All,

In this blog we will learn some of important new and very helpful updates, for that we were waiting since long. :)

Let's start and learn one by one all of them.

1) Data Driven Alerts : Now, we can create alert on the basis of Thresholds. Earlier, it was only on Period basis. Refer the link. Data Driven Alert

2) PDF Data Connection : Tableau 10.3 is capable to connect with PDF files having structured data.

3) More Database Union : Tableau now supporting Union for Aster Database, Cloudera Hadoop, Greenplum, IBM DB2, IBM Netezza, SybaseASE and SybaseIQ.


4) Tooltip Selection : You can select the data as per tooltip selection refer the link to see how this will be done. Tool Tip Selection

5) Selection of Latest Date : Version 10.3 has feature that you can select the latest date as default.

6) Apply table Calculation filters to totals : Now, 10.3v has capability to apply the table calculation on totals.

 

7) Subscription : Now, we have more flexibility to set the parameters for subscription.

For more available updates, you can refer the official website of tableau. To go there click here

In case of any question, please comment below.

Tableau redirect to webpage

Hello All,

Welcome to my new blog. Here we will learn how to redirect to a webpage while clicking of a link. But, here is a hiccup.

As today, i want to create a hyperlink to redirect my workbook to an URL. But, If we use Action Filter, You have to click on Data view. What if, we require only a text as "Click Here". To achieve this, please go-through the below steps and you will have your view.

1) First, create an image having text Click Here. Like below image

2) Now, drag an image container on dashboard sheet from bottom left Object shelf.

3) Select the image file and make it as floating. So that, you can put it on sheet anywhere.

4) Now, Click on drop down arrow of image and select Set URL...

5) Enter the URL and hit OK.

Now, you are ready to redirect the link to webpage. Below is the final snapshot of the view.

I hope this blog useful to you. If you have any question, please comment below.

What is filter?

In this blog, we will learn about the  the filters and different types of filters available in Tableau.

So, let's start...

Filters are used to send information to tableau that user wants to get the result one some custom parameters. This can be based on dimensions or measures.

There are 7 types of filters as mentioned below:

1) Extract Filters
2) Data Source Filters
3) Context Filters
4) Dimension Filters
5) Measure Filters
6) Action Filters
7) Table Calculation Filters.

Now, We will get familiar with all one by one.

1) Extract Filters : While using this filter you can filter out the data at the time of extraction. Below is the snapshot for the same to get this done as highlighted. In this, We have use Sample - Superstore data.

We have filter out the Furniture from Category dimension. Click on Edit  right side of Extract and you will have the window to create a extract filter. There are more options to filter out on the basis of Top rows and aggregation.

2) Data Source Filters : This filter works on Live Data Connection. When you select Add, extreme right of window. Below window will appear.

You can see there are already 3 dimensions. But, when you try to edit them you will see that all the values of the dimensions are used into dataset.

Now, we will try to enter new one for Order Date Year  = 2014. Refer the below snapshot for this.

3) Context Filters : This filter always applied before any other filter. To apply this refer the below snapshot. You just need to right click on  filter and select Add to Context. This filter can be use as URL parameter also as &state='Alabama'.

4) Dimension Filters : As name, this can be applied on dimensions. Just right click on it and select Show Filter and this will come in filter shelf. You can simply just drag and drop to filter shelf. Below snapshot you will get after this.

There are other tabs also you can filter out on other conditions also like dimension contains or begins with some specific string. Based on greater or less then measures and Top or Bottom. Below snapshot for the reference.

5) Measure Filters : This is an aggregated filter. While using this, it will ask you on what aggregation you want to filter out the data. Refer the snapshot. As you can see there are other range of filter. You can filter out the data on At least, At most or Null or Non-Null values.

6) Action Filters : Using this filter, you can pass information on Click or Mouse Over event from one sheet to other sheet. For example, You have two sheets one is showing Sales and other is showing Profit. So, you can easily filter out the data while selection of sheet one dimension.

7) Table Calculation Filters : Unlike Context filter, this will applied at last of all the filters applied. To get this done we have many functions like LOOKUP, WINDOW_FUNCTIONS etc.

There is one more filter Keep Only and Exclude. You can filter out the data as per your requirement.

Refer the link to download the sample workbook. What is Filter? In case of any question, please comment below.