How can I set the y-axis on my bar chart to be in duration?

[tamduong16]

I have the following search:

....| stats sum(callduration) as "totalcallduration" by Companycalls

Currently my search give me the result in second. I'm trying to get this result convert to duration so that I could map it on my bar chart. Is there an option that splunk could map bar chart for duration like excel? I want to get it to look like this:

[jkat54]

Try this:

...| stats sum(callduration) as totalcallduration by Companycalls | eval totalcallduration=tostring(totalcallduration,"duration")

[tamduong16]

This work great but when I select the chart. My chart doesn't display anything.

[tamduong16]

By this I mean the y-axis display number like 0-1000 instead of time. And at the end splunk generate an empty bar chart

[jkat54]

Is the totalcallduration field in seconds?

[tamduong16]

YES! Please help

[jkat54]

What I gave you worked when I gave it random seconds in the totalcallduration field and it charted it.

[tamduong16]

But this is for data showing purposes, I can not replace the second with just random second. Is there anything else I could do?