When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data. Show
Watch a Video: To see related concepts demonstrated in Tableau, watch Understanding Pill Types(Link opens in a new window), a 5-minute free training video. Use your tableau.com(Link opens in a new window) account to sign in. About data field roles and typesData fields are made from the columns in your data source. Each field is automatically assigned a data type (such as integer, string, date), and a role: Discrete Dimension or Continuous Measure (more common), or Continuous Dimension or Discrete Measure (less common).
Blue versus green fieldsTableau represents data differently in the view depending on whether the field is discrete (blue), or continuous (green). Continuous and discrete are mathematical terms. Continuous means "forming an unbroken whole, without interruption"; discrete means "individually separate and distinct."
Possible combinations of fields in TableauThis table shows examples of what the different fields look like in the view. People sometimes call these fields "pills", but we refer to them as "fields" in Tableau help documentation.
Note: With a cube (multidimensional) data source, the options for changing data roles are limited. In Tableau Desktop, cubes are supported only on Windows.) You can change some measures from continuous to discrete, but in general, you cannot change data roles for fields in cube data sources. For related details, see Cube Data Sources. A visual cue that helps you know when a field is a measure is that the field is aggregated with a function, which is indicated with an abbreviation for the aggregation in the field name, such as: But there are exceptions:
Note: You can set the default aggregation and other properties and settings for fields. For details on the many ways you can customize the fields in the Data pane, see Organize and Customize Fields in the Data Pane, Edit Default Settings for Fields, and Work with Data Fields in the Data Pane. Examples of continuous and discrete fields used in a viewIn the example on the left (below), because the Quantity field is set to Continuous, it creates a horizontal axis along the bottom of the view. The green background and the axis help you to see that it's a continuous field. In the example on the right, the Quantity field has been set to Discrete. It creates horizontal headers instead of an axis. The blue background and the horizontal headers help you to see that it's discrete.
In both examples, the Sales field is set to Continuous. It creates a vertical axis because it continuous and it's been added to the Rows shelf. If it was on the Columns shelf, it would create a horizontal axis. The green background and aggregation function (in this case, SUM) help to indicate that it's a measure. The absence of an aggregation function in the Quantity field name help to indicate that it's a dimension. Dimension fields in the viewWhen you drag a discrete dimension field to Rows or Columns, Tableau creates column or row headers.
In many cases, fields from the Dimension area will initially be discrete when you add them to a view, with a blue background. Date dimensions and numeric dimensions can be discrete or continuous, and all measures can be discrete or continuous. After you drag a dimension to Rows or Columns, you can change the field to a measure just by clicking the field and choosing Measure. Now the view will contain a continuous axis instead of column or row headers, and the field's background will become green:
Date dimensions can be discrete or continuous. Dimensions containing strings or Boolean values cannot be continuous. Tableau does not aggregate dimensions. For a discussion of the different types of aggregation Tableau can perform, see List of Predefined Aggregations in Tableau. In Tableau queries, dimensions in the view are expressed in SQL as "Group By" clauses. For details on converting fields between continuous and discrete, see Convert Fields between Discrete and Continuous. How dimensions affect the level of detail in the viewThe level of detail in a view refers to how granular the data is given the dimension and measure data in the view. As you add dimensions to Rows or Columns, the number of marks in the view increases. To understand why adding dimensions increases the number of marks in the view, do the following:
Notes
Measure fields in the viewWhen you drag a measure to the view, it is aggregated by default. The type of aggregation will vary depending on the type of view. You should always check the aggregation and change it if necessary. For details, see "Change the default aggregation" in Edit Default Settings for Fields. For more details about aggregation, see Data Aggregation in Tableau. When you drag a continuous field from the Data pane to Rows or Columns, Tableau creates a continuous axis for that field.
If you click the field and change it to Discrete, the values become column headers.
Tableau continues to aggregate values for the field, because even though the field is now discrete, it is still a measure, and Tableau aggregates measures by default. In cases where Tableau has misclassified a field as a dimension or a measure, possibly because of the data type, you can convert it and change its role. If a measure contains numbers that don't need to be aggregated (such as a field that contains date values), you may want to convert it to be a dimension. For related details, see Convert a Measure to a Dimension. For details on converting fields between continuous and discrete, see Convert Fields between Discrete and Continuous. How continuous and discrete fields change the viewContinuous and discrete are mathematical terms. Continuous means "forming an unbroken whole, without interruption"; discrete means "individually separate and distinct." In Tableau, fields can be either continuous or discrete. When you drag a field from the Data pane to Columns or Rows, the values are continuous by default and Tableau creates an axis. When you drag a field from the Data pane to Columns or Rows, the values are discrete by default and Tableau creates column or row headers. Continuous fields produce axesIf a field has values that are numbers that can be added, averaged, or otherwise aggregated, it is added as a measure field in the Data pane when you first connect to a data source. Tableau is assuming that the values are continuous. Tableau displays an axis when you drag a continuous field to Rows or Columns. An axis is a measuring line that shows values between a minimum and a maximum. Rulers and analog thermometers are examples of physical objects that display axes. Tableau must be able to show a range of actual and potential values, because in addition to the initial values in the data source, it is always possible that new values will emerge as you work with a continuous field in the view. While there are value labels on a continuous axis (0, 0.5, ... 3.0 in the following image), actual marks don't have to align with these labels as they would with column headers. For example, in the following image, the blue bar actually extends to a value of 6.940 on the horizontal axis, not 7.0 exactly.
The number of potential values for continuous fields is impossible to anticipate. For example, if you have a field named Ratings and the initial values are 1, 3, 3.5, 3.6, and 4, that's five distinct values. But if you drop Ratings on Rows, Tableau automatically aggregates that value as SUM (which you would then immediately change to AVG, because it's more logical to average grades than to add them), and that would then create a sixth value (3.02) that didn't exist until you added the field to the view. And if you then applied a filter that eliminated two of the initial values, the average would change as well, so that would be yet another value. And then if you changed the aggregation, ... You get the idea. The number of potential values is, if not infinite, then certainly immense. The fact that a field contains numbers does not automatically indicate that those values are continuous. Postal codes are the classic example: though they are often composed entirely of numbers, they are actually string values which shouldn't be added or averaged. If Tableau assigns such a field as a measure to the Data pane, you should drag it to a dimensions area to change it to a dimension field. If a field contains values that are names, dates, or geographical locations—anything other than numbers—it is added as a dimension field in the Data pane when you first connect to a data source. Tableau treats the values as discrete. Tableau creates headers when you drag a discrete field to Columns or Rows. The individual values for a discrete field become the row or column headings. Because these types of values are never aggregated, no new field values are created as you work with your view, so there is no need for an axis. Discrete versus continuous fields on filters
For more on filtering various types of fields, see Drag dimensions, measures, and date fields to the Filters shelf (Link opens in a new window). Discrete versus continuous fields on colorWhen you drop a discrete field on Color in the Marks card, Tableau displays a categorical palette and assigns a color to each value of the field. When you drop a continuous field on Color, Tableau displays a quantitative legend with a continuous range of colors. For more information about color palettes, see Color Palettes and Effects. Is a data display tool used to display discrete categories?Bar chart. The simplest and the most popular type of chart to show discrete data. It displays grouped data using rectangular bars with lengths that are proportional to the values. Bar charts are broadly used in marketing and finance.
Which of the following is data display tool used to show the relationship of each part to the whole?Answer and Explanation: A pie chart can be used to display the relationship of each part to the whole.
What type of graph is often used to display frequency of a discrete scale variable?The histogram is a popular graphing tool. It is used to summarize discrete or continuous data that are measured on an interval scale. It is often used to illustrate the major features of the distribution of the data in a convenient form.
What data display tool is used to display data collected over a period of time?Line graph is probably the most simple way to visualize time series data. It uses points connected to illustrate the changes.
|