Grafana sort on two fields

[paramsbindra]

I googled and did not find satisfactory solution. I need to sort table columns ( endtime and value). It’s Prometheus data source. I do see one field sort transformation though, that does not suffice the purpose.

Please see below:

expected result:
2020-11-17 Open
2020-11-17 Not a Finding
2020-11-17 Not Reviewed
similarly for 2021-11-17 and 2022-11-17

Please help!
Thanks!

[yosiasz]

Might this Transformation work for you?

[paramsbindra]

Thanks! It sorts only on one field. Need to sort on 2 fields.

[yosiasz]

Than add another additional one

[paramsbindra]

The second one will supersede the first one. There is no way to add primary and secondary fields sort. Thanks though