How to Count the Number of Records in Tableau

How to Count the Number of Records in Tableau

To count the number of records in Tableau, the simplest method is to use the automatically generated `Number of Records` field, found in the Measures pane. Drag this field to the Rows, Columns, or Text shelf, and it will display the total count of rows in your data source or the count within specific partitions if other dimensions are present. For more specific counting, you can create calculated fields using aggregation functions. `COUNT([Your_Field])` will count all non-null occurrences of a field, while `COUNTD([Your_Field])` will count only the distinct occurrences. For example, `COUNTD([Customer ID])` counts unique customers, whereas `COUNT([Order ID])` counts all orders. These functions provide flexibility to count total records, distinct records, or records based on the values of any given field, allowing you to get precise insights into your data volume.

--------------

Video link: https://youtu.be/c8fLhHjCwVU
Channel link: https://www.youtube.com/@HeyInsights

Have questions or thoughts? Leave a comment below. Thank you! 😃

Видео How to Count the Number of Records in Tableau канала Hey Insights