Course: Tableau Data Visualization and Business Intelligence
Topic: Default Properties of Fields
Course Link: JustAcademy Tableau Training
Demo Link: Register for a Tableau Course Demo
In Tableau, fields represent columns from a connected data source. Examples include Sales, Profit, Category, Region, Order Date, Customer Name, and Quantity. When you use these fields in a worksheet, Tableau applies default settings to determine how the data is displayed, aggregated, sorted, or encoded visually.
Default Properties of Fields allow you to configure these settings in advance so that a field behaves consistently whenever you use it in a visualization. Depending on the field type, you can configure properties such as aggregation, number format, date format, comments, colour, shape, sorting, and totals.
For example, if you always want the Sales field to appear as currency, you can set its default number format to currency. Similarly, if you want the Order Priority values to appear in the order High, Medium, Low instead of alphabetical order, you can define a custom default sort order.
Official Tableau documentation: Edit Default Settings for Fields.
After completing this topic, you will be able to:
A field is a data column that Tableau makes available in the Data pane after connecting to a data source. Fields are commonly organized into dimensions and measures.
| Field Type | Meaning | Examples | Common Usage |
|---|---|---|---|
| Dimension | Describes or categorizes data. | Region, Category, Customer Name | Grouping, filtering, and categorizing records. |
| Measure | Contains values that can be measured or summarized. | Sales, Profit, Quantity | Calculating totals, averages, and other metrics. |
| Date Field | Contains dates or date-time values. | Order Date, Ship Date | Analyzing trends over days, months, quarters, and years. |
| Geographic Field | Represents geographical information. | Country, State, City | Creating maps and geographical analysis. |
Tableau automatically identifies field data types and roles, although some fields may require manual correction. Default properties control how supported fields are treated or presented when used in a view.
Reference: Dimensions and Measures in Tableau.
Default properties are field-level settings that Tableau uses when the field is first used in a view or when the relevant default setting is applied. They help standardize calculations and visual presentation across worksheets.
Consider a sales dataset with these fields:
| Field | Possible Default Property | Purpose |
|---|---|---|
| Sales | Number Format: Currency | Displays sales values with a currency symbol. |
| Profit | Aggregation: Average | Uses average profit when the field is first added to a view. |
| Order Date | Date Format | Controls the date display format where supported. |
| Region | Colour | Helps maintain consistent colours for regional values. |
| Product Category | Colour or Shape | Assigns consistent visual encodings to category values. |
| Order Priority | Sort | Displays priority values in a meaningful business order. |
| Customer Name | Comment | Provides a description of the field to other users. |
You can configure field defaults directly from the Data pane in Tableau Desktop.
Important: The available options depend on the type of field and the data source. For example, default aggregation is a measure-related property, while custom sorting is particularly useful for categorical dimensions.
Aggregation is the process of summarizing multiple data values into a single result. Tableau typically aggregates measures when you add them to a view. Common aggregation functions include SUM, AVG, MIN, MAX, COUNT, and COUNTD.
For example, if Sales contains the values 100, 200, and 300, the SUM is 600 and the AVG is 200.
| Aggregation | Description | Example Result for 100, 200, 300 |
|---|---|---|
| SUM | Adds the values. | 600 |
| AVG | Calculates the arithmetic mean. | 200 |
| MIN | Returns the smallest value. | 100 |
| MAX | Returns the largest value. | 300 |
| COUNT | Counts non-null entries. | 3 |
| COUNTD | Counts distinct values. | 3 if all values are distinct |
Example: If you change the default aggregation of Profit to Average, newly added instances of Profit will use AVG(Profit) by default. This does not mean that every existing worksheet will automatically change its previously configured aggregation.
Business use cases:
Reference: Data Aggregation in Tableau.
Default number formatting determines how numerical values are displayed. It changes the presentation of a value, not the underlying numerical value.
For example, a Sales value of 12500 can be displayed as $12,500.00, $12,500, or $12.5K, depending on the chosen format and display units.
| Format | Example Display | Suitable Fields |
|---|---|---|
| Number | 12,500.00 | General numerical values |
| Currency | $12,500.00 | Sales, Revenue, Expenses |
| Percentage | 25.00% | Discount Rate, Conversion Rate |
| Scientific | 1.25E+04 | Very large or small numerical values |
| Custom | 12.5K | Compact numerical reporting |
Example: If the Sales field should always appear as currency, set its default number format to Currency. This reduces the need to format the same field repeatedly across different worksheets.
Common mistake: Formatting a number as a percentage does not automatically convert a value of 25 into 0.25. Check the underlying data and calculation before selecting a display format.
Default date formatting determines how date values are displayed in supported views. A date may be displayed in a long, short, or custom format depending on the available options.
| Date Format | Example | Typical Use |
|---|---|---|
| Short Date | 14/10/2026 | Compact tables and reports |
| Long Date | Wednesday, October 14, 2026 | Detailed reporting |
| Month and Year | October 2026 | Monthly trend reports |
| Custom Date | 2026-10-14 | Standardized reporting formats |
Important distinction: Date formatting changes how a date appears. Choosing a date level such as Year, Quarter, Month, or Day changes the date granularity used in the view. These are related but different operations.
Comments allow you to document a field's meaning, intended use, or business rules. In Tableau Desktop, field comments can be displayed as tooltips when users hover over the field in the Data pane.
Example: The Sales field may contain this comment: "Sales represents the total transaction value before subtracting discounts and other costs, according to the dataset definition."
Benefits of comments:
Default colour settings allow you to define the colours assigned to values when a field is used on the Colour shelf of the Marks card. This helps maintain consistent visual encoding across worksheets that use the same data source.
Example: A company may use the following regional colours:
| Region | Example Colour Assignment | Purpose |
|---|---|---|
| East | Blue | Identify East region consistently. |
| West | Green | Identify West region consistently. |
| Central | Orange | Identify Central region consistently. |
| South | Purple | Identify South region consistently. |
These colours are examples; choose colours that suit the report and remain easy to distinguish.
Why it matters: If the same region uses different colours in different charts, users may misinterpret the report. Consistent colour assignments make comparisons easier.
Default shape settings define the symbols used for the values of a field when that field is used on the Shape shelf of the Marks card. Shape encoding is especially useful when distinguishing categories in scatter plots, point maps, and other views that use marks.
Example: A business may use circles for Furniture, squares for Office Supplies, and triangles for Technology.
Best practice: Use a limited number of easily distinguishable shapes. Do not rely on shape alone when labels or colours would improve accessibility.
Sorting determines the order in which categorical values appear in a view. Tableau may display category names alphabetically by default, but business categories sometimes require a specific order.
For example, an Order Priority field might contain High, Medium, and Low. Alphabetical sorting does not necessarily represent the desired business order.
| Sort Type | Description | Example |
|---|---|---|
| Alphabetical | Arranges values by their names. | Central, East, South, West |
| Ascending | Orders values from lower to higher where applicable. | Low to High numerical values |
| Descending | Orders values from higher to lower where applicable. | Highest sales to lowest sales |
| Custom or Manual | Uses a deliberately selected order. | High, Medium, Low |
Example: For a customer journey, you may want values to appear in the sequence Awareness, Consideration, Purchase, Retention instead of alphabetical order.
Note: Default sort settings can also affect how dimension values appear in filters. Options may vary depending on the field and Tableau version.
The properties available depend on the field type. The following table summarizes common field defaults.
| Property | Commonly Used With | Main Purpose |
|---|---|---|
| Aggregation | Measures | Controls the default summarization of a measure. |
| Number Format | Numerical fields | Controls numerical display formatting. |
| Date Format | Date fields | Controls the display format of dates. |
| Comment | Dimensions and measures, where supported | Documents a field's meaning. |
| Colour | Fields used for colour encoding | Sets consistent colour assignments. |
| Shape | Categorical fields used for shape encoding | Sets consistent shape assignments. |
| Sort | Dimensions or categorical fields | Controls the order of field members. |
| Totals | Applicable measures and views | Can control default total calculation behaviour where supported. |
This is a practical overview rather than a guarantee that every property will appear for every field. Tableau's menu options depend on the data source, field type, and version.
Suppose you are building a sales dashboard for a retail company. The dataset contains Sales, Profit, Discount, Order Date, Region, Category, and Order Priority.
Right-click Sales, choose Default Properties > Number Format, and select Currency. Choose suitable decimal places and display units.
Expected result: New views using Sales display values in the selected currency format where that default applies.
Right-click Profit, choose Default Properties > Aggregation, and select Average if the analysis requires average profit rather than total profit.
Expected result: Newly added instances of Profit use AVG(Profit) by default. Verify that average profit is the intended business metric before using it.
Configure the default date display format for Order Date where available. Use an appropriate format for the audience, such as a short date for detailed tables.
Assign a distinct colour to each region through the field's default colour settings. Use Region on the Colour shelf to verify the assignments.
Configure the intended business order for Order Priority. For example, use High, Medium, Low when that is the sequence required by the report.
Add a comment to Discount or Profit describing its meaning and any important calculation assumptions.
Default properties and worksheet-specific formatting serve different purposes.
| Default Properties | Worksheet-Specific Formatting |
|---|---|
| Sets field-level defaults for supported properties. | Customizes the presentation of a particular view or worksheet. |
| Helps keep settings consistent when creating new views. | Supports special formatting requirements for one visualization. |
| Useful for recurring reporting standards. | Useful for highlighting a specific chart or metric. |
| Does not necessarily override formatting already configured in existing worksheets. | Can retain its own formatting even when field defaults are changed later. |
Example: You set Sales to display as currency by default. A worksheet that already has its own number formatting may continue to use that worksheet-specific format. Review existing views when changing defaults.
| Mistake | Why It Is a Problem | How to Avoid It |
|---|---|---|
| Using SUM for every measure | Some analyses require averages, counts, or distinct counts. | Choose aggregation based on the business question. |
| Changing a format but expecting data to change | Formatting usually affects display, not the underlying value. | Check the actual data and calculation. |
| Assuming all existing sheets update | Worksheet-level settings may override defaults. | Review and test existing views separately. |
| Using inconsistent colours | Users may interpret the same category differently. | Set consistent field colour assignments. |
| Using alphabetical order for every dimension | Business categories may have a meaningful sequence. | Set a suitable custom sort order. |
| Adding unclear comments | Vague comments do not help users interpret data. | Explain the field's meaning and relevant assumptions. |
| Ignoring the data source's structure | Incorrect field roles or types can affect analysis. | Verify data types, dimensions, and measures first. |
Answer: Default Properties are field-level settings that control supported behaviours and presentation options, such as aggregation, number formatting, date formatting, colour, shape, comments, and sorting.
Answer: In Tableau Desktop, right-click a field in the Data pane and open Default Properties. The available options depend on the field type.
Answer: Default aggregation specifies the summarization Tableau uses when a measure is first added to a view, unless another aggregation is specified.
Answer: SUM adds values together, whereas AVG calculates their arithmetic mean. The appropriate choice depends on the analysis.
Answer: It controls how numerical values are displayed, for example as currency, percentages, or numbers with a chosen number of decimal places.
Answer: Normally, no. It changes how the value is displayed. It does not, by itself, change the underlying numerical data.
Answer: Comments explain a field's meaning or usage. They help analysts collaborate and understand fields when working with shared data sources.
Answer: They help assign consistent colours to field values when the field is used for colour encoding.
Answer: It allows values to appear in a meaningful business sequence, such as High, Medium, Low, rather than alphabetical order.
Answer: No. Existing worksheet-specific settings may remain in effect. You should verify existing views after changing defaults.
Answer: No. The available properties depend on the field type, data source, and Tableau version.
Answer: They improve consistency, reduce repetitive work, make data easier to interpret, and help teams follow common reporting standards.
Connect to Sample - Superstore and configure Sales to use a suitable currency format. Create a worksheet and verify how the value is displayed.
Set Profit to use Average as its default aggregation. Add Profit to a worksheet and compare the result with SUM(Profit). Explain why the values differ.
Create a worksheet using Order Priority. Configure the intended business order and verify the order of values in the view.
Assign distinct colours to the Region field. Create two worksheets using Region on Colour and check whether the assignments remain consistent.
Add a useful comment to the Sales or Discount field. Hover over the field in the Data pane and verify that the comment is visible.
Configure an appropriate default display format for Order Date where available. Create a table and compare the readability of short and long date formats.
Default Properties of Fields are an important Tableau feature for creating consistent, readable, and reliable visualizations. By configuring aggregation, number formats, date formats, comments, colours, shapes, and sorting, analysts can reduce repetitive work and make dashboards easier to understand.
The key principle is to select field defaults based on the meaning of the data and the business question. Always verify the result in a worksheet, especially when changing aggregation or working with existing formatting.
Learn more: JustAcademy Tableau Training
Register for a demo: Register for a Tableau Course Demo
