edimar
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.
Hi @edimar
Metabase does not support duration/interval in the GUI:
https://github.com/metabase/metabase/issues/8875 - upvote by clicking
on the first post
So you'll need to make a calculation like that in SQL.
1 Like
edimar
3
Thank you @flamber, I create the calculation in SQL directly.