Tuesday, May 17, 2022
Latest:

Data Analytics Ireland

Data Analytics and Video Tutorials

tableau measures

data visualisation Tableau 

How can I filter my data in Tableau?

admin 1603 Views 0 Comments , , , ,

Estimated reading time: 5 minutes

Tableau has some very powerful ways to manage your data through dimensions and measures.

Once you are happy how your data is structured, you will then need to filter your data. Here we talk you through the process and how you can use it to your advantage.

So why would I want to apply a filter?

This is probably the first question you should ask, and there are a umber of reasons:

(A) You have a large volume of data, you only want to see a section of it.

(B) You are building several versions of a report, a filter will allow you create those reports with the data specific to each.

(C) You maybe providing information within Tableau, but you may not want people to see certain information, so you just filter that out.

(D) Filters can also let you see problem data, which when found can be checked. In essence, you could use it as part of your data quality strategy within the organisation.

So how can I apply a filter?

There are a number of ways:

(A) On the data source tab within your project. This option is always available but sometimes forgotten about as other ways can be used, specifically on any sheet.

(B) When you are on your sheet tab, a filter can be applied as follows:

  • Drag a dimension or measure to the filter area:
  • If you have dragged a measure or dimension to the columns section, then just click the down arrow and then filter:

What are the types of filter I can apply?

The filter for dimensions is different to measures, below we will describe each.

Dimension filters:

  • General – This allows you to pick values that you want, one or a combination from the list is what is offered.
  • Wildcard allows you to put in values that are not in your list but can be searched for to see if any of the data contains them.
    • For example, on the below, we are asking the filter to only return any values in the Gender column that include “Fem”. So this would then exclude all the male values.
    • There are several different ways to approach this, as can be seen below.
  • Condition – Here they allow you to apply certain logic that must be met, based on the condition entered. This will only return values where the condition is met.
    • Note in dimensions, you only have the four options below
  • Top – Here we literally return the top no of records based on the conditions you apply.
  • Also you could complete by putting in a formula, using one of the other dimensions.

Measure filters:

Measure filters are quite intuitive as they allow you to define the parameters that the filters will be applied on.

As measures are numerical based, they will involve you telling the program what range or value to filter on.

Below are some examples:

data visualisation Tableau 

What are measures in Tableau?

admin 1657 Views 0 Comments , , ,

Estimated reading time: 3 minutes

Previously we discussed what are dimensions in Tableau. While they are important to understand, another vital part of Tableau data is measures, and they are equally important.

So how does Tableau define measures?

In their post on Tableau Measures, they define it as follows:

Measures contain numeric, quantitative values that you can measure. Measures can be aggregated. When you drag a measure into the view, Tableau applies an aggregation to that measure (by default).

Source: Tableau

So in other words, it is a set of information that allows you to compute statistics on the data e.g. sum , count, average.

When your data is loaded into the Tableau project, it automatically deines which are dimensions and which are measures.

As a result you don’t need to do this step, but they can be changed, and this is described below.

Where will I see measures on the Tableau screen?

Normally they can be seen on the left hand side on your sheet like below, directly below dimensions:

Where can I incorporate measures in my Tableau project?

They can be incorporated as a column or row value. Also they can be included as a mark or as a filter as well.

Where can I find the default properties of measures?

In each measure value there are menus associated with each, and you can change any property by clicking on the down arrow.

In the below screenshot, it can be seen that for QTY, in the drop down menu , there are a number of options to change in the default properties section.

Can a measure be changed to a dimension?

The answer is yes, but read on.

If you want to convert a measure to a dimension, first of all you got to ask , why you would want do that?

Some values, may be classified as measures, but in actual fact they maybe better suited to dimensions.

  • An example would be a postal code, while it contains number and letters, it might not always be suited as a measure.
  • Age is another example, where you might not want to aggregate, for example, sum or count? In this instance you may want to put them into buckets of age categories, and this is where changing them to a dimension may help.

If you want to change a measure to a dimension, some of the options are:

(A) Drag the measure to the dimension area on the sheet tab.

(B) Right mouse click on the measure, and click “convert to dimension”

We hope you have enjoyed this post, you can see more Tableau posts here.

data visualisation Tableau 

What are dimensions in Tableau?

admin 1855 Views 0 Comments , , , , , , ,

Estimated reading time: 6 minutes

In our previous post, we showed you how to connect to your data in Tableau. Now that you are in we are going to discuss dimensions and what they can be used for.

What are Dimensions?

When you login to Tableau, you will see the dimensions information on the left hand side as below. We have included the below from our previous post.

When we talk about dimensions, they are values that contain information that can be measured. So, in other words, you can aggregate them into groups.

Aggregating essentially means you can get summary information on the dimension.

Typical examples of aggregation that could be applied include:

  • Count
  • Sum
  • Minimum
  • Maximum

How do you use dimensions in Tableau?

What you can do is drag the dimension over to the column or row values, as per the below:

OR

You can then drop additional information into the sheet , to give you more enriched data to analyse. Below we have “Country” in columns and “ISO Code” in rows.

As you will see above there is no actual information that you can use, to make a decision on. The raw file we have pulled this information from which has 100K records in it, can have a count applied against the “ISO code” row field as follows:

As a result we can now get a better view of the data as follows:

What are the types of things I can with a dimension?

You can change the characteristics of dimensions to get them in a format you would like. Some of the possible ways you could achieve this is:

(A) Create a calculated field, this allows you to have additional information that assists better decision making.

(B) You can change the data type of the field. I would check before doing this as it could have a profound effect on how the data is presented, and not every field may be suited to doing this.

Changing the field ” country” from string to boolean data type as an example, yields the below, which is not very meaningful.

(C) You can change the default properties of the what is presented to you:

In this scenario, I have sorted “country” ascending, and in alphabetic order

outputting the following:

(D) Another option if you so desire is to change the Alias on a field, to a name that is more suitable or meets your needs better.

This can be achieved as follows:

then

As can been seen from the above, I originally had the first bar as “Australia”, but then changed its alias to AUS.

As a result the chart updated to shows AUS.

In this scenario changing aliases , you would need to be careful as some names are quite similar, i.e. Australia and Austria

Luckily Tableau has that sorted, as if you do try to do that, you get the following:

You can also see other tableau tips we have written!