Skip to main content
Version: Streamsheets 2.3

SERIESTIME

Defines the data source settings for a chart series based on time series created by TIMEAGGREGATE, TIME.QUERY and INFLUX.QUERY. These functions create a table with field and values that can be used in the chart series.

Syntax

=SERIESTIME(SeriesTitleXValues,SeriesTitleYValues,TimeFunction,XValuesField,YValuesField,RadiusColorValuesField)

Arguments

NameDescription
SeriesTitleXValuesSeries title to name the series x values field. This title will be used for displaying the tooltip values.
SeriesTitleYValuesSeries title to name the series y values field. This title will be used for the legend.
TimeFunctionCell containing the function collecting the values.
XValuesFieldValues to use for the chart categories or X- Values, if it is a Scatter or Bubble Chart.
YValuesFieldValues to use for the display of bars, pies, lines etc. or Y-Values in a Scatter or Bubble Charts
RadiusOrColorValuesFieldValues to use for the radius of bubble charts and for colors in state charts.

Return Value

TRUE or an Error Code

Example

FunctionResultComment
=SERIESTIME("XLabel", "YLabel", A1, "time", "values")TRUERetrieves values for a chart series for the series from the function in A1 using the "time" field for X-Values and the "values" field for Y Values.