I have the following search:
...| convert dur2sec("Call Duration") as "CDinsec" | stats sum(CDinsec) as "totalCDsec", avg(CDinsec) as "avgCDinsec" by Company
which give me this result:
How can I change the value from totalCDsec and avgCDinsec (currently in second) to duration so that I could put it in a double column bar chart?
YOu can convert using eval-tostring function but once converted to duration (string), you won't be able to plot it in chart (chart series should've numerical values). FYI, the conversion to duration would be like this:
| eval totalCDsec=tostring(totalCDsec,"duration")
To change to duration when displayed (so that all charting functions still work), do this:
| fieldformat totalCDsec=tostring(totalCDsec,"duration")