Knowledge Drop

Why are my Quick Start Pivots not Showing Up?

Last tested: Feb 9, 2021

Even if you have a value in the pivot subparameter of your query parameter, queries with pivots need to have the pivot defined in both pivots AND in dimensions.


query: orders_by_brand_name { 
dimensions: [products.brand, products.category]
measures: [products.count, order_items.order_count]
pivots: [products.category]
description: "Orders by brand name"
limit: 500


You can see that products.category is included in both the dimensions and pivots subparameter.


This content is subject to limited support.                



0 replies

Be the first to reply!