databricks-widget-pivot

What problem does it solve?

Pivot widgets in Databricks Lakeview dashboards often require complex JSON structures to define rows, columns, and cells. This Skill provides comprehensive guidance and templates to build correct pivot JSON and ensure consistent behavior.

Core Features & Use Cases

• Complete JSON reference for pivot widgets, including fields, cubeGroupingSets, encodings, and cell formatting
• Templates and rules for color scales, custom sorts, and multi-cell values
• Use cases: create dashboards with multi-dimensional analysis (e.g., region × time) and ensure reliable rendering across datasets

Quick Start

Copy and adapt a ready-to-use pivot JSON template to your dataset and deploy to Lakeview.