How tableau is distributing data into dimension and measures?
How tableau knows what's discrete data and whats contentious data ?
6 answers
Hello Manaswi,
I'm curious about this too
According to Dimensions and Measures, Blue and Green
When you connect to a new data source, Tableau assigns each field in the data source to either the Dimensions area or the Measures area of the Data pane, depending on the type of data the field contains.
Not found in any official articles, but just a guess from my experience, some rules might look like,
- Data type is detected from the majority of the data rows
- Data type string is always auto-assigned as Dimension-Discrete-string
- Data type date/date-time is always assigned as Dimension-Discrete-date/date-time
- Field names contribute to the detection, for example
- field names with "xx ID" are auto-assigned as Dimension-Discrete-number
- field names with "city" are auto-assigned as Dimension-Discrete-string with Geo role
Has anyone else got any other rules?
Regards
Lei
