How to round the results to the nearest 15 minutes

[Sue_Wright]

I’m very new to Looker. I’m working on a table calculation where the total hours between the Start Time and End Time will be rounded to the nearest 15 minutes. In Excel I can use the FLOOR or CEILING to make this happen.

What can I use in Looker to get the same results?

[Cyril_MTL_Analy]

Hello @Sue_Wright and welcome!

You can actually use those same functions in a table calculation.

Although that is also possible to do in LookML (and recommended if you need to reuse this)

[Sue_Wright]

@Cyril_MTL_Analy. Thank-you this is extremely helpful!