Hello,
I am using a Time Range Selector in a dashboard. The range precision is the minute level.
I need to specify second level precision in the time range. How can I do that?
Definitely won’t be able to get that functionality with just a singular `is in range` filter - range time filtering only gives (currently) precision to a minute range. Probably the easiest way to handle this though would be to have a number dimension (that has the seconds) and add a second filter that specifies the range of seconds.
Eg: say this is the original dimension group you’re filtering on
```
dimension_group: my_time_field {
type: time
sql: ${TABLE}.time_field ;;
}
```
Have another dimension that does:
```
dimension: seconds {
type: number
sql: EXTRACT( seconds FROM ${TABLE}.time_field ;;
}
```
Then filter on that. The `EXTRACT()` function there would need to be whatever your dialect’s equivalent of that function is. You can also use a little known LookML param if you don’t want to look up your dialect’s time functions, `expression`:
```
dimension: seconds_hacky {
type: number
expression: extract_seconds(${TABLE}.time_field ;;
}
```
`expression` lets you use many table calc functions in LookML, in lieu of writing SQL in a `sql` parameter - Looker then translates that into SQL at runtime. Note, there are limitations to `expression` and there is no documentation, so use at your own risk 🙂