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.

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.                

 

 


0 replies

Be the first to reply!

Reply