You are here:
Column Types in Datasets
Datasets support the following column types: dates, dimensions, and measures.
| Type | Description |
|---|---|
| Date | Can be represented as a day, month, year, and, optionally, time. You can group, filter, and perform math on dates. |
| Dimension | A qualitative value that usually contains categorical information (text), such as Product Category, Lead Status, and Case Subject. Dimensions are useful for grouping and filtering your data. Unlike measures, you can’t perform math on dimensions. To increase query performance, CRM Analytics indexes all dimension columns in datasets. |
| Measure | A quantitative value that contains numerical data, such as revenue or exchange rate. You can do math on measures, such as calculating the total revenue or the minimum exchange rate. |
Did this article solve your issue?
Let us know so we can improve!
