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

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

Value	Description
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'