Chronograf: Add option to specify sort order for Default Sort Field

[stevebang]

Chronograf 1.5

• Without an option to specify the sort order for Default Sort Field, users cannot create a Top N ranking, sorted from higher to lower.

Note: IFQL only has an ORDER BY time DESC clause that is limited to timestamps. Also, by default, InfluxDB returns results in ascending time order.

[vogler]

Is this doable (in any way) by now? I wanted to have the latest events at the top of some table. ORDER BY time DESC doesn't change anything.
Even if I reverse the order in the UI, it changes back to ASC with the next update (cf. #4828).

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[vogler]

Bump.
Is there something speaking against this? Seems like a small thing.

[vogler]

https://github.com/influxdata/chronograf/blob/9f8d3983e3953de56d793d3bc956ef091ed1f5a9/ui/src/dashboards/components/TableOptions.tsx#L40
https://github.com/influxdata/chronograf/blob/8f6b1da84d1be9ef6a3fe1df1b51165968047798/ui/src/shared/components/TableGraphFormat.tsx#L113

Are those the only files that need to be adjusted?

[kahveci]

I am using the latest stable TICK stack, and I have the same issue as @vogler. It seems like ORDER BY time DESC does not work at all for table visualisations on Chronograf.

[afausti]

+1 it would be really useful to have ORDER BY time DESC working in a Chronograf table.

[moinoviimir]

+1, would be very nice to have.

[DConcord]

+1, thanks!

[canselcik]

It would be great if this feature existed. ORDER BY time DESC is doing nothing on a Chronograf table.

[SeaMonkey82]

+1 Yes, I would like this.

[let4be]

Any update? We really need this feature...

[YarmoM]

This would indeed be a welcome feature.

[tomoyk]

I want to use this order option. 👍

[Shaquu]

How is this not a thing already?

[achilleas-k]

Workaround for tables:
I've resorted to adding an extra field that's the inverse of the one I want to sort by, sorting by that one, and hiding it.

[Shaquu]

@achilleas-k you did with time field?

[achilleas-k]

@achilleas-k you did with time field?

No, I do it with a table of values (CPU load).