Tableau Generated Fields
Updated: Feb 1
In this post, we’ll briefly explore what generated fields are in Tableau. Anytime you connect data in Tableau, you’ll note several fields which are not part of the underlying data present in your Tableau data source on the data pane – these fields are what we call Tableau generated fields (automatically generated fields).
Number of Records (before version 2020.2)
Number of records is a calculated field which contains value as 1. It is associated with every record in your data source. When added to the rows or columns shelves it returns the total number of records in your data source.
This field number of records is available for those using Tableau version 2020.1 and before.
Count of Table (starting with version 2020.2)
Starting with Tableau version 2020.2, every table in the data source has a count field in the form of NameofTable(Count). For instance, if you're connected to a table called 'Orders' then count of table will be 'Orders(count)'.
This field is automatically generated by Tableau and just like number of records this field returns the total number of records in the table.
COUNT of Table = SUM of number of records per table
Measure names field contains the names of all measures in the data source, collected into a single field with discrete values. Measure names are located at the bottom of dimension area.
Measure values field contains all measures in your data source, collected into a single field with continuous values. Measure values are located at the bottom of measure area.
Latitude (generated) & Longitude (generated)
Anytime you assign a geographic role to a field, Tableau adds two fields on the measure area namely; Latitude (generated) and Longitude (generated).
These fields contain the latitude and longitude values and are assigned the Latitude and Longitude geographic roles. Used to create a map view.
If this post was helpful and would like to stay informed anytime we publish, kindly join our mailing list by subscribing below.
Thank you for reading.