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:
Smart QL charts support following scales: ordinal, linear, color, logarithmic, fill, identity, period, size, time, value.
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 }, ... } ... } |
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"] } } } |
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" } } } |