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
Name |
Description |
|---|---|
SeriesTitleXValues |
Series title to name the series x values field. This title will be used for displaying the tooltip values. |
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.
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. |