How to create sum in field type time (HH:mm)

Get Help
#1

Hello guys,
I need to help to do sum with field from type time, datetime and timestamp.
For example, I have the 3 rows like:

| date | time |

2020-01-01 | 02:30

2020-01-01 | 01:30

2020-01-01 | 04:30

I need to "sum(time) group by date" out => 2020-01-01 08:30

How do that in metabase please?

Thank you all.

#2

Hi @edimar
Metabase does not support duration/interval in the GUI:
https://github.com/metabase/metabase/issues/8875 - upvote by clicking :+1: on the first post
So you'll need to make a calculation like that in SQL.

1 Like
#3

Thank you @flamber, I create the calculation in SQL directly.