Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Explores

Discovering Data in Looker

  • 582 Topics
  • 1,512 Replies

582 Topics

L
Looker Staff
lindseyLooker Staff
asked in Explores

What happens when you click Rebuild Derived Tables

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

1
nbeyer
Looker Staff
7 years ago
M
msh210Member
asked in Explores

How to combine minor dimension values into an "Other" value

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.

9
L
Looker Staff
7 years ago
L
Looker Staff
lindseyLooker Staff
asked in Explores

Why does my account setup link take me to the login page?

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.

0
L
Looker Staff
7 years ago
R
rebeccavickery15
asked in Explores

Is there a normdist calculation in looker?

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?

2
R
7 years ago
brayden
braydenMember
asked in Explores

Drilling into a field to get a pivot table

Is it possible to set up a drill down field, so that when I click on it, I get a new table that is already pivoted? I’m imagining using this to drill into some large top-line metrics, breaking the results out into both date and regions at the same time.

2
colin
Looker Staff
7 years ago
anika
Looker Staff
anikaLooker Staff
asked in Explores

Some AdBlock Plugins block Explores with 'ad' in the name

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.

0
anika
Looker Staff
7 years ago
anika
Looker Staff
anikaLooker Staff
posted in Explores

About the Exploring category

Discovering data in Looker

0
anika
Looker Staff
7 years ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service