Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

According to the definition of Dimension and Measure in Tableau:

Dimensions contain qualitative values(such as names, dates, or geographical data).

Measures contain numeric, quantitative values that you can measure.

In my opinion, date-type data seems more quantitative than qualitative, and it can be measured.

So why Tableau treats date as Dimension rather than Measure?

Thanks for any hint. 

closed

1 Answer

0 votes
by (47.2k points)
selected by
 
Best answer

  • Date fields are only treated as dimensions by default, but you can certainly use a date as a measure instead.

  • In Tableau, Measures are aggregated. So you would normally compute the max (i.e. latest) date value, or the minimum data value(earliest), or perhaps the count or distinct count of a data field. You can't compute the avg or sum of dates like you can with numeric fields.

  • The part of the Tableau documentation you quoted is unfortunately so poorly written that it is downright misleading. Whether a field is treated as dimension or measure is not determined by its datatype, but by whether you wish to compute an aggregation function summarizing the values in that field (treating the field as a measure) or whether you wish to use the field to partition or slice data records prior to aggregation (treating the field as a dimension). Treating a field as dimension is exactly like using that field in a GROUP BY clause in a SQL statement.

  • It is unfortunate that such an important concept is currently so poorly explained in the documentation which has otherwise improved greatly over the last few years. I imagine it was an attempt to make a simple introduction that veered from being simplified into actually being wrong.

  • A field in Tableau has a few fixed attributes, such as its name, data type, aliases and definition (such as the reference to the corresponding database column or calculation). Other attributes of a field may have default values in the data source that can be nonetheless be changed anytime that field is used on a particular worksheet - e.g., the default numeric or date formatting, whether the field is displayed as discrete or continuous or whether it is treated as a dimension or measure.

  • So when people talk about dimensions in Tableau, that is shorthand for "fields that are being treated as dimensions in the current view". Since that is kind of long-winded, people just talk about dimensions and measures, but that gives the misleading impression that the choice of the role is intrinsic to the field instead of just a default. Many times that distinction isn't critical, but with dates, in particular, they can be used many different ways.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 9, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Jul 30, 2019 in BI by Ashok (47.2k points)

Browse Categories

...