PromQL query to sort by numbers

[Tom005]

I have a metric that I'd like to sort by numbers.

Currently it is sorted like this:
0, 1, 11, 12, 13... 2, 20,21... etc.

I'd like it to go like this:

0, 1, 2, 3, 3...10, 11, 12... etc.

Is that possible?

Thanks 

[Stuart Clark]

How do you mean you have a metric sorted like that?

Do you mean that you have a metric with the given values for a
particular time period?

Or are you referring to the value of one of the metric's labels?

[Tom005]

Sorry, yeah I actually meant the metric labels, I'd like to sort from the metric label in that order.

[Stuart Clark]

On 30/11/2020 13:06, Tom005 wrote:
> Sorry, yeah I actually meant the metric labels, I'd like to sort from
> the metric label in that order.
>

How data is displayed is up to whatever system is doing the API query.
For example Grafana has various sort options.

[Tom005]

Right, I am using grafana to display. Is there a way to do that do you know? 

Appreciate that it might be going slightly off topic away from Prometheus. 

[Stuart Clark]

On 30/11/2020 13:31, Tom005 wrote:
> Right, I am using grafana to display. Is there a way to do that do you
> know?
> Appreciate that it might be going slightly off topic away from
> Prometheus.
>

Exactly how you do it will depend on the visualisation you are using and
the version. For example for a table you can use the transform options
to convert labels into fields and decide what to show, click on the
field to sort. You can also set the default sorting.

[Tom005]

Ok yeah, I can see that and I can do that. 

I'm actually using the graph visualisation though, which I need. Is there a way to sort from that? 

[Stuart Clark]

On 30/11/2020 13:44, Tom005 wrote:
> Ok yeah, I can see that and I can do that.
> I'm actually using the graph visualisation though, which I need. Is
> there a way to sort from that?
>

I'm not an expert, so you might be better asking the Grafana people, but
google does mention how to do it via the JSON, but I'm sure there is a
way in the UI:

https://github.com/grafana/grafana/issues/2640#issuecomment-606012950

[Julien Pivotto]

That kind of sort is on the roadmap but it will still take a few time
before we have it.

> --
> You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/f4451964-3c3d-af4b-f406-4bb58597f516%40Jahingo.com.

--
Julien Pivotto
@roidelapluie

[Tom005]

Ok thanks guys. It's a bit annoying I will say. 

My use case is that I'm monitoring CPU cores, and it goes 0, 1, 10, 11 which is just annoying as I said. 

Look forward to the release.