Hi
I have a duration field of type number having duration in milliseconds. I want to take the average of it, and show it in kibana dashboard metrics as dd:hh:mm:ss format, or basically run a script over the average value to customise the format.
I have tried using scripted field to convert it to a human readable format. though it works perfectly for me, but then when i search for the scripted field in kibana dashboard, it gives me query_shard_exception.
so first question, can i make this scripted field as non-searchable? how?
second question, can i do the same thing using runtime field? where i can specify the format as duration and output format as "human-readable"?
The end goal is to show average duration in a human readable format in kibana metrics, and the field should be either searchable or doesn't show up in the search at all.
I am using 7.17 version.