Change order of datetime as string dimension in dropdown filter?

I have a select number of datetimes which indicate when an application ran - I want dashboard users to be able to select the run from a filter without having to type in the full datetime. I can achieve this by creating a dimension (type string) of the datetime and then filtering on it. LookML and resulting screenshot below:

dimension_group: start_time {
type: time
timeframes: [
raw,
time
]
datatype: datetime
sql: ${TABLE}.start_time ;;
}

dimension: time_string {
type: string
sql: ${start_time_time} ;;
}

andre165893225_0-1697712375524.png

The issue is that I would prefer the order of the suggested fields to be descending ie. the latest time first. How do I achieve this? The field will have values added to it ie. new application runs, so I can't hard-code an order using `order_by_field`. Neither is cross-filtering on the dashboard an option, as I have tiles that I don't  want to be affected by the filter. 

0 2 319
2 REPLIES 2

I'm also having the same issue. Please some one help to solve this .

You can try creating a derived table of dates and id column, order it by desc and join it with the relevant explore so that it only filters out those specific explores.

Top Labels in this Space