search

metabase / metabase

The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:
https://metabase.com
Other
38.08k stars 5.05k forks source link

Add duration / time interval special types #8875

Open henriqueschmidt opened 5 years ago

henriqueschmidt commented 5 years ago

Hello, I have a bar graph, which pulls data from the database as a number. This number represents the total time that someone was talking on the phone. When this number is less then 60s, it's ok to show the number "as is". When this number is greater then 60s, like 72 seconds, i would like to see it as 00:01:12. In other tool, like grafana, i could describe the column as "seconds" so the charts was formating the value properly. Is it possible to do the same in metabase? issue

Depends on #2656

:arrow_down: Please click the :+1: reaction instead of leaving a +1 or update? comment

tlrobinson commented 5 years ago

This isn't currently possible, at least not without writing the question in SQL.

We could add "Duration (seconds)" etc special type and format accordingly.

mazameli commented 5 years ago

Reopening this as the request is still valid.

mazameli commented 5 years ago

A WIP implementation PR is here: https://github.com/metabase/metabase/pull/9224

lutvdh commented 3 years ago

@mazameli , is this capability on the roadmap for the near future?