'date' style for number fields automatically providing results such as 10m12s, 1h13m, 2d13h?


Context: we have a number field which relates to a time span/duration (how long someone is spending on a task). In dashboards, we often need to show totals or averages on these durations

Problem: if we visualize totals of the duration, we need to (1) use a custom formula to indicate whether it should be expressed in minutes, hours or days, (2) identify the style in the dashboard of the number (setting decimals, ...). But then we could have like 0.001 hours and 3,000 hours in the same column/result.

Need: I'm looking if there would be a way to indicate that a duration should be correctly represented based on order of magnitude, so having for example 10m12s, 1h13m, 2d13h in the same column/result.


Hi @extren
Duration is currently not supported:
https://github.com/metabase/metabase/issues/8875 - upvote by clicking :+1: on the first post