Kibana visualizations - Apply operations on value returned by a metric

I have a visualization where I have a metric field that contains the sum of durations (in millisecond), I want to show it in (hh:mm:ss) form, is that possible?

I think you have two options for this use case:

  • set the field format as Duration type and configure it. This will have an effect on all visualizations for this field.
  • create a runtime_field which takes the original field and configure the format only for the runtime version as Duration, so you can use either the original or runtime versions depending on the use case.

In both cases configure as follow the panel (check also the short suffix version):