Filter order is wrong

bonomi
New Member

Hi!

I just created a query and added a series of OR filters for one field and pivoted by that field

I decided I didn’t like the order of the series, so I removed some ORs from the top and added them at the bottom.

But the resulting visualization is sticking to the original order. How do I rearrange this without starting over?

38117b79-6e86-49ae-9474-a769571adcfd.png
0 1 774
1 REPLY 1

Hello!

I am still pretty new to Looker, but one thing I know is that Looker likes to organize everything in alphabetical order by default. Changing the order of the filters will not change the way the visualization appears. 

If there is a specific order that would be intuitive for your organization, then the appropriate dimension or measure can use the order_by_field. (see https://docs.looker.com/reference/field-params/order_by_field )

If there are columns appearing after you have adjusted the filters that should not be showing(there are 7 filtered items in your image but 11 columns), you may need to hit the Run button again to update the visualization.

Top Labels in this Space