Measure type of an amount of time

I have a dimension that represents the duration of a media in seconds, which is currently typed as a number.

I want to create measures to display the sum/average of all medias in a readable way, something that looks like one below:

  • 2 days, 4 hours, 8 minutes and 50 seconds
  • 4931 seconds
  • 5 hours

Unfortunately I can’t find anything like that in the documentation. Is it possible to get that kind of display ? I tried to play a bit with dates format but that was unsuccessful.

0 replies

Be the first to reply!