Convert Minutes in to hour in Kibana field "TotalDuration"

[Vivek_Nigam]

Hi,
I calulating sum of TotalDuration field in kibana , TotalDuration field is in Minutes.
i want to convert minutes in to Hours while dispalying in kibana visulization .

I tried json input :
{
"script": {
"inline1":"doc['TotalDuration'].value / 60",
"lang":"painless"
}
}

getting visulization error . Please advise.

[nickpeihl]

Hi @Vivek_Nigam. "getting visualization error" does not give us enough information. Do you see specific errors in your browser? Maybe you can share a screenshot?

[Vivek_Nigam]

Thanks , Now i am getting the value using below script but output hours are not correct.
{
"script": {
"inline":"doc['sessionDurationMinutes'].value/60",
"lang":"painless"
}
}

Hours Value getting:

But correct Hours value is :

[nickpeihl]

Hi @Vivek_Nigam. What version of Kibana are you using? Also, what is the mapping for the fields you are using?

[Vivek_Nigam]

Kibana version :7.9.1

[nickpeihl]

Thanks. Can you also answer this?

@nickpeihl

Also, what is the mapping for the fields you are using?