Disable sort

(Makoto Taguchi) #1

Hi, is there any way to disable the sort in dashboard table?



(Talal) #2

Hey Makoto,

Looker is able to remove table sorting only for downloads. You’ll see the checkbox in the download modal. All other queries will have an ORDER BY clause in SQL.
If you’d like to tell me a little more about your use case, I’d be happy to help you get the results you want. Also, I can pass your suggestion along to the product team.

Look on!


(Lucas van Walstijn) #3

Hi Talal,

I have the same question. My use-case is that I want to show the following table:

This dimension is based on a bunch of case-when’s. My requirements:
[1] show those categories with a zero count (for example “No Information from CS”
[2] don’t show the row where no value for this dimension exists (see the last row -> None values).

To solve [2] I first added a filter, (Ops Maintenance State is any value) but then Looker stopped showing me the categories with a zero count (requirement [1]), so now I removed the filter but then it naturally also shows this last row.

To get rid of that row, Im using the “dont show last 1 row”… but that ofcourse depends on the sorting of the table… If I reverse the ordering than the row that I want to get rid of moves to the top and is erroneously displayed (and another row that does need to be shown is not being shown)…

So it would be important to disable sorting by the end-user.

Any ideas how to solve this?


(Talal) #4

Hey @lucas.van.walstijn,

I have a couple of ideas to resolve both issues and allow you to not worry about the sort order, but they’ll require some additional details on your use case. Do you mind sending an email to help.looker.com? We can take it from there and get you to where you need to be!