Knowledge Drop

Default Explore/Drill Sort (Order By) Behavior

  • 5 April 2021
  • 1 reply

Userlevel 5
  • Looker Staff
  • 173 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

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