How to create a view with more than 3 pivoted dimensions?

Looker Q&A Looker
,
1

Good afternoon,

I’m having trouble creating a view with more than 3 pivoted dimensions; I haven’t found a visualization that allows this type of action.

image
image619×226 7.98 KB

2

Hey,

Hope you’re keeping well.

Looker’s native pivot functionality in Explores and Looks currently supports a maximum of 3 pivoted dimensions in a single visualization. If you need to work with more than 3, you’ll need to either reduce the number of pivots or reshape your data in the underlying LookML model, for example by pre‑pivoting in the SQL or using derived tables in your view. Another option is to export the results to BigQuery or Sheets for post‑processing and visualization outside Looker.

Thanks and regards,
Taz

1 Like