Why are my Quick Start Pivots not Showing Up?

[shivanisankar]

Knowledge Drop

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.

Example:

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.