Dashboard

The Dashboard provides a consolidated view of your test status through configurable widgets — metric cards, charts, and tables.

Overview

Image: Dashboard with multiple widgets: metric cards, bar chart, and table

Multiple Dashboards

QANode supports multiple dashboards with different visibility settings:

Widgets

Widget Types

Creating a Widget

The widget creation wizard has 3 steps:

Step 1: Data Source

Define where the data will come from:

Query Builder (Recommended):

Filter Logic: Combine multiple filters using AND or OR operators.

Date Formatting in Grouping:

Direct SQL:

For more complex queries, use SQL mode with the Monaco editor. Prefer Query Builder for simple widgets and use SQL when you need CTEs, joins, conditional aggregations, or calculations that would be hard to express in the builder:

SELECT
  DATE("startedAt") AS day,
  status,
  COUNT(*)::int AS total
FROM "Run"
WHERE "isSandbox" = false
  AND "startedAt" >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY day, status
ORDER BY day;

SQL mode requires the dashboard.sql permission.

SQL also supports CTEs (Common Table Expressions) with the WITH clause. Queries that modify data (INSERT, UPDATE, DELETE, DROP, etc.) remain blocked.

Step 2: Visualization

Choose the chart type and map the fields:

Step 3: Appearance

Conditional Formatting (for cards and tables):

Tables With Progress

In table widgets, numeric columns can be shown as progress bars. This is useful for tracking:

• project progress;
• success percentage;
• scenario coverage;
• SLA consumption;
• pipeline progress.

Each progress column can have its own color and minimum/maximum values. Text fields, IDs, and dates are not recommended for progress.

Conditional Formatting In Tables

Conditional formatting rules let you highlight rows or cells based on values returned by the query.

Examples:

Use conditional formatting to draw attention to issues, but avoid applying too many colors at the same time.

Dashboard Layout

The dashboard uses a responsive 12-column grid:

Rearranging Widgets

• Drag a widget to reposition it
• Resize by dragging the bottom-right corner
• The grid adjusts automatically to prevent overlaps
• Default widget sizes are optimized by type: metrics are smaller, while charts and tables start larger.

Widget Examples

Card: Success Rate

Table: runs
Aggregation: COUNT(*)
Filter: status = "success" AND started_at >= today - 30 days

Bar Chart: Executions per Day

Table: runs
Grouping: started_at (date only)
Aggregation: COUNT(*)
Pivot: status
Type: Bar

Result: Stacked bars with different colors for success/failure per day.

Table: Latest Failures

Table: runs
Filter: status = "failed"
Columns: flow name, date, duration, error
Sorting: started_at DESC
Limit: 10

Auto-Refresh

Widgets can be configured to refresh automatically at defined intervals, keeping data always up to date.

Tips

• Start simple — a metric card with total executions + a daily bar chart
• Use conditional formatting to highlight issues (rate below 80% = red)
• Team dashboards — create dashboards with role-based visibility
• Use pivot mode to create charts with multiple series without SQL
• Limit your data — large queries can impact performance