Convert duration ms to sec

[RickT]

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 ?
Thanks

[flash1293 (Joe Reuter)]

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

[RickT]

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

[RickT]

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