I'd like to sort a box plot that's using a formatted date:
The times are all muddled because formatDate converts the date to string
Here's my query:
| formatDate(_messagetime, "EEE") as day
| where !(day="Sat" or day="Sun")
| timeslice 24h
| formatDate(_timeslice, "dd MMM yyyy") as Date
| min(time_taken), pct(time_taken,25), pct(time_taken,50), pct(time_taken, 99) as _pct_75, max(time_taken) by Date
| sort by Date desc
If I add a "sort by _timeslice" line before the formatDate, the query takes forever. Is there a better way to sort the chart?
Please sign in to leave a comment.