Hi Have a date column with 02:01 :03 like this then how can I display it in user readable format.
ex : 02:01 :03 to 2h 1m 5 sec
No easy way to do that. You’d have to do few things:
This could be of help: https://help.looker.com/hc/en-us/articles/4420187817491-Creating-hour-minute-durations-in-visualisat...
dimension: elaped_formatted {
type: number
sql: ${seconds_elapsed} ;;
html: {% assign h = {{value}} | divided_by: 3600 %}{% assign m = minutes_elapsed._value | modulo: 60 %}{% assign s = seconds_elapsed._value | modulo: 60 %}{{h}}h{{m}}m{{s}}s;;
}