topic Sort not working in the Data Explorer in Dashboarding

Sort not working in the Data Explorer

mhlamine — Thu, 25 May 2023 13:36:54 GMT

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"))

Re: Sort not working in data explorer

mgome — Fri, 04 Feb 2022 18:17:11 GMT

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))

Re: Sort not working in data explorer

mhlamine — Mon, 07 Feb 2022 00:19:45 GMT

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.