Hi,
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.
Thanks!