Format

Description

Formats numbers, time and timestamp.

Format on Vector will result in a comma-separated list of formatted values. E.g.: Device Link Car, Fronius Symo

Format on GroupedScalar will result in a comma-separated list of group identifier, double-quote and formatted value; the group identifier is rendered as device name, if grouped by device, else the time span index is taken. E.g.: 'Device Link Car': 1035, 'Fronius Symo': 8012

Format on GroupedVector will result in a slash-separated list of group identifier, double-quote and comma-separated formatted values; the group identifier is rendered as device name, if grouped by device, else the time span index is taken. E.g.: 'Device Link Car': 1035, 2012, 3097 / 'Fronius Symo': 8012

Signatures

#scalar-vector-groupedscalar-groupedvector-less-than-number-event-greater-than-or-scalar-less-than-te

#scalar-vector-groupedscalar-groupedvector-less-than-time-greater-than-or-scalar-less-than-text-great

#scalar-vector-groupedscalar-groupedvector-less-than-timespan-greater-than-or-scalar-less-than-text-g

#scalar-vector-groupedscalar-groupedvector-less-than-timespan-greater-than-or-adaptive-or-seconds-or

Number/Event | Text

Scalar<Number/Event> | Scalar<Text>Scalar<Text>
Vector<Number/Event> | Scalar<Text>Scalar<Text>
GroupedScalar<Number/Event> | Scalar<Text>Scalar<Text>
GroupedVector<Number/Event> | Scalar<Text>Scalar<Text>

Format pattern semantic, see Java's DecimalFormat


Time | Text

Scalar<Time> | Scalar<Text>Scalar<Text>
Vector<Time> | Scalar<Text>Scalar<Text>
GroupedScalar<Time> | Scalar<Text>Scalar<Text>
GroupedVector<Time> | Scalar<Text>Scalar<Text>

Format pattern semantic, see Java's SimpleDateFormat


Timespan | Text

Scalar<Time> | Scalar<Text>Scalar<Text>
Vector<Time> | Scalar<Text>Scalar<Text>
GroupedScalar<Time> | Scalar<Text>Scalar<Text>
GroupedVector<Time> | Scalar<Text>Scalar<Text>

Format pattern semantic, see Java's SimpleDateFormat


Timespan | '(ADAPTIVE|SECONDS|MINUTES|HOURS|DAYS):(WORD|SYMBOL)'

Scalar<Time> | '(ADAPTIVE|SECONDS|MINUTES|HOURS|DAYS):(WORD|SYMBOL)'Scalar<Text>
Vector<Time> | '(ADAPTIVE|SECONDS|MINUTES|HOURS|DAYS):(WORD|SYMBOL)'Scalar<Text>
GroupedScalar<Time> | '(ADAPTIVE|SECONDS|MINUTES|HOURS|DAYS):(WORD|SYMBOL)'Scalar<Text>
GroupedVector<Time> | '(ADAPTIVE|SECONDS|MINUTES|HOURS|DAYS):(WORD|SYMBOL)'Scalar<Text>

Format pattern semantic

ValueDescription

ADAPATIVE

Means that it chooses the time unit automatically depending on the value size

SECONDS

Redners the value in seconds.

MINUTES

Renders the value in minutes.

HOURS

Renders the value in hours.

DAYS

Renders the value days.

WORD

Is in the word form (e.g. Hours)

SYMBOL

Is in the abbreviation of the unit (e.g. h)

Examples

Format the Result of the AVG($Consumption) function (which is a Scalar<Number) in format '#,##0'.

AVG($Consumption) | '#,##0'

Format the Timestamp of the $Event (which is Scalar<Event>) as hours and minutes.

$Event::Timestamp | 'HH:mm'

Fromat the resulting Timestamp as Hours suffixed with the word Hours.

(now - $Event::Timestamp) | 'HOURS:WORD'

Last updated

© 2023 MOOST AG