For anyone looking to format using integers: stat_name=sales | timechart sum(total_price) AS total | eval cents = substr(total, -2) | eval dollars = substr(total, 1, len(total) - 2) | eval Revenue = "$" + tostring(dollars, "commas") + "." + cents ... View more

A combination of rename and convert worked for me: | rename _time as Day | convert timeformat="%Y/%m/%d" ctime(Day) Thanks! ... View more