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?
To change to duration when displayed (so that all charting functions still work), do this:
| fieldformat totalCDsec=tostring(totalCDsec,"duration")
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")
thanks! But do you think I could convert from that tostring to duration?
You can using the eval syntax I provided. Will work for table visualization.