databricks-widget-pivot

To build pivot widget JSON for Lakeview dashboards, you copy a ready-to-use template and adapt it to your dataset. This enforces strict schema rules, including spec.version 3, ensuring proper row and column encodings for reliable rendering.

CubeGroupingSets in pivot widgets define multi-dimensional data groupings for your dashboard cells. You need them when creating dashboards that require multi-dimensional analysis, such as region by time matrices, to ensure data aggregates correctly.

You apply color-scale formatting by defining rules within your pivot widget JSON encodings. This provides templates and rules for color scales, ensuring consistent cell formatting and visual data representation across your dashboards.

Pivot widgets fail to render due to misaligned fieldName mappings because strict schema rules require consistent alignment between query fields and encodings. Enforcing this mapping ensures the widget operates reliably across datasets.

Yes, you can display disaggregated data in a Lakeview pivot widget by configuring the JSON structure accordingly. The schema supports disaggregated data alongside cubeGroupingSets, allowing flexible multi-dimensional analysis without forced aggregation.

The best way to validate pivot widget JSON is to check it against strict schema rules, ensuring spec.version 3 and field alignment between query and encodings. This validation process ensures reliable operation before deploying to your Lakeview dashboards.