Magics that allow you to create graph visualizations using XVega an implementation of vega-light to C++.
.. object:: %X_FIELD name_of_column Represents the X axis of the graph. The name of the axis should be the same as the name of the SQLite column (or result of SQLite query).
.. object:: %TYPE type_of_field Sub-attribute of **X_FIELD**. Bellow there's list of the types supported by `xeus-sqlite`. If you want to learn more about types please refer to `vega lite type official documentation`_. * QUANTITATIVE * NOMINAL * ORDINAL * TEMPORAL
.. object:: %BIN type_of_field Sub-attribute of **X_FIELD**. Binning discretizes numeric values into a set of bins. If bin is true, default binning parameters are used. To customize binning parameters, you can set bin to a bin definition object, which can have the following properties: If you want to learn more about bin please refer to `vega lite bin official documentation`_.
.. object:: %ANCHOR bin_position Sub-attribute of **BIN**. A value in the binned domain at which to anchor the bins, shifting the bin boundaries if necessary to ensure that a boundary aligns with the anchor value.
.. object:: %BASE number Sub-attribute of **BIN**. The number base to use for automatic bin determination (default is base 10).
.. object:: %BASE boolean Sub-attribute of **BIN**.
.. object:: %MAXBINS number Sub-attribute of **BIN**. Maximum number of bins.
.. object:: %MINSTEP number Sub-attribute of **BIN**. A minimum allowable step size (particularly useful for integer values).
.. object:: %NICE bool Sub-attribute of **BIN**. If true, attempts to make the bin boundaries use human-friendly boundaries, such as multiples of ten.
.. object:: %STEP number Sub-attribute of **BIN**. An exact step size to use between bins.
.. object:: %AGGREGATE type_of_aggregation Sub-attribute of **X_FIELD**. The aggregate property of a field definition can be used to compute aggregate summary statistics (e.g., median, min, max) over groups of data. Bellow there's list of the aggregations supported by `xeus-sqlite`. If you want to learn more about aggregations please refer to `vega lite aggregate official documentation`_. * COUNT * VALID * MISSING * DISTINCT * SUM * PRODUCT * MEAN * AVERAGE * VARIANCE * VARIANCEP * STDEV * STEDEVP * STEDERR * MEDIAN * Q1 * Q3 * CI0 * CI1 * MIN * MAX * ARGMIN * ARGMAX
.. object:: %TIME_UNIT time Sub-attribute of **X_FIELD**. Time unit is used to discretize time. Bellow there's list of the time units supported by `xeus-sqlite`. If you want to learn more about time units please refer to `vega lite time unit official documentation`_. * YEAR * QUARTER * MONTH * DAY * DATE * HOURS * MINUTES * SECONDS * MILISECONDS
.. object:: %Y_FIELD name_of_column Represents the Y axis of the graph. The name of the axis should be the same as the name of the SQLite column (or result of SQLite query).
.. object:: %TYPE type_of_field Sub-attribute of **Y_FIELD**. Bellow there's list of the types supported by `xeus-sqlite`. If you want to learn more about types please refer to `vega lite type official documentation`_. * QUANTITATIVE * NOMINAL * ORDINAL * TEMPORAL
.. object:: %BIN type_of_field Sub-attribute of **Y_FIELD**. Binning discretizes numeric values into a set of bins. If bin is true, default binning parameters are used. To customize binning parameters, you can set bin to a bin definition object, which can have the following properties: If you want to learn more about bin please refer to `vega lite bin official documentation`_.
.. object:: %ANCHOR bin_position Sub-attribute of **BIN**. A value in the binned domain at which to anchor the bins, shifting the bin boundaries if necessary to ensure that a boundary aligns with the anchor value.
.. object:: %BASE number Sub-attribute of **BIN**. The number base to use for automatic bin determination (default is base 10).
.. object:: %BASE boolean Sub-attribute of **BIN**.
.. object:: %MAXBINS number Sub-attribute of **BIN**. Maximum number of bins.
.. object:: %MINSTEP number Sub-attribute of **BIN**. A minimum allowable step size (particularly useful for integer values).
.. object:: %NICE bool Sub-attribute of **BIN**. If true, attempts to make the bin boundaries use human-friendly boundaries, such as multiples of ten.
.. object:: %STEP number Sub-attribute of **BIN**. An exact step size to use between bins.
.. object:: %AGGREGATE type_of_aggregation Sub-attribute of **Y_FIELD**. The aggregate property of a field definition can be used to compute aggregate summary statistics (e.g., median, min, max) over groups of data. Bellow there's list of the aggregations supported by `xeus-sqlite`. If you want to learn more about aggregations please refer to `vega lite aggregate official documentation`_. * COUNT * VALID * MISSING * DISTINCT * SUM * PRODUCT * MEAN * AVERAGE * VARIANCE * VARIANCEP * STDEV * STEDEVP * STEDERR * MEDIAN * Q1 * Q3 * CI0 * CI1 * MIN * MAX * ARGMIN * ARGMAX
.. object:: %TIME_UNIT time Sub-attribute of **Y_FIELD**. Time unit is used to discretize time. Bellow there's list of the time units supported by `xeus-sqlite`. If you want to learn more about time units please refer to `vega lite time unit official documentation`_. * YEAR * QUARTER * MONTH * DAY * DATE * HOURS * MINUTES * SECONDS * MILISECONDS
.. object:: %WIDTH number Width of the graph in pixels.
.. object:: %HEIGHT number Height of the graph in pixels.
.. object:: %MARK mark Marcs can be one of the following: * ARC * AREA * BAR * CIRCLE * LINE * POINT * RECT * RULE * SQUARE * TICK * TRAIL
.. object:: %COLOR color Sub-attribute of **MARK**. Sets the color of a mark. The color can be one of the `valid CSS color string`_.
.. object:: %HEIGHT boolean Enable or disable grid view on graph.