Time Range selector - second precision

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?

e38fbde1-4bb2-44d8-a406-3ed0c1c344d8.png
0 1 261
1 REPLY 1

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 🙂

Top Labels in this Space
Top Solution Authors