Zum Inhalt springen

Data Types

Dieser Inhalt ist noch nicht in deiner Sprache verfügbar.

Data types tell Rokks how a field can be sorted, filtered, aggregated, displayed, and used in alerts.

Type Type Description
Text Field type Names, categories, statuses, and labels.
Number Field type Measures that can be summed, averaged, ranked, or compared.
Timestamp Field type Dates and times used for timelines, ordering, and schedules.
Boolean Field type True or false flags.
Enum Field type Controlled sets of known values.
JSON-like value Field type Nested or semi-structured content that may need transformation before analysis.

SQL preview responses preserve SQL NULL as JSON null. PostgreSQL non-finite floating-point values use the strings "NaN", "Infinity", and "-Infinity" because JSON numbers cannot represent them truthfully.

Use a timestamp for order date, a number for revenue, and text or enum for order status.