Convert duration ms to sec

Today i'm searching how to convert a duration field from ms to sec into a line visualization.
as i can't change the advanced params or create a scripted field, i'm trying with the "json input" field but i'm not sure it's today possible (kibana v7.8.1).
Have you a solution please ?

The duration formatter which is part of the index pattern should allow you to do this: Manage index pattern data fields | Kibana Guide [7.15] | Elastic

thanks Joe,
but i can't manage index pattern (reserved for admin :frowning: )
So i try to find another solution. Is it possible in the "json input" of my visualization ?

i found... alone ! :slight_smile:
in json input ==>>> {"script": "doc['duration_field'].value / 1000.0"}

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.