Dimensions
Each column inn your view is a dimension of your data and each dimension can be used in x, y, color and size configuration elements. Dimension of your data can have one of following types:
- Category -Â data that can't be compared, enumerations like type of cars, countries. For category like dimension default scale is ordinal.
- Order - data that can be only ordered, like enumerations. Default scale here is ordinal.
- Measure - data that can be ordered and subtract (subtraction of dates is a duration, subtraction of integer is an integer, etc...). Default scale - linear.
Smart QL charts support following scales: ordinal, linear, color, logarithmic, fill, identity, period, size, time, value.
Configuration
You can change default mapping of a column from your view to a dimension type by using dimensions element in a gadget configuration.
{ "type": ..., "x": "columnA", "y": "columnB", "size": "columnC", "color": "columnD", ... "dimensions" :{ "columnA" : { "type": type-for-columnA, dimension-configuration-for-columnA }, "columnB" : { type": type-for-columnA, dimension-configuration-for-columnB }, ... } ... }
Configuration for type order
With casting your column to order type dimension you can set the appropriate precedence of values you like.Â
Element | Notes |
---|---|
type | Must be set to order value. |
order | Table of values from specific columns. Describes precedence in order from highest. You may not use all possible values - not used ones will be ordered with lower precedence. |
{ ... "x": "priority" ... "dimensions": { "priority": { "type": "order", "order": ["Low", "Medium", "High"] } } }
Configuration of date/time like dimensions
Having a column with a date/time/datetime you can use it either as ordered group of periods or continuous timeline.
{ ... "x": "created" ... "dimensions": { "created": { "type": "order", "scale": "period" } } }
{ ... "x": "created" ... "dimensions": { "created": { "type": "measure", "scale": "time" } } }