Skip to content

Text Widget

The Text widget displays text content directly on the dashboard. The content can be static (e.g., a note or instructions) or dynamically populated with live data from an SQL query.

This allows information, key figures, or notes to be placed prominently on the dashboard.

Typical Use Cases

Use Case Example Content
Daily summary Today: {{open_orders}} open orders, {{revenue_today}} € revenue
Welcome message Static greeting or team announcements on the start page.
Process notes Next invoice run: {{next_run_date}}
Live metrics Open tickets: {{ticket_count}} · Avg. response time: {{avg_time}} min
Team info On leave today: {{absent_count}} · Available: {{available_count}}
SLA status SLA compliance this month: {{sla_percent}} %

Features

  • Static text: Simple text displayed as-is (e.g., a welcome message, note, or instructions).
  • Dynamic placeholders: Using the {{fieldname}} syntax, values from an SQL query can be embedded.
  • SQL query: An SQL query provides the data for the placeholders. The first result row is used.
  • Text alignment: The text can be aligned left, center, or right.
  • Automatic refresh: When underlying data changes, the text is reloaded automatically and visually highlighted.

Configuration

The following settings are configured in the properties panel:

  1. Text content: The text to display. Placeholders in the format {{fieldname}} are replaced with values from the SQL query.
  2. SQL query (optional): An SQL query that provides the data for the placeholders.
  3. Alignment (optional): Left, center, or right.

Placeholder Syntax

Placeholders are written in double curly braces:

There are currently {{open_orders}} open orders.

The placeholder names must match the column names of the SQL query. When the query returns a column named open_orders, its value is automatically inserted.

Example

A team dashboard contains a text widget with the following content: "Today's workload: {{open}} open orders, {{overdue}} of which are overdue." The associated SQL query retrieves the current count of open and overdue orders from the Data Lake.

Tips

  • Without SQL: Without an SQL query, the text is displayed statically – placeholders are not replaced.
  • Highlight key figures: Combined with placeholders and an appropriate SQL query, live numbers can be embedded directly in text.
  • Notes and instructions: Static text widgets are great for providing team information or process guidelines directly on the dashboard.