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} ;;
}
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.
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.