|
Grafana
|
Classes
| Class | Description | |
|---|---|---|
|
AbsoluteValueT | Returns a series of values that represent the absolute value each of the values in the source series. |
|
|
AbsoluteValueTComputeMeasurementValue | Returns a series of values that represent the absolute value each of the values in the source series. |
|
|
AbsoluteValueTComputePhasorValue | Returns a series of values that represent the absolute value each of the values in the source series. |
|
|
AddMetadataT | Returns a series with an extra MetaData Field. |
|
|
AddMetadataTComputeMeasurementValue | Returns a series with an extra MetaData Field. |
|
|
AddMetadataTComputePhasorValue | Returns a series with an extra MetaData Field. |
|
|
AverageT | Returns a single value that represents the mean of the values in the source series. |
|
|
AverageTComputeMeasurementValue | Returns a single value that represents the mean of the values in the source series. |
|
|
AverageTComputePhasorValue | Returns a single value that represents the mean of the values in the source series. |
|
|
BottomT | Returns a series of N, or N% of total, values that are the smallest in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Third parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
BottomTComputeMeasurementValue | Returns a series of N, or N% of total, values that are the smallest in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Third parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
BottomTComputePhasorValue | Returns a series of N, or N% of total, values that are the smallest in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Third parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
CeilingT | Returns a series of values that represent the smallest integral value that is greater than or equal to each of the values in the source series. |
|
|
CeilingTComputeMeasurementValue | Returns a series of values that represent the smallest integral value that is greater than or equal to each of the values in the source series. |
|
|
CeilingTComputePhasorValue | Returns a series of values that represent the smallest integral value that is greater than or equal to each of the values in the source series. |
|
|
ClampT | Returns a series of values that represent each of the values in the source series clamped to the inclusive range of min and max. min is lower bound of the result and max is the upper bound of the result. |
|
|
ClampTComputeMeasurementValue | Returns a series of values that represent each of the values in the source series clamped to the inclusive range of min and max. min is lower bound of the result and max is the upper bound of the result. |
|
|
ClampTComputePhasorValue | Returns a series of values that represent each of the values in the source series clamped to the inclusive range of min and max. min is lower bound of the result and max is the upper bound of the result. |
|
|
CountT | Returns a single value that is the count of the values in the source series. |
|
|
CountTComputeMeasurementValue | Returns a single value that is the count of the values in the source series. |
|
|
CountTComputePhasorValue | Returns a single value that is the count of the values in the source series. |
|
|
DerivativeT | Returns a series of values that represent the rate of change, per time units, for the difference between consecutive values in the source series. The units parameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. |
|
|
DerivativeTComputeMeasurementValue | Returns a series of values that represent the rate of change, per time units, for the difference between consecutive values in the source series. The units parameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. |
|
|
DerivativeTComputePhasorValue | Returns a series of values that represent the rate of change, per time units, for the difference between consecutive values in the source series. The units parameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. |
|
|
DifferenceT | Returns a series of values that represent the difference between consecutive values in the source series. |
|
|
DifferenceTComputeMeasurementValue | Returns a series of values that represent the difference between consecutive values in the source series. |
|
|
DifferenceTComputePhasorValue | Returns a series of values that represent the difference between consecutive values in the source series. |
|
|
DistinctT | Returns a series of values that represent the unique set of values in the source series. |
|
|
DistinctTComputeMeasurementValue | Returns a series of values that represent the unique set of values in the source series. |
|
|
DistinctTComputePhasorValue | Returns a series of values that represent the unique set of values in the source series. |
|
|
EvaluateT | Returns a single value that represents the evaluation of an expression over a slice of the values in the source series. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. The evalExpression parameter must always be expressed in braces, e.g., { expression }; expression is strongly typed, but not case-sensitive; expression is expected to return a value that can be evaluated as a floating-point number. Aliases of target tag names are used as variable names in the evalExpression when defined. If no alias is defined, all non-valid characters will be removed from target tag name, for example, variable name for tag PMU.032-PZR_CI:ANG would be PMU032PZR_CIANG. All targets are also available as index suffixed variables named _v, for example, first and second target values are available as _v0 and _v1. The Evaluate function is always evaluated as a slice, any specified group operation prefix will be ignored. Default system types available to expressions are System.Math and System.DateTime. See details on valid expressions. Use the Imports command to define more types for evalExpression. |
|
|
EvaluateTComputeMeasurementValue | Returns a single value that represents the evaluation of an expression over a slice of the values in the source series. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. The evalExpression parameter must always be expressed in braces, e.g., { expression }; expression is strongly typed, but not case-sensitive; expression is expected to return a value that can be evaluated as a floating-point number. Aliases of target tag names are used as variable names in the evalExpression when defined. If no alias is defined, all non-valid characters will be removed from target tag name, for example, variable name for tag PMU.032-PZR_CI:ANG would be PMU032PZR_CIANG. All targets are also available as index suffixed variables named _v, for example, first and second target values are available as _v0 and _v1. The Evaluate function is always evaluated as a slice, any specified group operation prefix will be ignored. Default system types available to expressions are System.Math and System.DateTime. See details on valid expressions. Use the Imports command to define more types for evalExpression. |
|
|
EvaluateTComputePhasorValue | Returns a single value that represents the evaluation of an expression over a slice of the values in the source series. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. The evalExpression parameter must always be expressed in braces, e.g., { expression }; expression is strongly typed, but not case-sensitive; expression is expected to return a value that can be evaluated as a floating-point number. Aliases of target tag names are used as variable names in the evalExpression when defined. If no alias is defined, all non-valid characters will be removed from target tag name, for example, variable name for tag PMU.032-PZR_CI:ANG would be PMU032PZR_CIANG. All targets are also available as index suffixed variables named _v, for example, first and second target values are available as _v0 and _v1. The Evaluate function is always evaluated as a slice, any specified group operation prefix will be ignored. Default system types available to expressions are System.Math and System.DateTime. See details on valid expressions. Use the Imports command to define more types for evalExpression. |
|
|
ExceedsAtT |
Returns a series of values at which a value exceeds the given threshold. The threhsold parameter value is a
floating-point number that represents the threshold to be exceeded. Second parameter, fallsBelow, optional,
is a boolean flag that determines if the value should be considered inversely as falling below the threshold instead
of exceeding. returnDurations, optional, is a boolean that determines if the duration (in seconds) from where
value exceeded threshold should be returned instead of the original value. Forth parameter, reportEndMarker,
is a boolean flag that determines if a value should be reported at the point when threshold stops being exceeding
the threshold. See example template dashboard. |
|
|
ExceedsAtTComputeMeasurementValue |
Returns a series of values at which a value exceeds the given threshold. The threhsold parameter value is a
floating-point number that represents the threshold to be exceeded. Second parameter, fallsBelow, optional,
is a boolean flag that determines if the value should be considered inversely as falling below the threshold instead
of exceeding. returnDurations, optional, is a boolean that determines if the duration (in seconds) from where
value exceeded threshold should be returned instead of the original value. Forth parameter, reportEndMarker,
is a boolean flag that determines if a value should be reported at the point when threshold stops being exceeding
the threshold. See example template dashboard. |
|
|
ExceedsAtTComputePhasorValue |
Returns a series of values at which a value exceeds the given threshold. The threhsold parameter value is a
floating-point number that represents the threshold to be exceeded. Second parameter, fallsBelow, optional,
is a boolean flag that determines if the value should be considered inversely as falling below the threshold instead
of exceeding. returnDurations, optional, is a boolean that determines if the duration (in seconds) from where
value exceeded threshold should be returned instead of the original value. Forth parameter, reportEndMarker,
is a boolean flag that determines if a value should be reported at the point when threshold stops being exceeding
the threshold. See example template dashboard. |
|
|
ExcludeRangeT | Returns a series of values that represent a filtered set of the values in the source series where each value falls outside the specified low and high. The low and high parameter values are floating-point numbers that represent the range of values excluded in the return series. Third parameter, optional, is a boolean flag that determines if range values are inclusive, i.e., excluded values are <= low or >= high - defaults to false, which means values are exclusive, i.e., excluded values are < low or > high. Function allows a fourth optional parameter that is a boolean flag - when four parameters are provided, third parameter determines if low value is inclusive and forth parameter determines if high value is inclusive. The low and high parameter values can either be constant values or named targets available from the expression. |
|
|
ExcludeRangeTComputeMeasurementValue | Returns a series of values that represent a filtered set of the values in the source series where each value falls outside the specified low and high. The low and high parameter values are floating-point numbers that represent the range of values excluded in the return series. Third parameter, optional, is a boolean flag that determines if range values are inclusive, i.e., excluded values are <= low or >= high - defaults to false, which means values are exclusive, i.e., excluded values are < low or > high. Function allows a fourth optional parameter that is a boolean flag - when four parameters are provided, third parameter determines if low value is inclusive and forth parameter determines if high value is inclusive. The low and high parameter values can either be constant values or named targets available from the expression. |
|
|
ExcludeRangeTComputePhasorValue | Returns a series of values that represent a filtered set of the values in the source series where each value falls outside the specified low and high. The low and high parameter values are floating-point numbers that represent the range of values excluded in the return series. Third parameter, optional, is a boolean flag that determines if range values are inclusive, i.e., excluded values are <= low or >= high - defaults to false, which means values are exclusive, i.e., excluded values are < low or > high. Function allows a fourth optional parameter that is a boolean flag - when four parameters are provided, third parameter determines if low value is inclusive and forth parameter determines if high value is inclusive. The low and high parameter values can either be constant values or named targets available from the expression. |
|
|
FilterNaNT | Returns a series of values that represent a filtered set of the values in the source series where each value is a real number, i.e., value is not NaN. Parameter alsoFilterInfinity, optional, is a boolean flag that determines if infinite values should also be excluded - defaults to true. |
|
|
FilterNaNTComputeMeasurementValue | Returns a series of values that represent a filtered set of the values in the source series where each value is a real number, i.e., value is not NaN. Parameter alsoFilterInfinity, optional, is a boolean flag that determines if infinite values should also be excluded - defaults to true. |
|
|
FilterNaNTComputePhasorValue | Returns a series of values that represent a filtered set of the values in the source series where each value is a real number, i.e., value is not NaN. Parameter alsoFilterInfinity, optional, is a boolean flag that determines if infinite values should also be excluded - defaults to true. |
|
|
FilterOutliersT | Returns a series of values that represent the core data around the mean, excluding outliers, using Z-score. The confidence parameter, optional, is a floating-point value, suffixed with '%' representing a percentage, that must be greater than zero and less than one-hundred, that specifies the amount of data to retain around the mean, representing the central portion of the dataset - defaults to 95%. Second parameter, invertFilter, optional, is a boolean flag that determines if outliers should be rejected or retained - default is false, i.e., keep core data rejecting outliers; otherwise, true excludes core data and retains only outliers. Third parameter, minSamples, optional, is an integer value that specifies the minimum number of samples required for outlier detection - defaults to 20 for single series temporal analysis and 3 for multi-series slice analysis; if fewer samples are provided, the function returns the entire dataset unfiltered to ensure improved statistical validity of the Z-score calculations, or no data when invertFilter is true. If all values are considered identical, i.e., the standard deviation is zero, function will return the entire dataset unfiltered, or no data when invertFilter is true, since this represents a uniform distribution. The confidence parameter value can either be a constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
FilterOutliersTComputeMeasurementValue | Returns a series of values that represent the core data around the mean, excluding outliers, using Z-score. The confidence parameter, optional, is a floating-point value, suffixed with '%' representing a percentage, that must be greater than zero and less than one-hundred, that specifies the amount of data to retain around the mean, representing the central portion of the dataset - defaults to 95%. Second parameter, invertFilter, optional, is a boolean flag that determines if outliers should be rejected or retained - default is false, i.e., keep core data rejecting outliers; otherwise, true excludes core data and retains only outliers. Third parameter, minSamples, optional, is an integer value that specifies the minimum number of samples required for outlier detection - defaults to 20 for single series temporal analysis and 3 for multi-series slice analysis; if fewer samples are provided, the function returns the entire dataset unfiltered to ensure improved statistical validity of the Z-score calculations, or no data when invertFilter is true. If all values are considered identical, i.e., the standard deviation is zero, function will return the entire dataset unfiltered, or no data when invertFilter is true, since this represents a uniform distribution. The confidence parameter value can either be a constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
FilterOutliersTComputePhasorValue | Returns a series of values that represent the core data around the mean, excluding outliers, using Z-score. The confidence parameter, optional, is a floating-point value, suffixed with '%' representing a percentage, that must be greater than zero and less than one-hundred, that specifies the amount of data to retain around the mean, representing the central portion of the dataset - defaults to 95%. Second parameter, invertFilter, optional, is a boolean flag that determines if outliers should be rejected or retained - default is false, i.e., keep core data rejecting outliers; otherwise, true excludes core data and retains only outliers. Third parameter, minSamples, optional, is an integer value that specifies the minimum number of samples required for outlier detection - defaults to 20 for single series temporal analysis and 3 for multi-series slice analysis; if fewer samples are provided, the function returns the entire dataset unfiltered to ensure improved statistical validity of the Z-score calculations, or no data when invertFilter is true. If all values are considered identical, i.e., the standard deviation is zero, function will return the entire dataset unfiltered, or no data when invertFilter is true, since this represents a uniform distribution. The confidence parameter value can either be a constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
FirstT | Returns a series of N, or N% of total, values from the start of the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100 - defaults to 1. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
FirstTComputeMeasurementValue | Returns a series of N, or N% of total, values from the start of the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100 - defaults to 1. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
FirstTComputePhasorValue | Returns a series of N, or N% of total, values from the start of the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100 - defaults to 1. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
FloorT | Returns a series of values that represent the smallest integral value that is less than or equal to each of the values in the source series. |
|
|
FloorTComputeMeasurementValue | Returns a series of values that represent the smallest integral value that is less than or equal to each of the values in the source series. |
|
|
FloorTComputePhasorValue | Returns a series of values that represent the smallest integral value that is less than or equal to each of the values in the source series. |
|
|
IncludeRangeT | Returns a series of values that represent a filtered set of the values in the source series where each value falls between the specified low and high. The low and high parameter values are floating-point numbers that represent the range of values allowed in the return series. Third parameter, optional, is a boolean flag that determines if range values are inclusive, i.e., allowed values are >= low and <= high - defaults to false, which means values are exclusive, i.e., allowed values are > low and < high. Function allows a fourth optional parameter that is a boolean flag - when four parameters are provided, third parameter determines if low value is inclusive and forth parameter determines if high value is inclusive. The low and high parameter values can either be constant values or named targets available from the expression. |
|
|
IncludeRangeTComputeMeasurementValue | Returns a series of values that represent a filtered set of the values in the source series where each value falls between the specified low and high. The low and high parameter values are floating-point numbers that represent the range of values allowed in the return series. Third parameter, optional, is a boolean flag that determines if range values are inclusive, i.e., allowed values are >= low and <= high - defaults to false, which means values are exclusive, i.e., allowed values are > low and < high. Function allows a fourth optional parameter that is a boolean flag - when four parameters are provided, third parameter determines if low value is inclusive and forth parameter determines if high value is inclusive. The low and high parameter values can either be constant values or named targets available from the expression. |
|
|
IncludeRangeTComputePhasorValue | Returns a series of values that represent a filtered set of the values in the source series where each value falls between the specified low and high. The low and high parameter values are floating-point numbers that represent the range of values allowed in the return series. Third parameter, optional, is a boolean flag that determines if range values are inclusive, i.e., allowed values are >= low and <= high - defaults to false, which means values are exclusive, i.e., allowed values are > low and < high. Function allows a fourth optional parameter that is a boolean flag - when four parameters are provided, third parameter determines if low value is inclusive and forth parameter determines if high value is inclusive. The low and high parameter values can either be constant values or named targets available from the expression. |
|
|
IntervalT | Returns a series of values that represent a decimated set of the values in the source series based on the specified interval N, in time units. N is a floating-point value that must be greater than or equal to zero that represents the desired time interval, in time units, for the returned data. The unitsparameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. N can either be constant value or a named target available from the expression. |
|
|
IntervalTComputeMeasurementValue | Returns a series of values that represent a decimated set of the values in the source series based on the specified interval N, in time units. N is a floating-point value that must be greater than or equal to zero that represents the desired time interval, in time units, for the returned data. The unitsparameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. N can either be constant value or a named target available from the expression. |
|
|
IntervalTComputePhasorValue | Returns a series of values that represent a decimated set of the values in the source series based on the specified interval N, in time units. N is a floating-point value that must be greater than or equal to zero that represents the desired time interval, in time units, for the returned data. The unitsparameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. N can either be constant value or a named target available from the expression. |
|
|
KalmanFilterT | Returns a series of values that are passed though a Kalman filter which predicts the next state based on the current estimate useful for filtering out noise or reducing variance from a series of values. Optional parameters include processNoise which represents how much the system state is expected to change between measurements, measurementNoise which represents the confidence in the measurements, and estimatedError which represents the initial guess about the error in the state estimate. |
|
|
KalmanFilterTComputeMeasurementValue | Returns a series of values that are passed though a Kalman filter which predicts the next state based on the current estimate useful for filtering out noise or reducing variance from a series of values. Optional parameters include processNoise which represents how much the system state is expected to change between measurements, measurementNoise which represents the confidence in the measurements, and estimatedError which represents the initial guess about the error in the state estimate. |
|
|
KalmanFilterTComputePhasorValue | Returns a series of values that are passed though a Kalman filter which predicts the next state based on the current estimate useful for filtering out noise or reducing variance from a series of values. Optional parameters include processNoise which represents how much the system state is expected to change between measurements, measurementNoise which represents the confidence in the measurements, and estimatedError which represents the initial guess about the error in the state estimate. |
|
|
LabelT |
Renames a series with the specified label value. If multiple series are targeted, labels will be indexed starting at one, e.g., if there are three series
in the target expression with a label value of "Max", series would be labeled as "Max 1", "Max 2" and "Max 3". Group operations on this function will be ignored.
Label valueparameter can be optionally quoted with single or double quotes. The label parameter also supports substitutions when root target metadata can be resolved. For series values that directly map to a point tag, metadata value substitutions for the tag can be used in the label value - for example: {Alias}, {ID}, {SignalID}, {PointTag}, {AlternateTag}, {SignalReference}, {Device}, {FramesPerSecond}, {Protocol}, {ProtocolType}, {SignalType}, {EngineeringUnits}, {PhasorType}, {PhasorLabel}, {BaseKV}, {Company}, {Longitude}, {Latitude}, {Description}, etc. Each of these fields come from the "ActiveMeasurements" metadata source, as defined in the "ConfigurationEntity" table. Where applicable, substitutions can be used along with fixed label text in any combination, e.g.: 'Series {ID} [{PointTag}]'. Other metadata sources that target time-series measurements can also be used for substitutions so long the source is defined in the "ConfigurationEntity" table and the metadata columns include a "PointTag" field that can be matched to the target Grafana series name. To use any field from another defined metadata source, use the following substitution parameter format: {TableName.FieldName}. |
|
|
LabelTComputeMeasurementValue |
Renames a series with the specified label value. If multiple series are targeted, labels will be indexed starting at one, e.g., if there are three series
in the target expression with a label value of "Max", series would be labeled as "Max 1", "Max 2" and "Max 3". Group operations on this function will be ignored.
Label valueparameter can be optionally quoted with single or double quotes. The label parameter also supports substitutions when root target metadata can be resolved. For series values that directly map to a point tag, metadata value substitutions for the tag can be used in the label value - for example: {Alias}, {ID}, {SignalID}, {PointTag}, {AlternateTag}, {SignalReference}, {Device}, {FramesPerSecond}, {Protocol}, {ProtocolType}, {SignalType}, {EngineeringUnits}, {PhasorType}, {PhasorLabel}, {BaseKV}, {Company}, {Longitude}, {Latitude}, {Description}, etc. Each of these fields come from the "ActiveMeasurements" metadata source, as defined in the "ConfigurationEntity" table. Where applicable, substitutions can be used along with fixed label text in any combination, e.g.: 'Series {ID} [{PointTag}]'. Other metadata sources that target time-series measurements can also be used for substitutions so long the source is defined in the "ConfigurationEntity" table and the metadata columns include a "PointTag" field that can be matched to the target Grafana series name. To use any field from another defined metadata source, use the following substitution parameter format: {TableName.FieldName}. |
|
|
LabelTComputePhasorValue |
Renames a series with the specified label value. If multiple series are targeted, labels will be indexed starting at one, e.g., if there are three series
in the target expression with a label value of "Max", series would be labeled as "Max 1", "Max 2" and "Max 3". Group operations on this function will be ignored.
Label valueparameter can be optionally quoted with single or double quotes. The label parameter also supports substitutions when root target metadata can be resolved. For series values that directly map to a point tag, metadata value substitutions for the tag can be used in the label value - for example: {Alias}, {ID}, {SignalID}, {PointTag}, {AlternateTag}, {SignalReference}, {Device}, {FramesPerSecond}, {Protocol}, {ProtocolType}, {SignalType}, {EngineeringUnits}, {PhasorType}, {PhasorLabel}, {BaseKV}, {Company}, {Longitude}, {Latitude}, {Description}, etc. Each of these fields come from the "ActiveMeasurements" metadata source, as defined in the "ConfigurationEntity" table. Where applicable, substitutions can be used along with fixed label text in any combination, e.g.: 'Series {ID} [{PointTag}]'. Other metadata sources that target time-series measurements can also be used for substitutions so long the source is defined in the "ConfigurationEntity" table and the metadata columns include a "PointTag" field that can be matched to the target Grafana series name. To use any field from another defined metadata source, use the following substitution parameter format: {TableName.FieldName}. |
|
|
LastT | Returns a series of N, or N% of total, values from the end of the source series. N, optional, is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100 - defaults to 1. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
LastTComputeMeasurementValue | Returns a series of N, or N% of total, values from the end of the source series. N, optional, is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100 - defaults to 1. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
LastTComputePhasorValue | Returns a series of N, or N% of total, values from the end of the source series. N, optional, is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100 - defaults to 1. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
MaximumT | Returns a single value that is the maximum of the values in the source series. |
|
|
MaximumTComputeMeasurementValue | Returns a single value that is the maximum of the values in the source series. |
|
|
MaximumTComputePhasorValue | Returns a single value that is the maximum of the values in the source series. |
|
|
MedianT | Returns a single value that represents the median of the values in the source series. |
|
|
MedianTComputeMeasurementValue | Returns a single value that represents the median of the values in the source series. |
|
|
MedianTComputePhasorValue | Returns a single value that represents the median of the values in the source series. |
|
|
MinimumT | Returns a single value that is the minimum of the values in the source series. |
|
|
MinimumTComputeMeasurementValue | Returns a single value that is the minimum of the values in the source series. |
|
|
MinimumTComputePhasorValue | Returns a single value that is the minimum of the values in the source series. |
|
|
ModeT | Returns a single value that represents the mode of the values in the source series. The numberOfBins parameter is used to define how many bins to use when computing the mode for float-point values. A value of zero means use a majority-value algorithm which treats all inputs as integer-based values. When using a value of zero for the number of bins, user should consider using an integer function like RoundT, with zero digits, CeilingT, FloorT or TruncateT as an input to this function to ensure the conversion of values to integer-based values is handled as expected. |
|
|
ModeTComputeMeasurementValue | Returns a single value that represents the mode of the values in the source series. The numberOfBins parameter is used to define how many bins to use when computing the mode for float-point values. A value of zero means use a majority-value algorithm which treats all inputs as integer-based values. When using a value of zero for the number of bins, user should consider using an integer function like RoundT, with zero digits, CeilingT, FloorT or TruncateT as an input to this function to ensure the conversion of values to integer-based values is handled as expected. |
|
|
ModeTComputePhasorValue | Returns a single value that represents the mode of the values in the source series. The numberOfBins parameter is used to define how many bins to use when computing the mode for float-point values. A value of zero means use a majority-value algorithm which treats all inputs as integer-based values. When using a value of zero for the number of bins, user should consider using an integer function like RoundT, with zero digits, CeilingT, FloorT or TruncateT as an input to this function to ensure the conversion of values to integer-based values is handled as expected. |
|
|
ModuloT | Returns a series of values that represent each of the values in the source series modulo by N. N is a floating point value representing a divisive factor to be applied to each value the source series. N can either be constant value or a named target available from the expression. |
|
|
ModuloTComputeMeasurementValue | Returns a series of values that represent each of the values in the source series modulo by N. N is a floating point value representing a divisive factor to be applied to each value the source series. N can either be constant value or a named target available from the expression. |
|
|
ModuloTComputePhasorValue | Returns a series of values that represent each of the values in the source series modulo by N. N is a floating point value representing a divisive factor to be applied to each value the source series. N can either be constant value or a named target available from the expression. |
|
|
MovingAverageT | Returns a series of values that represent the moving average of the values in the source series. The windowSize parameter, optional, is a positive integer value representing a total number of windows to use for the moving average. If no windowSize is provided, the default value is the square root of the total input values in the series. The windowSize can either be a constant value or a named target available from the expression. Function operates using a simple moving average (SMA) algorithm. |
|
|
MovingAverageTComputeMeasurementValue | Returns a series of values that represent the moving average of the values in the source series. The windowSize parameter, optional, is a positive integer value representing a total number of windows to use for the moving average. If no windowSize is provided, the default value is the square root of the total input values in the series. The windowSize can either be a constant value or a named target available from the expression. Function operates using a simple moving average (SMA) algorithm. |
|
|
MovingAverageTComputePhasorValue | Returns a series of values that represent the moving average of the values in the source series. The windowSize parameter, optional, is a positive integer value representing a total number of windows to use for the moving average. If no windowSize is provided, the default value is the square root of the total input values in the series. The windowSize can either be a constant value or a named target available from the expression. Function operates using a simple moving average (SMA) algorithm. |
|
|
PercentileT | Returns a single value that represents the Nth order percentile for the sorted values in the source series. N is a floating point value, representing a percentage, that must range from 0 to 100. |
|
|
PercentileTComputeMeasurementValue | Returns a single value that represents the Nth order percentile for the sorted values in the source series. N is a floating point value, representing a percentage, that must range from 0 to 100. |
|
|
PercentileTComputePhasorValue | Returns a single value that represents the Nth order percentile for the sorted values in the source series. N is a floating point value, representing a percentage, that must range from 0 to 100. |
|
|
PowT | Returns a series of values that represent each of the values in the source series raised to the power of N. N is a floating point value representing an exponent used to raise each value of the source series to the specified power. N can either be constant value or a named target available from the expression. |
|
|
PowTComputeMeasurementValue | Returns a series of values that represent each of the values in the source series raised to the power of N. N is a floating point value representing an exponent used to raise each value of the source series to the specified power. N can either be constant value or a named target available from the expression. |
|
|
PowTComputePhasorValue | Returns a series of values that represent each of the values in the source series raised to the power of N. N is a floating point value representing an exponent used to raise each value of the source series to the specified power. N can either be constant value or a named target available from the expression. |
|
|
RandomT | Returns a series of N, or N% of total, values that are a random sample of the values in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Second parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
RandomTComputeMeasurementValue | Returns a series of N, or N% of total, values that are a random sample of the values in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Second parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
RandomTComputePhasorValue | Returns a series of N, or N% of total, values that are a random sample of the values in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Second parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
RangeT | Returns a single value that represents the range, i.e., maximum - minimum, of the values in the source series. |
|
|
RangeTComputeMeasurementValue | Returns a single value that represents the range, i.e., maximum - minimum, of the values in the source series. |
|
|
RangeTComputePhasorValue | Returns a single value that represents the range, i.e., maximum - minimum, of the values in the source series. |
|
|
ReferenceT | Returns a slice of angle differences to the first angle (i.e., the reference) for a series of angles. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. Parameter adjustCoordinateMidPoint, optional, is a boolean flag that determines if the metadata of the coordinate system, i.e., longitude/latitude values, should be adjusted to the midpoint between reference and the angle values in the slice - defaults to false. Parameter applyWrapOps, optional, is a boolean flag that determines if angles should be unwrapped before computing differences then rewrapped - defaults to true. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
ReferenceTComputeMeasurementValue | Returns a slice of angle differences to the first angle (i.e., the reference) for a series of angles. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. Parameter adjustCoordinateMidPoint, optional, is a boolean flag that determines if the metadata of the coordinate system, i.e., longitude/latitude values, should be adjusted to the midpoint between reference and the angle values in the slice - defaults to false. Parameter applyWrapOps, optional, is a boolean flag that determines if angles should be unwrapped before computing differences then rewrapped - defaults to true. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
ReferenceTComputePhasorValue | Returns a slice of angle differences to the first angle (i.e., the reference) for a series of angles. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. Parameter adjustCoordinateMidPoint, optional, is a boolean flag that determines if the metadata of the coordinate system, i.e., longitude/latitude values, should be adjusted to the midpoint between reference and the angle values in the slice - defaults to false. Parameter applyWrapOps, optional, is a boolean flag that determines if angles should be unwrapped before computing differences then rewrapped - defaults to true. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
RollingAverageT | Returns a series of values that represent the rolling average of the values in the source series. The windowSize parameter, optional, is a positive integer value representing a total number of data points to use for each of the values in the rolling average results. If no windowSize is provided, the default value is the square root of the total input values in the series. The windowSize can either be constant value or a named target available from the expression. Function operates by producing a mean over each data window. |
|
|
RollingAverageTComputeMeasurementValue | Returns a series of values that represent the rolling average of the values in the source series. The windowSize parameter, optional, is a positive integer value representing a total number of data points to use for each of the values in the rolling average results. If no windowSize is provided, the default value is the square root of the total input values in the series. The windowSize can either be constant value or a named target available from the expression. Function operates by producing a mean over each data window. |
|
|
RollingAverageTComputePhasorValue | Returns a series of values that represent the rolling average of the values in the source series. The windowSize parameter, optional, is a positive integer value representing a total number of data points to use for each of the values in the rolling average results. If no windowSize is provided, the default value is the square root of the total input values in the series. The windowSize can either be constant value or a named target available from the expression. Function operates by producing a mean over each data window. |
|
|
RoundT | Returns a series of values that represent the rounded value, with specified fractional digits, of each of the values in the source series. Parameter digits, optional, is a positive integer value representing the number of decimal places in the return value - defaults to 0. |
|
|
RoundTComputeMeasurementValue | Returns a series of values that represent the rounded value, with specified fractional digits, of each of the values in the source series. Parameter digits, optional, is a positive integer value representing the number of decimal places in the return value - defaults to 0. |
|
|
RoundTComputePhasorValue | Returns a series of values that represent the rounded value, with specified fractional digits, of each of the values in the source series. Parameter digits, optional, is a positive integer value representing the number of decimal places in the return value - defaults to 0. |
|
|
ScaleT | Returns a series of values that represent each of the values in the source series scaled by N. N is a floating point value representing a scaling factor (multiplier or reciprocal) to be applied to each value the source series. N can either be constant value or a named target available from the expression. The asReciprocal is a boolean parameter that, when true, requests that N be treated as a reciprocal, i.e., 1 / N, thus resulting in a division operation instead of multiplication - defaults to false. |
|
|
ScaleTComputeMeasurementValue | Returns a series of values that represent each of the values in the source series scaled by N. N is a floating point value representing a scaling factor (multiplier or reciprocal) to be applied to each value the source series. N can either be constant value or a named target available from the expression. The asReciprocal is a boolean parameter that, when true, requests that N be treated as a reciprocal, i.e., 1 / N, thus resulting in a division operation instead of multiplication - defaults to false. |
|
|
ScaleTComputePhasorValue | Returns a series of values that represent each of the values in the source series scaled by N. N is a floating point value representing a scaling factor (multiplier or reciprocal) to be applied to each value the source series. N can either be constant value or a named target available from the expression. The asReciprocal is a boolean parameter that, when true, requests that N be treated as a reciprocal, i.e., 1 / N, thus resulting in a division operation instead of multiplication - defaults to false. |
|
|
ShiftT | Returns a series of values that represent each of the values in the source series shifted by N. N is a floating point value representing an additive (positive or negative) offset to be applied to each value the source series. N can either be constant value or a named target available from the expression. |
|
|
ShiftTComputeMeasurementValue | Returns a series of values that represent each of the values in the source series shifted by N. N is a floating point value representing an additive (positive or negative) offset to be applied to each value the source series. N can either be constant value or a named target available from the expression. |
|
|
ShiftTComputePhasorValue | Returns a series of values that represent each of the values in the source series shifted by N. N is a floating point value representing an additive (positive or negative) offset to be applied to each value the source series. N can either be constant value or a named target available from the expression. |
|
|
SqrtT | Returns a series of values that represent the square root each of the values in the source series. |
|
|
SqrtTComputeMeasurementValue | Returns a series of values that represent the square root each of the values in the source series. |
|
|
SqrtTComputePhasorValue | Returns a series of values that represent the square root each of the values in the source series. |
|
|
StandardDeviationT | Returns a single value that represents the standard deviation of the values in the source series. Parameter useSampleCalc, optional, is a boolean flag representing if the sample based calculation should be used - defaults to false, which means the population based calculation should be used. |
|
|
StandardDeviationTComputeMeasurementValue | Returns a single value that represents the standard deviation of the values in the source series. Parameter useSampleCalc, optional, is a boolean flag representing if the sample based calculation should be used - defaults to false, which means the population based calculation should be used. |
|
|
StandardDeviationTComputePhasorValue | Returns a single value that represents the standard deviation of the values in the source series. Parameter useSampleCalc, optional, is a boolean flag representing if the sample based calculation should be used - defaults to false, which means the population based calculation should be used. |
|
|
SwitchT | Returns a single value selected using the first series of a slice of values as the zero-based index from the remaining series. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. |
|
|
SwitchTComputeMeasurementValue | Returns a single value selected using the first series of a slice of values as the zero-based index from the remaining series. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. |
|
|
SwitchTComputePhasorValue | Returns a single value selected using the first series of a slice of values as the zero-based index from the remaining series. The sliceTolerance parameter is a floating-point value that must be greater than or equal to 0.001 that represents the desired time tolerance, in seconds, for the time slice. |
|
|
TimeDifferenceT | Returns a series of values that represent the time difference, in time units, between consecutive values in the source series. The units parameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. |
|
|
TimeDifferenceTComputeMeasurementValue | Returns a series of values that represent the time difference, in time units, between consecutive values in the source series. The units parameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. |
|
|
TimeDifferenceTComputePhasorValue | Returns a series of values that represent the time difference, in time units, between consecutive values in the source series. The units parameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Seconds. |
|
|
TimeIntegrationT | Returns a single value that represents the time-based integration, i.e., the sum of V(n) * (T(n) - T(n-1)) where time difference is calculated in the specified time units of the values in the source series. The unitsparameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Hours. |
|
|
TimeIntegrationTComputeMeasurementValue | Returns a single value that represents the time-based integration, i.e., the sum of V(n) * (T(n) - T(n-1)) where time difference is calculated in the specified time units of the values in the source series. The unitsparameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Hours. |
|
|
TimeIntegrationTComputePhasorValue | Returns a single value that represents the time-based integration, i.e., the sum of V(n) * (T(n) - T(n-1)) where time difference is calculated in the specified time units of the values in the source series. The unitsparameter, optional, specifies the type of time units and must be one of the following: Seconds, Nanoseconds, Microseconds, Milliseconds, Minutes, Hours, Days, Weeks, Ke (i.e., traditional Chinese unit of decimal time), Ticks (i.e., 100-nanosecond intervals), PlanckTime or AtomicUnitsOfTime - defaults to Hours. |
|
|
TopT | Returns a series of N, or N% of total, values that are the largest in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Third parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
TopTComputeMeasurementValue | Returns a series of N, or N% of total, values that are the largest in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Third parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
TopTComputePhasorValue | Returns a series of N, or N% of total, values that are the largest in the source series. N is either a positive integer value, representing a total, that is greater than zero - or - a floating point value, suffixed with '%' representing a percentage, that must range from greater than 0 to less than or equal to 100. Third parameter, optional, is a boolean flag representing if time in dataset should be normalized - defaults to true. N can either be constant value or a named target available from the expression. Any target values that fall between 0 and 1 will be treated as a percentage. |
|
|
TotalT | Returns a single value that represents the sum of the values in the source series. |
|
|
TotalTComputeMeasurementValue | Returns a single value that represents the sum of the values in the source series. |
|
|
TotalTComputePhasorValue | Returns a single value that represents the sum of the values in the source series. |
|
|
TruncateT | Returns a series of values that represent the integral part of each of the values in the source series. |
|
|
TruncateTComputeMeasurementValue | Returns a series of values that represent the integral part of each of the values in the source series. |
|
|
TruncateTComputePhasorValue | Returns a series of values that represent the integral part of each of the values in the source series. |
|
|
UnwrapAngleT | Returns a series of values that represent an adjusted set of angles that are unwrapped, per specified angle units, so that a comparable mathematical operation can be executed. For example, for angles that wrap between -180 and +180 degrees, this algorithm unwraps the values to make the values mathematically comparable. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
UnwrapAngleTComputeMeasurementValue | Returns a series of values that represent an adjusted set of angles that are unwrapped, per specified angle units, so that a comparable mathematical operation can be executed. For example, for angles that wrap between -180 and +180 degrees, this algorithm unwraps the values to make the values mathematically comparable. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
UnwrapAngleTComputePhasorValue | Returns a series of values that represent an adjusted set of angles that are unwrapped, per specified angle units, so that a comparable mathematical operation can be executed. For example, for angles that wrap between -180 and +180 degrees, this algorithm unwraps the values to make the values mathematically comparable. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
WrapAngleT | Returns a series of values that represent an adjusted set of angles that are wrapped, per specified angle units, so that angle values are consistently between -180 and +180 degrees. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
WrapAngleTComputeMeasurementValue | Returns a series of values that represent an adjusted set of angles that are wrapped, per specified angle units, so that angle values are consistently between -180 and +180 degrees. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |
|
|
WrapAngleTComputePhasorValue | Returns a series of values that represent an adjusted set of angles that are wrapped, per specified angle units, so that angle values are consistently between -180 and +180 degrees. The unitsparameter, optional, specifies the type of angle units and must be one of the following: Degrees, Radians, Grads, ArcMinutes, ArcSeconds or AngularMil - defaults to Degrees. |