Knowledge Drop

Default Explore/Drill Sort (Order By) Behavior

  • 5 April 2021
  • 1 reply
  • 347 views

Userlevel 5
Badge
  • Looker Staff
  • 162 replies

Last Tested: March 15, 2021

 

In the explore and drill menus, Looker chooses a default field to sort on:

  1. The first date dimension, descending. If no date dimension exists...

  2. The first measure, descending. If no measure exists...

  3. The first added dimension (ascending)

As of Looker 4.10, these defaults cannot be edited for either the explore or drill menu.

There is a feature request at https://feedback.us.pendo.io/app/#/case/17670.

If you're interested in a workaround, see an example using the liquid link variable below:

  measure: returned_count {    type: count_distinct    sql: ${id} ;;    filters: {      field: is_returned      value: "yes"    }    drill_fields: [detail*]    link: {label: "Explore Top 20 Results" url: "{{    returned_count._link}}&sorts=order_items.sale_price+desc&limit=20" }  }

 

This content is subject to limited support.                

 

 


1 reply

Hi Sam I tried to Sort Date field using your solution some way it did not work can you help it

 

Reply