SERIESTIME
Defines the data source settings for a chart series based on time series created by functions like TIMEAGGREGATE, TIME.QUERY or INFLUX.SELECT. These functions create a table in the background with key-value pairs that can be used as a data source for series in charts.
Syntax
=SERIESTIME(SeriesTitleXValues,SeriesTitleYValues,TimeFunction,XValuesField,YValuesField,RadiusColorValuesField)
Arguments
| Name | Description |
|---|---|
| SeriesTitleXValues | Title that shall be used for the x value series. |
| SeriesTitleYValues | Series title to name the series y values field. This title will be used for the legend. |
| TimeFunction | Cell containing the function collecting the values. |
| XValuesField | Values to use for the chart categories or x values, if it is a Scatter or Bubble Chart. |
| YValuesField | Values to use for the display of bars, pies, lines etc. or y values in a Scatter or Bubble Charts |
| RadiusOrColorValuesField | Values to use for the radius of bubble charts and for colors in state charts. |
Return Value
TRUE or an Error Code
Example
| Function | Result | Comment |
|---|---|---|
| =SERIESTIME("XLabel", "YLabel", A1, "time", "values") | TRUE | Retrieves 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. |