Discovering Data in Looker
- 582 Topics
- 1,512 Replies
Note: for Looker-hosted instances, this option will only work if the table takes less than 1 hour to rebuild (due to browser timeouts). When you query data from a persistent derived table in Explore, there will be an option in the gear dropdown in the upper right to Rebuild Derived Tables. Clicking this will cause all the persistent derived table(s) referenced in the query to immediately rebuild, as well as all PDTs that those PDTs depend on to rebuild. Another way to look at it is that clicking Rebuild Derived Tables ensures that this query will be run with all the freshest possible data. Note: Clicking Rebuild Derived Tables will cause the PDTs referenced in the Look to be inaccessible for only the user who clicked the button while they rebuild. While they are building, all other users will be able to query the already-built tables. Once the tables finish rebuilding, all users will be querying these new tables
Is there a way to do in a Look what the following does in SQL? select if( c in ('Anchorage','Fairbanks','Juneau'),-- that is, the c column has one of those values -- then c, -- else 'Other' ) as city, count(*) -- or another aggregate function from t group by city; This groups not by the column in the table itself but by that same column with some values combined into one.
If you have just had an account set up on your Looker, you will receive a setup email with a link to finish setting up your account. When you click this link, it may take you to a login page (rather than a page prompting you to finish setting up your account). This is happening because LDAP or SAML is enabled on your Looker instance. These services allow users to log in using a common username and password across multiple sites. If you know what your common username/password are, log in with those credentials! If you are unsure what those credentials are, talk to an administrator for your Looker. They will be able to point you in the right direction.
I am trying to add a statistical significance calculation to my table using table calculations in looker. I have got to a z-score using the standard functions available but cannot find a way to turn this into a p-value. Is there something like the normdist function found in excel and R that I can use in looker, or is this something that may be coming in the future?
Do you have a version of AdBlock installed on your browser? We have come across some versions of AdBlock occasionally not allowing users to access certain models or explores that have “ad” in the name. You can test whether this might be the problem by running the query in Incognito mode, or in a different browser. If you whitelist looker.com in your AdBlock extension, this should prevent this from happening again. For more information on how to whitelist domains in AdBlocker, checkout this YouTube how-to video.
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.