Data Grid — Pivot Mode & Column Visualizations
The Data Grid widget follows the same Data / Customization pattern as other widgets, but adds two powerful features unique to grids: Pivot Mode and Column Visualizations.
Pivot Mode
When you select a Data Grid widget, a Pivot Mode panel appears in the right rail with:
- A list of available columns (checkboxes)
- A Row Groups drop zone (drag a column here to group rows by it)
- A Values drop zone (drag a column here to aggregate)
- A Filters tab
Figure 7.1a — Pivot Mode in context.
Column Visualizations
Open Edit Data Grid and pick a Data Source. The Display tab lists each selected column with its visualization (e.g., a country-flag icon next to Country/Region). Use Add Data to pick more columns or Edit Visualization to change how a column renders.
Figure 8.3a — Edit Data Grid Display tab.
Clicking Edit Visualization opens the Visualize Data for Data Grid modal. Each field row exposes a Visualization dropdown.
Figure 8.3b — Visualize Data for Data Grid modal.
Visualization Options
- Standard — default text cell
- Progress Bar — fills proportionally to a threshold; Input 1 = min, Input 2 = max
- Star — star rating; Input 1 = max star count
- Currency — formatted with a currency code (Input 1)
- Country Flag — small flag icon next to the value, mapped via ISO country codes
Figure 8.3c — Visualization dropdown options.
Click Save to apply. The Data Grid re-renders with the new column visualizations and a confirmation toast appears.
Figure 8.3d — Data Grid with country flags applied.