I have documents which contain an ES login-history field, and the ES documents have the login history in reverse chronological order. The problem I have is that Kibana always presents the dates in ascending order when if the date field is in the selected query attributes, or in the 'Table' view of a record. If I click the JSON view things look fine, e.g.:
"login-history": [
1464884262941,
1464877491523,
1464876396375,
1464802504594,
1464276153017,
1464275650052,
1464275616108,
1464275192750,
1464270502451,
1464201004285
]
But when printed any other way in query results (TABLE record view, query results), they appear this way:
May 25th 2016, 14:30:04.285, May 26th 2016, 09:48:22.451, May 26th 2016, 11:06:32.750, May 26th 2016, 11:13:36.108, May 26th 2016, 11:14:10.052, May 26th 2016, 11:22:33.017, June 1st 2016, 13:35:04.594, June 2nd 2016, 10:06:36.375, June 2nd 2016, 10:24:51.523, June 2nd 2016, 12:17:42.941
How can I get Kibana (Version 4.5) to present the data as it is ordered in the record instead of reordering the data when it formats the dates?