Need to see if is there a option to avoid order by in SQL but in display it still have it. Reason is, we have 6 looks on the dashboard with same dimensions and measures, only different is order by field. Becasu of order by field only Looker run 6 queries in place of one, which is affecting performacne of the dashbaord. If somehow we can remove order by from teh SQL then the sql for all 6 looks will be the same and it will run only one SQL. Is it makes sense 🙂
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.