Sort not working in the Data Explorer

[mhlamine]

Hi, 

I am trying to add a Data Explorer tile in dashboard but results are not well sorted.

Here is the metric query code:

builtin:synthetic.browser.availability.location.total:splitBy("dt.entity.synthetic_test"):auto:sort(value(auto,ascending),dimension("dt.entity.synthetic_test",ascending)):limit(100):partition("Status",value("ok",ge(100)),value("nok",lt(100))):filter(ne("Status","ok"))

[mgome · Accepted solution]

Have you tried moving your sort to the end of your code?

builtin:synthetic.browser.availability.location.total:splitBy("dt.entity.synthetic_test"):auto:limit(100):partition("Status",value("ok",ge(100)),value("nok",lt(100))):filter(ne("Status","ok")):sort(value(auto,ascending),dimension("dt.entity.synthetic_test",ascending))

[mhlamine]

Thanks it's working if you move the sort to the end of the code, but it is not specified in the documentation. I think it's a bug and should be fixed.