Adding hours to a time field

Get Help
1

Hi,

I have a requirement to add a certain amount of hours to a time field based on the value in another field.

example: if value in field A = 1, then add 4 hours to time field
if value in field A = 2, then add 8 hours to time field

Please let me know if this achievable in metabase. if yes, then how should I proceed.

Thanks

2

Hi @PD98
There's work being done to make this possible in the GUI:
https://github.com/metabase/metabase/issues/19274
Until then, use SQL or create a View on your database.