Skip to content
  • YouTube
  • FaceBook
  • Twitter
  • Instagram

Data Analytics Ireland

Data Analytics and Video Tutorials

  • Home
  • Contact
  • About Us
    • Latest
    • Write for us
    • Learn more information about our website
  • Useful Links
  • Glossary
  • All Categories
  • Faq
  • Livestream
  • Toggle search form
  • How to Automate Testing With Python | unittest automation
  • How to use wildcards in SQL SQL
  • Python Tutorial: How to sort lists Python Lists
  • How to show percentage differences between files in Python CSV
  • how to update records in SQL CRUD
  • supervised machine learning vs unsupervised machine learning? machine learning
  • How Would You Change The Name Of a Key in a Python Dictionary Python
  • how to remove spaces from a string regular expressions

What are measures in Tableau?

Posted on May 25, 2021June 29, 2021 By admin No Comments on What are measures in Tableau?

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 Tags:data visualisation, tableau default properties, tableau dimensions, tableau measures

Post navigation

Previous Post: What are dimensions in Tableau?
Next Post: How can I filter my data in Tableau?

Related Posts

  • How to connect to your data in Tableau data visualisation
  • Tableau Desktop versus Tableau Server data visualisation
  • How to create a calculated field in Tableau data visualisation
  • How to group your data in Tableau data visualisation
  • What are dimensions in Tableau? data visualisation
  • How can I filter my data in Tableau? data visualisation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Select your language!

  • हिंदी
  • Español
  • Português
  • Français
  • Italiano
  • How to Automate Testing With Python | unittest automation
  • how do I merge two dictionaries in Python? Python
  • How to Group By in a Select Statement SQL
  • how to compare two lists in Python Python Lists
  • How to import data into excel Python Tutorial
  • TypeError object of type ‘int’ has no len() Python
  • IndexError: index 2 is out of bounds for axis 0 with size 2 Index Error
  • How to connect to your data in Tableau data visualisation

Copyright © 2023 Data Analytics Ireland.

Powered by PressBook Premium theme

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT