Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
I had emailed romain.ducarrouge (looker support) last year and he was able to check it and said that it was bug.
I am not sure how you inferred that “What it looks like @ima.adesi was running into is expected, since the queries were actually different (different columns selected)” . If you read my post which says " I find that looker sends two identical queries to database and they both get executed. So it does not appear to be helping with what I am trying to do, which is executing query once and using that data into different tiles/looks on a dashboard." Also I sent my case to support and they confirmed that It was not working as expected. But I have not followed on this to know what the current status is.
The Url that gets opened in first one is following https://d-looker.zzz.zzz.com/dashboards/2439?username=abcd_efgh https://d-looker.zzz.zzz.com/dashboards/2439?username=&filter_config={"username":[{"type":"%3D","values":[{},{}],"id":0}]} If you see second line, the value of parameter username gets ommited. for the second case above https://d-looker.zzz.zzz.com/dashboards/2439?username=abcdefgh https://d-looker.zzz.zzz.com/dashboards/2439?username=abcdefgh&filter_config={"username":[{"type":"%3D","values":[{"constant":"abcdefgh"},{}],"id":0}]}
thanks Krishna
Thanks, each of my dashboards has 10 to 15 individual charts/graphs. currently what I do is to make changes to one and then copy the lookml to a text editor and then globally replace connection and then save as different dashboard. I do this for every connection, so I have to do 10 global replaces. Is there an easy way to do this?
Thanks, I am currently using links like you suggested so that users can easy access them but my issue here is that I am trying to solve two issues 1)Having too many dashboards with exact same thing 2)Then the issue of maintaining them
Thanks, this confirms what I experienced. I have sent details to support after being asked by support to do so. May be the fix could be that looker should generate all sqls first and then send the unique ones to database.
Thanks Jesse, I had seen that post earlier but thought that it may not be applicable in my case but after reading your post I did try it but I find that looker sends two identical queries to database and they both get executed. So it does not appear to be helping with what I am trying to do, which is executing query once and using that data into different tiles/looks on a dashboard.
Already have an account? Login
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.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
