Looker Help Center

<!DOCTYPE html> <html dir="ltr" lang="en-US"> <head><script type="text/javascript" src="https://web-static.archive.org/_static/js/bundle-playback.js?v=7YQSqjSh" charset="utf-8"></script> <script type="text/javascript" src="https://web-static.archive.org/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script>window.RufflePlayer=window.RufflePlayer||{};window.RufflePlayer.config={"autoplay":"on","unmuteOverlay":"hidden"};</script> <script type="text/javascript" src="https://web-static.archive.org/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("https://help.looker.com/hc/en-us","20210609032437","https://web.archive.org/","web","https://web-static.archive.org/_static/", "1623209077"); </script> <link rel="stylesheet" type="text/css" href="https://web-static.archive.org/_static/css/banner-styles.css?v=p7PEIJWi" /> <link rel="stylesheet" type="text/css" href="https://web-static.archive.org/_static/css/iconochive.css?v=3PDvdIFv" />  <meta charset="utf-8"/>  <title>Looker Help Center</title> <meta name="csrf-param" content="authenticity_token"/> <meta name="csrf-token" content=""/> <link rel="canonical" href="https://web.archive.org/web/20210609032437/https://help.looker.com/hc/en-us"/> <link rel="alternate" hreflang="en" href="https://web.archive.org/web/20210609032437/https://help.looker.com/hc/en-us"/> <link rel="stylesheet" media="all" href="//web.archive.org/web/20210609032437cs_/https://static.zdassets.com/hc/assets/application-79172500fb4dbec2484043d570946543.css" id="stylesheet"/>  <link rel="stylesheet" media="all" href="//web.archive.org/web/20210609032437cs_/https://static.zdassets.com/hc/assets/theming_v1_support-cf937686d5b6669242017892da7bad78.css"/> <link rel="stylesheet" type="text/css" href="//web.archive.org/web/20210609032437cs_/https://p19.zdassets.com/hc/theming_assets/487723/387764/style.css?digest=4401477873939"> <link rel="shortcut icon" type="image/x-icon" href="//web.archive.org/web/20210609032437im_/https://theme.zdassets.com/theme_assets/487723/977bcc50bd123a8d1e024c285781288399ea8cf1.png"/> <script src="//web.archive.org/web/20210609032437js_/https://static.zdassets.com/hc/assets/jquery-d5395f0b7ac5027403fc17855c46dbfc.js"></script> <meta content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" name="viewport"/> <meta class="swiftype" name="site-priority" data-type="integer" content="4"> <meta class="swiftype" name="site-filter" data-type="integer" content="4"> <meta class="swiftype" name="site-filter" data-type="integer" content="24"> <meta class="swiftype" name="site-filter" data-type="integer" content="34"> <link href="https://web.archive.org/web/20210609032437cs_/https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://web.archive.org/web/20210609032437cs_/https://fonts.googleapis.com/css?family=Google+Sans:400,500|Roboto:400,400italic,500,500italic,700,700italic|Roboto+Mono:400,500,700|Material+Icons">  <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://web.archive.org/web/20210609032437/https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-NWWX6K');</script>  <script type="text/javascript" src="//web.archive.org/web/20210609032437js_/https://p19.zdassets.com/hc/theming_assets/487723/387764/script.js?digest=4401477873939"></script> <script async src="/web/20210609032437js_/https://help.looker.com/cdn-cgi/bm/cv/669835187/api.js"></script></head> <body class="">  <noscript><iframe src="https://web.archive.org/web/20210609032437if_/https://www.googletagmanager.com/ns.html?id=GTM-NWWX6K" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="new-menu"> <div class="user-guide-nav" data-swiftype-index="false"> <div class="container center-align"> <a href="https://web.archive.org/web/20210609032437/https://looker.com/" class="nav-logo"> <img src="https://web.archive.org/web/20210609032437im_/https://looker.com/assets/img/images/logos/looker.svg" alt="Looker"> </a> <div id="nav-icon3" class=""> <span></span> <span></span> <span></span> <span></span> </div> <div class="ug-nav"> <ul> <li> <a href="https://web.archive.org/web/20210609032437/https://looker.com/guide" class="custres-gtm-nav-link"> User Guide </a> </li> <li> <a href="https://web.archive.org/web/20210609032437/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> </li> <li> <a href="https://web.archive.org/web/20210609032437/https://help.looker.com/" class="custres-gtm-nav-link active"> Help Center </a> </li> <li> <a href="https://web.archive.org/web/20210609032437/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </li> <li> <a href="https://web.archive.org/web/20210609032437/https://community.looker.com/" class="custres-gtm-nav-link"> Community </a> </li> <li> <a href="https://web.archive.org/web/20210609032437/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </li> <li> <a href="https://web.archive.org/web/20210609032437/https://looker.com/certification" class="custres-gtm-nav-link"> Certification </a> </li> </ul> </div> <div class="mobile-nav left-align"> <p> <a href="https://web.archive.org/web/20210609032437/https://looker.com/guide" class="custres-gtm-nav-link"> User Guide </a> </p> <p> <a href="https://web.archive.org/web/20210609032437/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> </p> <p> <a href="https://web.archive.org/web/20210609032437/https://help.looker.com/hc" class="custres-gtm-nav-link"> Help Center </a> </p> <p> <a href="https://web.archive.org/web/20210609032437/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </p> <p> <a href="https://web.archive.org/web/20210609032437/https://community.looker.com/" class="custres-gtm-nav-link"> Community </a> </p> <p> <a href="https://web.archive.org/web/20210609032437/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </p> <p> <a href="https://web.archive.org/web/20210609032437/https://looker.com/certification" class="custres-gtm-nav-link"> Certification </a> </p> </div> </div> </div> </div> <div class="header-outer"> <header class="header"> <div class="logo"> <a title="Home" href="/web/20210609032437/https://help.looker.com/hc/en-us"> <img src="//web.archive.org/web/20210609032437im_/https://theme.zdassets.com/theme_assets/487723/74c81f85fcdd84777050bf90f59784d6aa649daa.png" alt="Logo"> </a> </div> <div class="nav-wrapper"> <span class="icon-menu"></span> <a class="login" data-auth-action="signin" role="button" rel="nofollow" title="Opens a dialog" href="/web/20210609032437/https://help.looker.com/hc/en-us/signin?return_to=https%3A%2F%2Fhelp.looker.com%2Fhc%2Fen-us&locale=en-us">Sign in</a> </div> </header> </div> <main role="main"> <meta class="swiftype" name="description" data-type="string" content="Your most commonly asked questions, answered."> <section class="hero"> <div class="hero-inner"> <h1 class="title"> Help Center </h1> <form role="search" class="search search-full" data-search="" data-instant="true" autocomplete="off" action="/web/20210609032437/https://help.looker.com/hc/en-us/search" accept-charset="UTF-8" method="get"><input name="utf8" type="hidden" value="✓"/><input type="search" name="query" id="query" placeholder="Search" autocomplete="off" aria-label="Search"/></form> <p class="search-description">Search for anything. For example: <a class="search-suggestion" href="/web/20210609032437/https://help.looker.com/hc/en-us/search?query=lookml">lookml</a>, <a class="search-suggestion" href="/web/20210609032437/https://help.looker.com/hc/en-us/search?query=best+practices">best practices</a>, <a class="search-suggestion" href="/web/20210609032437/https://help.looker.com/hc/en-us/search?query=primary+key">primary key</a></p> </div> <a href="https://web.archive.org/web/20210609032437/https://help.looker.com/hc/en-us/signin?return_to=https%3A%2F%2Fhelp.looker.com%2Fhc%2Fen-us%2Frequests&locale=en-us" class="contact-blocks-item"> <div class="contact-blocks-item-title">Contact Us</div> </a> </section> <div class="grey-bg"> <div class="container"> <section class="section knowledge-base"> <section class="categories blocks"> <ul class="blocks-list"> <li class="blocks-item"> <a href="/web/20210609032437/https://help.looker.com/hc/en-us/categories/360000085528-Browsing-Data" class="blocks-item-link">       <h2 class="blocks-item-title">Browsing Data</h2> <p class="blocks-item-description">Viewing, organizing, and sharing content.</p> </a> </li> <li class="blocks-item"> <a href="/web/20210609032437/https://help.looker.com/hc/en-us/categories/360000085548-Exploring-Data" class="blocks-item-link">       <h2 class="blocks-item-title">Exploring Data</h2> <p class="blocks-item-description">Creating compelling visualizations and designing robust queries.</p> </a> </li> <li class="blocks-item"> <a href="/web/20210609032437/https://help.looker.com/hc/en-us/categories/360000085568-Development" class="blocks-item-link">       <h2 class="blocks-item-title">Development</h2> <p class="blocks-item-description">Writing LookML and SQL, and how to solve problems and troubleshoot errors.</p> </a> </li> <li class="blocks-item"> <a href="/web/20210609032437/https://help.looker.com/hc/en-us/categories/360000085607-Administration" class="blocks-item-link">       <h2 class="blocks-item-title">Administration</h2> <p class="blocks-item-description">Configuring Looker and optimizing it for your unique needs.</p> </a> </li> <li class="blocks-item"> <a href="/web/20210609032437/https://help.looker.com/hc/en-us/categories/360000085627-API-and-Embed" class="blocks-item-link">       <h2 class="blocks-item-title">API and Embed</h2> <p class="blocks-item-description">Working with the Looker API and embedded Looks and Dashboards.</p> </a> </li> <li class="blocks-item"> <a href="/web/20210609032437/https://help.looker.com/hc/en-us/categories/360001988353-General-Information-Announcements" class="blocks-item-link">       <h2 class="blocks-item-title">General Information & Announcements</h2> <p class="blocks-item-description">General information about Looker support</p> </a> </li> </ul> </section> <section class="articles"> <h2 style="margin-bottom: 30px">Popular Articles</h2> <ul class="article-list promoted-articles"> <li class="promoted-articles-item"> <a href="/web/20210609032437/https://help.looker.com/hc/en-us/articles/360001288108-Dynamically-Select-Fields-Using-Parameters"> Dynamically Select Fields Using Parameters </a> </li> </ul> </section> </section> <section class="section community"> <h2 style="margin-bottom: 30px">Not finding the help you need?</h2> <ul class="blocks-list"> <li class="blocks-item"> <a href="https://web.archive.org/web/20210609032437/https://community.looker.com/" class="blocks-item-link"> <h2 class="blocks-item-title"> Ask the Community </h2> <p class="blocks-item-description">Connect with and learn from data peers.</p> </a> </li> <li class="blocks-item"> <a href="https://web.archive.org/web/20210609032437/https://help.looker.com/hc/en-us/signin?return_to=https%3A%2F%2Fhelp.looker.com%2Fhc%2Fen-us%2Frequests&locale=en-us" class="blocks-item-link"> <h2 class="blocks-item-title"> Contact Support </h2> <p class="blocks-item-description">Contact our Support team.</p> </a> </li> </ul> </section> <section class="section activity"> <div data-app="recent-activity" data-url="/web/20210609032437oe_/https://help.looker.com/hc/api/internal/recent_activities?locale=en-us"></div> </section> </div> </div> </main> <footer class="footer"> <div style="text-align:center"> © <script>document.write(new Date().getFullYear())</script> Looker Data Sciences, Inc.<br><a href="https://web.archive.org/web/20210609032437/https://looker.com/privacy">Privacy</a> | <a href="https://web.archive.org/web/20210609032437/https://looker.com/terms">Terms</a> | <a href="https://web.archive.org/web/20210609032437/https://looker.com/trust-center/privacy/cookies">Cookies</a> </div> <div class="footer-inner"> <div class="footer-language-selector"> </div> </div> </footer>  <script src="//web.archive.org/web/20210609032437js_/https://static.zdassets.com/hc/assets/en-us.446c81d0dfd893cfe7e4.js"></script> <script src="https://web.archive.org/web/20210609032437js_/https://looker.zendesk.com/auth/v2/host.js" data-brand-id="387764" data-return-to="https://help.looker.com/hc/en-us" data-theme="hc" data-locale="en-us" data-auth-origin="387764,true,true"></script> <script type="text/javascript"> /* Greetings sourcecode lurker! This is for internal Zendesk and legacy usage, we don't support or guarantee any of these values so please don't build stuff on top of them. */ HelpCenter = {}; HelpCenter.account = {"subdomain":"looker","environment":"production","name":"Looker"}; HelpCenter.user = {"identifier":"da39a3ee5e6b4b0d3255bfef95601890afd80709","email":null,"name":null,"role":"anonymous","avatar_url":"https://web.archive.org/web/20210609032437/https://assets.zendesk.com/hc/assets/default_avatar.png","is_admin":false,"organizations":[],"groups":[]}; HelpCenter.internal = {"asset_url":"//web.archive.org/web/20210609032437/https://static.zdassets.com/hc/assets/","web_widget_asset_composer_url":"https://web.archive.org/web/20210609032437/https://static.zdassets.com/ekr/snippet.js","current_session":{"locale":"en-us","csrf_token":null,"shared_csrf_token":null},"settings":{},"usage_tracking":{"event":"front_page_viewed","data":"BAh7BjoKX21ldGF7CzoPYWNjb3VudF9pZGkDK3EHOhNoZWxwX2NlbnRlcl9pZGkE1D3sCzoNYnJhbmRfaWRpA7TqBToMdXNlcl9pZDA6E3VzZXJfcm9sZV9uYW1lSSIOQU5PTllNT1VTBjoGRVQ6C2xvY2FsZUkiCmVuLXVzBjsLVA==--5e88e207c156298843152a3072ad7eaec27e153e","url":"https://web.archive.org/web/20210609032437/https://help.looker.com/hc/activity"},"current_record_id":null,"current_record_url":null,"current_record_title":null,"search_results_count":null,"current_text_direction":"ltr","current_brand":{"account_id":487723,"brand_id":387764,"brand_url":"https://web.archive.org/web/20210609032437/https://help.looker.com","url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/api/v2/brands/387764.json","name":"Looker","logo":"https://web.archive.org/web/20210609032437/https://help.looker.com/system/brands/360000023528/2_thumb.png","subdomain":"looker","host_mapping":"help.looker.com","help_center_state":"enabled","ticket_form_ids":null,"active":true,"default":true,"has_help_center":true,"created_at":"2014-05-02T06:41:40Z","updated_at":"2021-06-03T09:01:45Z","id":387764,"route_id":159873},"current_brand_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com","current_host_mapping":"help.looker.com","current_path":null,"authentication_domain":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com","show_autocomplete_breadcrumbs":true,"rollbar_config":{"enabled":true,"endpoint":"https://web.archive.org/web/20210609032437/https://rollbar-us.zendesk.com/api/1/item/","accessToken":"731a5a953e9a4b7ab6cac9623f50c732","captureUncaught":true,"captureUnhandledRejections":true,"payload":{"environment":"production","client":{"javascript":{"source_map_enabled":true,"code_version":"9f2677f23ce4ae234e08358b71b81a27f1ec7e79","guess_uncaught_frames":true}}}},"user_info_changing_enabled":false,"has_user_profiles_enabled":false,"has_end_user_attachments":true,"user_aliases_enabled":false,"has_anonymous_kb_voting":false,"has_multi_language_help_center":true,"mobile_device":false,"mobile_site_enabled":false,"show_at_mentions":false,"embeddables_config":{"embeddables_web_widget":false,"embeddables_connect_ipms":false},"base_domain":"zendesk.com","answer_bot_subdomain":"static","manage_content_url":"https://web.archive.org/web/20210609032437/https://help.looker.com/hc/en-us","arrange_content_url":"https://web.archive.org/web/20210609032437/https://help.looker.com/hc/admin/arrange_contents?locale=en-us","general_settings_url":"https://web.archive.org/web/20210609032437/https://help.looker.com/hc/admin/general_settings?locale=en-us","user_segments_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/knowledge/user_segments?brand_id=387764","has_gather":true,"has_community_enabled":false,"has_community_badges":false,"has_user_segments":true,"has_answer_bot_web_form_enabled":false,"has_answer_bot_web_form_modal_v2":false,"billing_url":"/access/return_to?return_to=https://looker.zendesk.com/admin/billing/subscription","is_account_owner":false,"theming_cookie_key":"hc-da39a3ee5e6b4b0d3255bfef95601890afd807091-preview","is_preview":false,"has_guide_user_segments_search":true,"has_alternate_templates":false,"arrange_articles_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/knowledge/arrange?brand_id=387764","article_verification_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/knowledge/verification?brand_id=387764","has_article_verification":false,"guide_language_settings_url":"https://web.archive.org/web/20210609032437/https://help.looker.com/hc/admin/language_settings?locale=en-us","docs_importer_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/knowledge/import_articles?brand_id=387764","community_badges_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/knowledge/community_badges?brand_id=387764","community_settings_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/knowledge/community_settings?brand_id=387764","gather_plan_state":"subscribed","search_settings_url":"https://web.archive.org/web/20210609032437/https://looker.zendesk.com/knowledge/search_settings?brand_id=387764","has_multibrand_search_in_plan":false,"theming_api_version":1,"has_pci_credit_card_custom_field":true,"current_brand_id":387764,"help_center_restricted":false,"current_brand_active":true,"is_assuming_someone_else":false,"flash_messages":[],"user_photo_editing_enabled":true,"has_end_user_apps":false,"has_docs_importer":true,"has_sunco_widget":false}; </script> <script src="//web.archive.org/web/20210609032437js_/https://static.zdassets.com/hc/assets/moment-f6f8513da6ab17eadada59a1a4edb536.js"></script> <script src="//web.archive.org/web/20210609032437js_/https://static.zdassets.com/hc/assets/hc_enduser-15cd354f7af629321e2b0d270ee3f3cd.js"></script> <script type="text/javascript">(function(){window['__CF$cv$params']={r:'65c73f7c3d6a1472',m:'f27ce2f27a5773f09738787c85e4a1d0470ba885-1623209077-1800-ARxGquoCJsr3OoOrSAaBIGQG1vmBCRjBmiN3ucewHY5+JZyte8R2Fa6ylP/eU2yPJMJqbrmrMZu6aJk0Tox3S11sLUUU7hgqYVinmUFPB8X0+KuO2DWPErGL3NhZyUi/0w==',s:[0xe300fbb50d,0xfceec5f796],}})();</script></body> </html>

CINXE.COM

Looker Help Center