Instructions: Classify columns as
Dimensions (text, categories, groups, attributes) or
Measuers (numbers, aggregates, etc.)
-
Measure columns contain values that you want to aggregate (sum, average, etc). (ex: sales numbers, units sold.)
-
Dimension columns contain values that you want to group by or filter the data set with. (ex: store location, sales person name.)
-
We now support multiple date formats, including: MM/DD/YYYY and YYYY-MM-DD.
-
Note: Just because a column contains numbers doesn't necessarly mean that you always want to aggregate it.
Ex. An NFL data set may contain a "Quarter" column. It doesn't make sense to average, or sum, the Quarter of a play,
therefore, it should be classified as a "Dimension".