Looker Community | Looker Community

<!DOCTYPE html> <html lang="en"> <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=HxkREWBo" charset="utf-8"></script> <script type="text/javascript" src="/_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="/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("https://community.looker.com/","20210813055819","https://web.archive.org/","web","/_static/", "1628834299"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=3PDvdIFv" />  <script src="https://web.archive.org/web/20210813055819js_/https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <link href="https://web.archive.org/web/20210813055819cs_/https://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700,800,300italic,400italic,600italic&display=swap" rel="stylesheet"/> <link href="https://web.archive.org/web/20210813055819cs_/https://fonts.googleapis.com/css?family=Google+Sans:300,400,600,700,800,300italic,400italic,600italic&display=swap" rel="stylesheet"/>  <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/20210813055819/https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-NWWX6K');</script>   <meta name="google-site-verification" content="AqzA-f6B31qcEto7TiA7jJXqEv2aJ8xAVaBQX9m6qbc"/>  <meta name="google-site-verification" content="_pmwR2HIGaOvvYcqMRHps7gDwhsFQx_1D_bSap0qycA"/> <script> $(document).ready(function(){ $('#nav-icon3').click(function(e){ $(this).toggleClass('open'); $('.mobile-nav').slideToggle(300); e.preventDefault(); }); $(window).bind('resize orientationchange', function() { ww = document.body.clientWidth; adjustMenu(); }); var adjustMenu = function() { if (ww > 960) { $('#nav-icon3').removeClass('open'); $('.mobile-nav').hide(); } }; }); </script> <script> if (window.location.href == 'https://web.archive.org/web/20210813055819/https://community.looker.com/groups/looker-adoption-community-1014') { window.location = "https://web.archive.org/web/20210813055819/https://community.looker.com/groups/looker-adoption-community-1016" } </script> <meta charset="UTF-8"/> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no"/> <meta name="format-detection" content="telephone=no"> <meta name="HandheldFriendly" content="true"/> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <link rel="shortcut icon" type="image/png" href="https://web.archive.org/web/20210813055819im_/https://uploads-us-west-2.insided.com/looker-en/attachment/71079c0b-8ddf-4dba-8b58-08ad84ecf5b1_thumb.png"/> <title>Looker Community | Looker Community</title> <meta name="description" content="Questions by the Looker community answered by Looker experts"> <meta property="og:title" content="Looker Community | Looker Community"/> <meta property="og:type" content="website"/> <meta property="og:url" content="https://web.archive.org/web/20210813055819/https://community.looker.com/"/> <meta property="og:description" content="Questions by the Looker community answered by Looker experts"/> <meta property="og:image" content="https://web.archive.org/web/20210813055819im_/https://uploads-us-west-2.insided.com/looker-en/attachment/4d9300ef-f7a0-4ea0-8622-bd288cc2e47e_thumb.png"/> <meta property="og:image:secure_url" content="https://uploads-us-west-2.insided.com/looker-en/attachment/4d9300ef-f7a0-4ea0-8622-bd288cc2e47e_thumb.png"/> <link rel="canonical" href="https://web.archive.org/web/20210813055819/https://community.looker.com/"/> <style id="css-variables">@font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.eot); src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.woff) format("woff"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.svg#2dumbregular) format("svg"); font-style:normal; font-weight:700 } @font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.eot); src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.woff) format("woff"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.svg#2dumbregular) format("svg"); font-style:italic; font-weight:700 } @font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.eot); src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.woff) format("woff"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.svg#2dumbregular) format("svg"); font-style:italic; font-weight:normal } @font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.eot); src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.woff) format("woff"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.svg#2dumbregular) format("svg"); font-style:normal; font-weight:300 } @font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.eot); src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.woff) format("woff"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.svg#2dumbregular) format("svg"); font-style:normal; font-weight:500 } @font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.eot); src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.woff) format("woff"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.svg#2dumbregular) format("svg"); font-style:italic; font-weight:500 } @font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.eot); src:url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.woff) format("woff"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210813055819im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.svg#2dumbregular) format("svg"); font-style:normal; font-weight:normal } html {--borderradius-base: 4px;--config--main-border-base-color: #dadce0ff;--config--main-button-base-font-color: #1a1a1a;--config--main-button-base-font-family: "Roboto", "Open Sans", sans-serif;--config--main-button-base-font-weight: 500;--config--main-button-base-radius: 3px;--config--main-button-base-texttransform: none;--config--main-color-alert: #db4437ff;--config--main-color-brand: #4285f4ff;--config--main-color-brand-secondary: #fbbc04ff;--config--main-color-contrast: #2aaae1;--config--main-color-day: #f0f2f6;--config--main-color-day-dark: #ededed;--config--main-color-day-light: #fff;--config--main-color-disabled: #dadce0ff;--config--main-color-dusk: #a7aeb5;--config--main-color-dusk-dark: #616a73;--config--main-color-dusk-light: #d5d7db;--config--main-color-highlighted: #B0DFF3;--config--main-color-info: #f4b400ff;--config--main-color-night: #202124ff;--config--main-color-night-light: #2b2b2b;--config--main-color-success: #0f9d58ff;--config--main-font-base-lineheight: 1.5;--config--main-font-base-stack: "Roboto", "Open Sans", sans-serif;--config--main-font-base-style: normal;--config--main-font-base-weight: normal;--config--main-font-secondary: "Roboto", "Open Sans", sans-serif;--config--main-header-font-weight: 600;--config-anchor-base-color: #4285f4ff;--config-anchor-base-hover-color: #4285f4ff;--config-avatar-notification-background-color: #4285f4ff;--config-body-background-color: #ffffffff;--config-body-wrapper-background-color: transparent;--config-body-wrapper-box-shadow: 0 0 0 transparent;--config-body-wrapper-max-width: 100%;--config-button-cancel-active-background-color: rgba(242,107,85,0.15);--config-button-cancel-active-border-color: #E82F11;--config-button-cancel-active-color: #f26b55;--config-button-cancel-background-color: transparent;--config-button-cancel-border-color: #f26b55;--config-button-cancel-border-radius: 24px;--config-button-cancel-border-width: 1px;--config-button-cancel-box-shadow: 0 0 0 transparent;--config-button-cancel-color: #f26b55;--config-button-cancel-hover-background-color: rgba(242,107,85,0.1);--config-button-cancel-hover-border-color: #EE4125;--config-button-cancel-hover-color: #f26b55;--config-button-cta-active-background-color: #3475e2;--config-button-cta-active-border-color: #3475e2;--config-button-cta-active-border-width: 1px;--config-button-cta-active-box-shadow: 0 0 0 transparent;--config-button-cta-active-color: #ffffff;--config-button-cta-background-color: #4285F4;--config-button-cta-border-color: #4285F4;--config-button-cta-border-radius: 24px;--config-button-cta-border-width: 1px;--config-button-cta-box-shadow: 0 0 0 transparent;--config-button-cta-color: #ffffff;--config-button-cta-focus-background-color: #387ff3ff;--config-button-cta-focus-border-color: #2a75f3ff;--config-button-cta-focus-border-width: 1px;--config-button-cta-focus-color: #ffffff;--config-button-cta-hover-background-color: #3475e2;--config-button-cta-hover-border-color: #3475e2;--config-button-cta-hover-border-width: 1px;--config-button-cta-hover-box-shadow: 0 0 0 transparent;--config-button-cta-hover-color: #ffffff;--config-button-cta-spinner-color: #fff;--config-button-cta-spinner-hover-color: #fff;--config-button-secondary-active-background-color: #3475e2;--config-button-secondary-active-border-color: #3475e2;--config-button-secondary-active-border-width: 1px;--config-button-secondary-active-box-shadow: 0 0 0 transparent;--config-button-secondary-active-color: #ffffff;--config-button-secondary-background-color: #4285F4;--config-button-secondary-border-color: #4285F4;--config-button-secondary-border-radius: 24px;--config-button-secondary-border-width: 1px;--config-button-secondary-box-shadow: 0 0 0 transparent;--config-button-secondary-color: #ffffff;--config-button-secondary-focus-background-color: #e2a904ff;--config-button-secondary-focus-border-color: #e2a904ff;--config-button-secondary-focus-border-width: 1px;--config-button-secondary-focus-color: #ffffff;--config-button-secondary-hover-background-color: #3475e2;--config-button-secondary-hover-border-color: #3475e2;--config-button-secondary-hover-border-width: 1px;--config-button-secondary-hover-box-shadow: 0 0 0 transparent;--config-button-secondary-hover-color: #ffffff;--config-button-secondary-spinner-color: #fff;--config-button-secondary-spinner-hover-color: #fff;--config-button-toggle-active-background-color: #ffffff;--config-button-toggle-active-border-color: #4285F4;--config-button-toggle-active-color: #4285F4;--config-button-toggle-background-color: transparent;--config-button-toggle-border-color: #4285F4;--config-button-toggle-border-radius: 24px;--config-button-toggle-border-width: 1px;--config-button-toggle-box-shadow: 0 0 0 transparent;--config-button-toggle-color: #4285F4;--config-button-toggle-filled-background-color: #4285f4ff;--config-button-toggle-filled-color: #fff;--config-button-toggle-filled-pseudo-color: #fff;--config-button-toggle-filled-spinner-color: #fff;--config-button-toggle-focus-border-color: #2a75f3ff;--config-button-toggle-hover-background-color: #4285f41f;--config-button-toggle-hover-border-color: #4285F4;--config-button-toggle-hover-color: #4285F4;--config-button-toggle-on-active-background-color: #4285f45c;--config-button-toggle-on-active-border-color: #4285F4;--config-button-toggle-on-active-color: #4285F4;--config-button-toggle-on-background-color: #4285f43d;--config-button-toggle-on-border-color: #4285F4;--config-button-toggle-on-border-radius: 24px;--config-button-toggle-on-border-width: 1px;--config-button-toggle-on-box-shadow: 0 0 0 transparent;--config-button-toggle-on-color: #4285F4;--config-button-toggle-on-hover-background-color: #4285f45c;--config-button-toggle-on-hover-border-color: #4285F4;--config-button-toggle-on-hover-color: #4285F4;--config-button-toggle-outline-background-color: #4285f4ff;--config-button-toggle-outline-color: #4285f4ff;--config-button-toggle-outline-pseudo-color: #4285f4ff;--config-button-toggle-outline-spinner-color: #4285f4ff;--config-content-type-article-color: #fff;--config-cookie-modal-background-color: rgba(60,60,60,.9);--config-cookie-modal-color: #fff;--config-create-topic-type-icon-color: #202124ff;--config-cta-close-button-color: #a7aeb5;--config-cta-icon-background-color: #4285f4ff;--config-cta-icon-check: #fff;--config-editor-comment-toolbar-background-color: #fff;--config-editor-comment-toolbar-button-color: #202124ff;--config-editor-comment-toolbar-button-hover-color: #4285f4ff;--config-footer-background-color: #202124ff;--config-footer-color: #fff;--config-header-color: #202124ff;--config-hero-background-position: top left;--config-hero-color: #202124ff;--config-hero-font-weight: bold;--config-hero-stats-background-color: #fff;--config-hero-stats-counter-font-weight: bold;--config-hero-text-shadow: none;--config-input-focus-color: #4285f4ff;--config-link-base-color: #202124ff;--config-link-base-hover-color: #4285f4ff;--config-link-hover-decoration: none;--config-main-navigation-background-color: #ffffff;--config-main-navigation-border-bottom-color: #dadce0;--config-main-navigation-border-top-color: transparent;--config-main-navigation-dropdown-background-color: #fff;--config-main-navigation-dropdown-color: #2b3346;--config-main-navigation-dropdown-font-weight: normal;--config-main-navigation-nav-color: #202124;--config-main-navigation-nav-font-weight: normal;--config-main-navigation-nav-link-color: #202124;--config-main-navigation-search-placeholder-color: #bdc1c6ff;--config-mention-selector-hover-selected-color: #fff;--config-meta-link-font-weight: normal;--config-meta-link-hover-color: #4285f4ff;--config-meta-text-color: #80868bff;--config-notification-widget-color: #202124ff;--config-pagination-active-page-color: #4285f4ff;--config-paging-item-hover-color: #4285f4ff;--config-pill-color: #fff;--config-powered-by-insided-display: visible;--config-profile-user-statistics-background-color: #fff;--config-sharpen-fonts: true;--config-sidebar-widget-color: #202124ff;--config-sidebar-widget-font-family: "Roboto", "Open Sans", sans-serif;--config-sidebar-widget-font-weight: 600;--config-sidebar-widget-username-color: #202124ff;--config-ssi-header-height: auto;--config-ssi-header-mobile-height: auto;--config-subcategory-hero-color: #202124ff;--config-tag-modify-link-color: #4285f4ff;--config-tag-pill-background-color: #f8f8f8;--config-tag-pill-hover-background-color: #ceffffff;--config-tag-pill-hover-border-color: #4285f4ff;--config-tag-pill-hover-color: #4285f4ff;--config-thread-list-best-answer-background-color: #8effd7ff;--config-thread-list-best-answer-border-color: #0f9d58ff;--config-thread-list-mod-break-background: #4285f4f2;--config-thread-list-mod-break-border-color: #4285f4ff;--config-thread-list-sticky-topic-background: #4285f4f2;--config-thread-list-sticky-topic-border-color: #4285f4ff;--config-thread-list-sticky-topic-flag-color: #4285f4ff;--config-thread-list-topic-button-subscribe-border-width: 1px;--config-thread-list-topic-title-font-weight: bold;--config-thread-pill-answer-background-color: #0f9d58ff;--config-thread-pill-author-background-color: #4285f4ff;--config-thread-pill-author-color: #fff;--config-thread-pill-question-background-color: #f4b400ff;--config-thread-pill-question-color: #fff;--config-thread-pill-sticky-background-color: #4285f4ff;--config-thread-pill-sticky-color: #fff;--config-topic-page-answered-field-icon-color: #0f9d58ff;--config-topic-page-answered-field-link-color: #4285f4ff;--config-topic-page-header-font-weight: 600;--config-topic-page-post-actions-active: #4285f4ff;--config-topic-page-post-actions-icon-color: #a7aeb5;--config-topic-page-quote-border-color: #dadce0ff;--config-topic-question-color: #f4b400ff;--config-username-hover-color: #4285f4ff;--config-username-hover-decoration: none;--config-widget-box-shadow: 0 2px 4px 0 rgba(0,0,0,0.08);--config-widget-tabs-font-weight: normal;--config-widget-tabs-forum-list-header-color: #202124ff;--config-widget-tabs-forum-list-header-hover-color: #4285f4ff;--config-card-border-radius: 8px;--config-card-border-width: 1px;--config-card-background-color: #ffffff;--config-card-border-color: #dadce0ff;--config-card-hover-background-color: #ffffff;--config-card-hover-title-color: #4285F4;--config-card-hover-border-color: #dadce000;--config-card-hover-shadow: 0px 1px 3px rgba(60, 64, 67, 0.3), 0px 4px 8px rgba(60, 64, 67, 0.15);;--config-card-active-background-color: #ffffff;--config-card-active-border-color: #dadce0ff;--config-checkbox-checked-color: #5a2fc2;--config-content-type-article-background-color: #5a2fc2;--config-content-type-survey-background-color: #5a2fc2;--config-content-type-survey-color: #fff;--config-main-navigation-dropdown-hover-color: #5a2fc2;--config-meta-icon-color: #a7aeb5;--config-tag-pill-border-color: #e3e4ec;--config-tag-pill-color: #2b3346;--config-username-color: #5a2fc2;--config-widget-tabs-active-border-color: #5a2fc2;--config-widgets-action-link-color: #5a2fc2;--config-button-cta-advanced: 1;--config-button-secondary-advanced: 1;--config-button-border-width: 1px;--config-button-border-radius: 24px;--config-button-cta-hover-border-radius: 24px;--config-button-cta-active-border-radius: 24px;--config-button-secondary-hover-border-radius: 24px;--config-button-secondary-active-border-radius: 24px;--config-button-toggle-hover-border-radius: 24px;--config-button-toggle-active-border-radius: 24px;--config-button-toggle-on-hover-border-radius: 24px;--config-button-toggle-on-active-border-radius: 24px;--config-button-cancel-hover-border-radius: 24px;--config-button-cancel-active-border-radius: 24px;--config-button-toggle-hover-border-width: 1px;--config-button-toggle-active-border-width: 1px;--config-button-toggle-on-hover-border-width: 1px;--config-button-toggle-on-active-border-width: 1px;--config-button-cancel-hover-border-width: 1px;--config-button-cancel-active-border-width: 1px;}</style> <link href="https://web.archive.org/web/20210813055819cs_/https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/dist/css/forum.css" id="main-css" rel="stylesheet" type="text/css"/> <script>if (!(window.CSS && CSS.supports('color', 'var(--fake-var)'))) { document.head.removeChild(document.getElementById('main-css')) document.write('<link href="/destination.css" rel="stylesheet" type="text/css"><\x2flink>'); }</script> <style> .user-guide-nav { position:relative; } .main-navigation--wrapper{ width: 100%;} .templatefoot{ display: none !important;} .brand-hero-title { font-weight: 500; font-size: 46px; font-family: 'Google Sans'} .main-navigation-sitewidth .main-navigation--nav-buttons-wrapper .link{ background-color: #4285F4; color: white; padding-top: 0; padding-bottom: 0; padding-right: 15px; padding-left: 15px; border-radius: 8px; text-decoration: none; } .footer { margin-top: 25px; font-family: 'Roboto','Open Sans', sans-serif; color: rgba(32, 33, 36, 1); font-weight: 400; line-height: 1.5; -webkit-font-smoothing: antialiased; box-sizing: border-box; display: block; border-top: 1px solid #ddd; padding: 20px 0; font-size: 14px; } .ug-nav{ font-family: 'Google Sans'} .main-navigation--nav-buttons-wrapper .link:hover{ background-color: #1967D2 } */am i allowed to do this lol */ */ Quick link styles */ ..quicklink__hero.padding__icon {background-size: auto 72px!important} .padding__icon, .quicklink__box__novisual, .quicklink__hero { height: 70px !important; width: 70px !important; margin:auto; } .quicklink__box { padding:5px; border-radius:8px !important; } .quicklink__title { padding: 1px 0 !important; flex: 1; display: flex !important; flex-wrap: wrap; justify-content: center; text-align: center; font-family: 'Google Sans' } .quicklink__title>h3 { padding: 0px } .padding__icon, .quicklink__icon { margin-top 12px; } .custom-quicklink .quicklink__url { display: block; } /* Remove border bottom in menu on home */ .twig_site-index .main-navigation--wrapper { border-bottom: none!important; } /* Make meta icons blue */ .thread-meta-item__icon { color: #4285F4; } /* Make article labels colored */ .pill { background-color: #D2E3FC !important; color: #174EA6 !important; } /* Tags */ .tag--pill { background-color: #F8F9FA; border: 1px solid #F1F3F4; border-radius: 3px } .tag--pill:hover { background-color: #F8F9FA; border-color: #4285F4; color: #4285F4; } /* hero banner change height */ .custom-hero-banner { height: 240px; /* default: 240px */ } .list-item--reputation{ display: none; } </style> </head> <body class="twig_site-index qa-forum-site-index ">  <noscript><iframe src="https://web.archive.org/web/20210813055819if_/https://www.googletagmanager.com/ns.html?id=GTM-NWWX6K" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div id="community-id" data-data="looker-en"></div> <div id="device-type" data-data="desktop"></div> <main class="body-wrapper"> <a href="/web/20210813055819/https://community.looker.com/topic/new" data-track="{"trigger":"floating button","type":"Topic Initiated"}" role="button" class="btn--cta btn--create-topic btn--fixed btn--fixed__bottom is-visible-S qa-menu-create-topic"> <span class="icon icon--pen icon--auto-width" aria-hidden="true"></span> </a> <script type="text/javascript"> window.inSidedData = {"communityId":"looker-en","environment":"production","language":"en","device":"desktop","page":{"pageNumber":1,"name":"Home","path":"looker-en:Home:","section":"Home","site":"looker-en","title":null,"url":"\/","firstRender":false},"user":{"userid":null,"rank":null,"role":"roles.guest","mainRole":"roles.guest","name":"guest","loginSource":null,"registerSource":null,"company":{"name":null,"status":null}},"form":{"name":"","step":""},"content":{"category":{"id":null,"title":null,"type":null},"topic":{"id":null,"title":null,"type":null,"content_type":null,"source_id":null,"created":null,"replies":null,"is_sticky":null,"prefix":null,"tags":null},"post":{"id":null},"path":":"},"search":{"phrase":null,"count":null}}; </script> <div class="homepage-widget-container widget-container homepage-widget-container--header widget-container--header homepage-widget-container--header widget-container--header homepage-widget-container--index-0 widget-container--index-0" data-idx="0"> <div class="widget-placeholder"> <div class="ssi ssi-header custom-header"> <style> .logo-big { max-height: 18px !important; margin: 14px 0; } .wrap { padding: 0; width: 90%; max-width: 1200px; } .container { width: 90%; max-width: 1200px; margin: 0 auto; padding-left:0; padding-right:0; } .extra-info-wrapper .topic-link { font-size: 16px; line-height: 1.1; } .d-header .title a, .d-header .title a:visited, .d-header .icons .icon { color: #5a5b5e; } .d-header .icons .badge-notification, .d-header .icons .ring { top: -2px; padding: 2px 4px; } .d-header .contents { margin: 0; } .d-header { font-family: "Google Sans", sans-serif; height: 40px; margin-top: 61px; position: fixed; box-shadow: none; border-bottom: 1px solid #DADCE0; } #main-outlet { padding-top: 142px; } /* NEW TOP NAV */ html, body { padding: 0; margin: 0; } a { text-decoration: none; } .center-align { text-align: center; } .left-align { text-align: left; } .user-guide-nav { background: white; position: relative; width: 100%; top: 0; z-index: 9999; height: 60px; border-bottom: 1px solid #DADCE0; } .user-guide-nav .container { width: 90%; max-width: 1200px; margin: 0 auto; } .user-guide-nav .nav-logo { position: relative; float: left; padding: 16.5px 0; } .user-guide-nav .nav-logo img { width: 100px; height: 27px; position: relative; padding: 0; } .user-guide-nav .ug-nav { display: block; float: left; margin-left: 30px; } .user-guide-nav ul { padding: 0; margin: 0; } .user-guide-nav li { display: inline-block; margin: 0; padding: 0; } .user-guide-nav li a { color: #5F6368; font-size: 14px; display: block; padding: 21px 15px 17px; border-bottom: 3px solid transparent; font-weight: 400; } .user-guide-nav li a.active { border-bottom: 3px solid #4285F4; background-color: transparent; } .mobile-nav { display: none; max-height: calc(100vh - 60px); overflow-y: auto; border-bottom: 1px solid #DADCE0; } #nav-icon3 { display: none; width: 25px; height: 25px; position: relative; float: right; margin: 15px 0; -webkit-transform: rotate(0deg); -moz-transform: rotate(0deg); -o-transform: rotate(0deg); transform: rotate(0deg); -webkit-transition: .5s ease-in-out; -moz-transition: .5s ease-in-out; -o-transition: .5s ease-in-out; transition: .5s ease-in-out; cursor: pointer; } #nav-icon3 span { display: block; position: absolute; height: 3px; width: 100%; background: #5F6368; opacity: 1; left: 0; -webkit-transform: rotate(0deg); -moz-transform: rotate(0deg); -o-transform: rotate(0deg); transform: rotate(0deg); -webkit-transition: .25s ease-in-out; -moz-transition: .25s ease-in-out; -o-transition: .25s ease-in-out; transition: .25s ease-in-out; } #nav-icon3 span:nth-child(1) { top: 6px; } #nav-icon3 span:nth-child(2), #nav-icon3 span:nth-child(3) { top: 14px; } #nav-icon3 span:nth-child(4) { top: 22px; } #nav-icon3.open span:nth-child(1), #nav-icon3.open span:nth-child(4){ top: 16px; width: 0%; left: 50%; } #nav-icon3.open span:nth-child(2) { -webkit-transform: rotate(45deg); -moz-transform: rotate(45deg); -o-transform: rotate(45deg); transform: rotate(45deg); } #nav-icon3.open span:nth-child(3) { -webkit-transform: rotate(-45deg); -moz-transform: rotate(-45deg); -o-transform: rotate(-45deg); transform: rotate(-45deg); } @media all and (max-width:1200px){ .user-guide-nav .ug-nav { display: none; } #nav-icon3 { display: block; } .mobile-nav { top: 59px; border-top: none; position: absolute; background: white; width: 100%; padding: 0 0 10px 5%; margin-left: -5%; } .mobile-nav p { margin: 15px 0 25px; line-height: 1.5; font-size: 15px; } .mobile-nav a { color: #5F6368; font-weight: 400; } .mobile-nav a:hover { color: #4285F4; } } .d-header>.wrap { width: 90%; max-width: 1200px; padding: 0; } .d-header #site-text-logo { font-size: 18px; font-weight: 400; color: #5F6368; } .d-header #site-text-logo:hover { color: #5F6368; opacity: 1; } .d-header-icons .d-icon { color: #5F6368; font-size: 20px; } #banner-content_wrap { width: 90%; max-width: 1200px; margin: 30px auto; } .banner-box .row .single-box .icon { display: none; } body .banner-box .container { width: 90%; max-width: 1200px; padding: 0; } .banner-box .button-container .close, .banner-box .button-container .toggle { padding-top: 0; outline: 0; } .d-header { height: 40px; } #main-outlet { padding-top: 135px; } @media all and (max-width:450px){ #site-text-logo { display: none; } } .extra-info-wrapper .topic-link { font-size: 14px; line-height: 1; font-weight: 600; } .badge-wrapper .badge-category .category-name { font-weight: 600; } .banner-box h1, .banner-box h3 { color: initial; } .banner-box h3 { color: initial; font-weight: 500; } .banner-box .section-header .x-title { padding: 50px 0px 15px; } @media screen and (max-width: 736px){ .banner-box .section-header .x-title { margin-top: 0; } } @media all and (max-width:600px) { .banner-box .section-header .x-title { padding: 50px 0px 15px; } } .banner-box h1 { color: initial; font-size: 48px; font-weight: 400; line-height: 1.1; } @media all and (max-width:600px) { .banner-box h1 { font-size: 34px; } } .banner-box h2 { text-align: center; color: #5f6368; font-size: 16px; font-weight: 400; font-family: Roboto, Arial, Helvetica, sans-serif; } .banner-box .row .single-box .btn { background: none; color: #4285F4; } .banner-box .row .single-box .btn:hover { background: none; color: #174EA6; } .user-menu .quick-access-panel li { background-color: #E8F0FE; } .menu-panel li a.widget-link, .menu-panel li.heading a.widget-link, .user-menu .quick-access-panel li a { color: initial; } .menu-panel li a.widget-link:hover, .menu-panel li.heading a.widget-link:hover, .user-menu .quick-access-panel li a:hover { color: #4285F4; background-color: transparent; } .badge-wrapper .badge-category .category-name { font-weight: 500; } .custom-search-banner { padding: 20px 0 30px; } .search-widget { width: 100%; max-width: 700px; margin: 0 auto; } input[type="text"], input[type="password"], input[type="datetime"], input[type="datetime-local"], input[type="date"], input[type="month"], input[type="time"], input[type="week"], input[type="number"], input[type="email"], input[type="url"], input[type="search"], input[type="tel"], input[type="color"] { padding: 18px 10px; border-radius: 8px !important; border: 1px solid #DADCE0; } .search-widget-clicked { box-shadow: none; padding: 0; max-width: 700px; margin: 0 auto; } input[type="text"]:focus, input[type="password"]:focus, input[type="datetime"]:focus, input[type="datetime-local"]:focus, input[type="date"]:focus, input[type="month"]:focus, input[type="time"]:focus, input[type="week"]:focus, input[type="number"]:focus, input[type="email"]:focus, input[type="url"]:focus, input[type="search"]:focus, input[type="tel"]:focus, input[type="color"]:focus { border-color: #4285F4; box-shadow: none; outline: 0; } .search-menu .search-context { padding: 0 10px; } .banner-box a { color: #4285F4; } .banner-box a:hover { color: #174EA6; } .user-menu .quick-access-panel li:hover, .user-menu .quick-access-panel li:focus { background-color: transparent; } </style> <link rel="stylesheet" href="https://web.archive.org/web/20210813055819cs_/https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"> <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/20210813055819/https://looker.com/" class="nav-logo"> <img src="https://web.archive.org/web/20210813055819im_/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/20210813055819/https://looker.com/guide" class="custres-gtm-nav-link"> User Guide </a> </li> <li> <a href="https://web.archive.org/web/20210813055819/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> </li> <li> <a href="https://web.archive.org/web/20210813055819/https://help.looker.com/" class="custres-gtm-nav-link"> Help Center </a> </li> <li> <a href="https://web.archive.org/web/20210813055819/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </li> <li> <a href="https://web.archive.org/web/20210813055819/https://community.looker.com/" class="custres-gtm-nav-link active"> Community </a> </li> <li> <a href="https://web.archive.org/web/20210813055819/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </li> <li> <a href="https://web.archive.org/web/20210813055819/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/20210813055819/https://looker.com/guide" class="custres-gtm-nav-link"> User Guide </a> </p> <p> <a href="https://web.archive.org/web/20210813055819/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> </p> <p> <a href="https://web.archive.org/web/20210813055819/https://help.looker.com/" class="custres-gtm-nav-link"> Help Center </a> </p> <p> <a href="https://web.archive.org/web/20210813055819/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </p> <p> <a href="https://web.archive.org/web/20210813055819/https://community.looker.com/" class="custres-gtm-nav-link"> Community </a> </p> <p> <a href="https://web.archive.org/web/20210813055819/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </p> <p> <a href="https://web.archive.org/web/20210813055819/https://looker.com/certification" class="custres-gtm-nav-link"> Certification </a> </p> </div> </div> </div> </div> </div> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--navigation_bar widget-container--navigation_bar homepage-widget-container--navigation_bar widget-container--navigation_bar homepage-widget-container--index-1 widget-container--index-1" data-idx="1"> <div class="widget-placeholder"> <nav class="main-navigation--wrapper qa-main-navigation custom-navigation"> <div class="main-navigation-sitewidth "> <section data-preact="menu/main" class="" data-props="{"communityCategories":[{"id":1000,"title":"Welcome","url":"\/welcome-1000","description":"Rules, announcements, and important information","thumbnailUrl":"","heroImageUrl":"","subforums":[{"id":1006,"url":"\/getting-started-1006","title":"Getting started","description":"Getting Started in the Looker Community","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":67,"replyCount":166},{"id":1007,"url":"\/news-announcements-1007","title":"News & announcements","description":"All the latest Looker Community & Looker Product news","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":104,"replyCount":151},{"id":66,"url":"\/who-s-hiring-66","title":"Who's hiring","description":"See and post available jobs working with Looker or Data.","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":381,"replyCount":31},{"id":71,"url":"\/release-notes-archive-71","title":"Release notes (archive)","description":"All your release notes are here - the newest features, when you'll get them, and what to watch out for when updating. We'll be moving this soon.","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":63,"replyCount":512},{"id":1017,"url":"\/lesson-comments-1017","title":"Lesson Comments","description":"Topics on lessons","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":11,"replyCount":0},{"id":1025,"url":"\/challenge-1025","title":"Challenge","description":"Challenges and activities for hands-on learning","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":10,"replyCount":10}],"showDescriptionOnHomepage":true},{"id":1001,"title":"Looker development","url":"\/looker-development-1001","description":"Developing LookML, writing SQL, and modeling data","thumbnailUrl":"","heroImageUrl":"","subforums":[{"id":5,"url":"\/lookml-5","title":"LookML","description":"LookML design patterns, best practices, hacks, and knowledge sharing","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":1335,"replyCount":3791},{"id":10,"url":"\/sql-10","title":"SQL","description":"For all of your SQL errors, troubleshooting questions, and cool queries","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":256,"replyCount":698}],"showDescriptionOnHomepage":true},{"id":1002,"title":"Exploring & curating data","url":"\/exploring-curating-data-1002","description":"Dashboards, Looks, Visualizations\u2014 it all happens here","thumbnailUrl":"","heroImageUrl":"","subforums":[{"id":36,"url":"\/explores-36","title":"Explores","description":"Discovering Data in Looker","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":428,"replyCount":1281},{"id":7,"url":"\/dashboards-looks-7","title":"Dashboards & looks","description":"Building reports & visualizations in Looker","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":1163,"replyCount":3342}],"showDescriptionOnHomepage":true},{"id":1003,"title":"Application development","url":"\/application-development-1003","description":"Extensions, open source tools, the Looker API, and embedding Looker","thumbnailUrl":"","heroImageUrl":"","subforums":[{"id":75,"url":"\/embedding-looker-powered-by-looker-75","title":"Embedding Looker \/ Powered by Looker","description":"Sharing data with a broader audience","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":103,"replyCount":269},{"id":78,"url":"\/open-source-projects-78","title":"Open source projects","description":"Build on top of the Looker platform","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":44,"replyCount":141},{"id":77,"url":"\/looker-api-77","title":"Looker API","description":"Discussions about using Looker API and its SDK's -- from schedules to scripting","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":287,"replyCount":1054}],"showDescriptionOnHomepage":true},{"id":154,"title":"Administration","url":"\/administration-154","description":"Looker set-up and management","thumbnailUrl":"","heroImageUrl":"","subforums":[{"id":1009,"url":"\/user-access-management-1009","title":"User access & management","description":"Permissions, user setup, and Looker setup","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":20,"replyCount":33},{"id":35,"url":"\/general-looker-administration-35","title":"General Looker administration","description":"All your administration & self-hosting questions and content","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":375,"replyCount":1093}],"showDescriptionOnHomepage":true},{"id":158,"title":"Data science & analytics","url":"\/data-science-analytics-158","description":"Everything from mean() to machine learning","thumbnailUrl":"","heroImageUrl":"","subforums":[{"id":79,"url":"\/got-a-question-79","title":"Got a question?","description":"Ask your big data questions here.","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":60,"replyCount":164},{"id":80,"url":"\/share-your-best-practices-80","title":"Share your best practices","description":"Got a great data story to share or best practices to write up?","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":11,"replyCount":7}],"showDescriptionOnHomepage":true},{"id":161,"title":"\u30b3\u30df\u30e5\u30cb\u30c6\u30a3\u30d5\u30a9\u30fc\u30e9\u30e0 (Japanese)","url":"\/%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A9%E3%83%A0-japanese-161","description":"\u3088\u3046\u3053\u305dLooker\u306e\u65e5\u672c\u8a9e\u30b3\u30df\u30e5\u30cb\u30c6\u30a3\u3078\uff01\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8\u3084\u30a4\u30d9\u30f3\u30c8\u306e\u3054\u6848\u5185\u306a\u3069\u306f\u300c\u30cb\u30e5\u30fc\u30b9\u3068\u544a\u77e5\u300d\u3001Looker\u306e\u88fd\u54c1\u6a5f\u80fd\u306b\u95a2\u3059\u308b\u3061\u3087\u3063\u3068\u3057\u305f\u7591\u554f\u30fb\u8cea\u554f\u306f\u300c\u30d8\u30eb\u30d7\u3068\u30b5\u30dd\u30fc\u30c8\u300d\u3001\u305d\u306e\u4ed6TIPs\u3084\u30c7\u30fc\u30bf\u306b\u307e\u3064\u308f\u308b\u8a71\u306f\u300c\u30b3\u30e9\u30e0\u300d\u306e\u30ab\u30c6\u30b4\u30ea\u3078\u3054\u6295\u7a3f\u304f\u3060\u3055\u3044\u3002\u307f\u306a\u3055\u307e\u306e\u6295\u7a3f\u30fb\u30b3\u30e1\u30f3\u30c8\u3001\u5fc3\u3088\u308a\u304a\u5f85\u3061\u3057\u3066\u3044\u307e\u3059\uff01","thumbnailUrl":"","heroImageUrl":"","subforums":[{"id":100,"url":"\/%E3%83%8B%E3%83%A5%E3%83%BC%E3%82%B9%E3%81%A8%E5%91%8A%E7%9F%A5-100","title":"\u30cb\u30e5\u30fc\u30b9\u3068\u544a\u77e5","description":"\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8\u3001Looker\u3084\u30c7\u30fc\u30bf\u306b\u95a2\u3059\u308b\u30cb\u30e5\u30fc\u30b9","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":34,"replyCount":21},{"id":101,"url":"\/%E3%83%98%E3%83%AB%E3%83%97%E3%81%A8%E3%82%B5%E3%83%9D%E3%83%BC%E3%83%88-101","title":"\u30d8\u30eb\u30d7\u3068\u30b5\u30dd\u30fc\u30c8","description":"Looker\u306b\u95a2\u3059\u308b\u3042\u3089\u3086\u308b\u7591\u554f\u30fb\u8cea\u554f ","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":10,"replyCount":17},{"id":103,"url":"\/%E3%82%B3%E3%83%A9%E3%83%A0-103","title":"\u30b3\u30e9\u30e0","description":"Looker\u306b\u307e\u3064\u308f\u308b\u3042\u308c\u3053\u308c","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":54,"replyCount":5}],"showDescriptionOnHomepage":false},{"id":1020,"title":"The Kitchen Table","url":"\/the-kitchen-table-1020","description":"Explore the product knowledge we've built up together","thumbnailUrl":"","heroImageUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/85cdd340-4242-443a-8677-083ddcc89df2_thumb.png","subforums":[{"id":1021,"url":"\/technical-tips-tricks-1021","title":"Technical Tips & Tricks","description":"Previously internal product knowledge now available for you to explore!","type":"default","thumbnailUrl":"","heroImageUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/4428b9f3-8d8e-43f3-a931-81dbfd39784e_thumb.png","showDescriptionOnHomepage":true,"topicCount":1650,"replyCount":56},{"id":1024,"url":"\/common-account-questions-1024","title":"Common Account Questions","description":"Here our Customer Success Managers provide the answers to our most commonly asked account questions","type":"default","thumbnailUrl":"","heroImageUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/c87e81df-04d0-459c-9ce1-ed148d3f4f23_thumb.png","showDescriptionOnHomepage":true,"topicCount":14,"replyCount":2},{"id":1022,"url":"\/dcl-mic-drops-1022","title":"DCL Mic Drops","description":"Meet Looker gurus and learn about their favorite Looker tips & trips","type":"default","thumbnailUrl":"","heroImageUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/261a83b4-ef36-4bb7-9fac-c0a299842426_thumb.png","showDescriptionOnHomepage":true,"topicCount":5,"replyCount":4}],"showDescriptionOnHomepage":false}],"knowledgeBaseCategories":[],"showActivitySinceLastVisit":false,"phrases":{"Common":{"main.navigation.menu_label":"Categories","nav.title.forum.overview":"Forum overview","nav.title.forum.recent.activity":"Recently active topics","nav.title.forum.activity.last.visit":"Active since last visit","nav.title.forum.unanswered.questions":"Unanswered questions"},"Forum":{"nav.title.knowledgebase":"Knowledge base","nav.title.knowledgebase.overview":"Knowledge base","nav.title.community":"Community"}}}"><div class="main-menu"><div class="dropdown-container "><button type="button" style="background: none; border: none; font-weight: inherit; display: inline-block; padding: 0px; margin: 0px; cursor: pointer;"> <span style="display: flex; align-items: center;" class="main-menu-trigger"><span>Categories</span><svg aria-hidden="true" width="24" height="24" class viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><path d="M7.41 8.58997L12 13.17L16.59 8.58997L18 9.99997L12 16L6 9.99997L7.41 8.58997Z" fill="currentColor"></path></svg></span></button><ul component="ul" tabindex="-1" class="dropdown dropdown--forums-overview is-hidden"><span class="arrow is-hidden-S"></span><ul class="main-menu-list main-menu-list--overflow-scroll"><li class="main-menu-list__item"><ul class="main-menu-list "><li class="main-menu-list__item"><a href="/web/20210813055819/https://community.looker.com/" class="main-menu-link link--text">Forum overview</a></li><li class="main-menu-list__item"><a href="/web/20210813055819/https://community.looker.com/search/activity/recent" class="main-menu-link link--text">Recently active topics</a></li><li class="main-menu-list__item"></li><li class="main-menu-list__item"><a href="/web/20210813055819/https://community.looker.com/search/activity/unanswered" class="main-menu-link link--text">Unanswered questions</a></li></ul></li><li class="main-menu-list__item"></li><li class="main-menu-list__item"><section class="main-menu-section"><div class="main-menu-section__title">Community</div><li><a href="/web/20210813055819/https://community.looker.com/welcome-1000" title="Welcome" class="link--text main-menu-link main-menu-link--category"><span><strong>Welcome</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" title="Getting started" topicscount="67" class="link--text main-menu-link main-menu-link--category"><span>Getting started</span><span class="text--meta">67</span></a><a href="/web/20210813055819/https://community.looker.com/news-announcements-1007" title="News & announcements" topicscount="104" class="link--text main-menu-link main-menu-link--category"><span>News & announcements</span><span class="text--meta">104</span></a><a href="/web/20210813055819/https://community.looker.com/who-s-hiring-66" title="Who's hiring" topicscount="381" class="link--text main-menu-link main-menu-link--category"><span>Who's hiring</span><span class="text--meta">381</span></a><a href="/web/20210813055819/https://community.looker.com/release-notes-archive-71" title="Release notes (archive)" topicscount="63" class="link--text main-menu-link main-menu-link--category"><span>Release notes (archive)</span><span class="text--meta">63</span></a><a href="/web/20210813055819/https://community.looker.com/lesson-comments-1017" title="Lesson Comments" topicscount="11" class="link--text main-menu-link main-menu-link--category"><span>Lesson Comments</span><span class="text--meta">11</span></a><a href="/web/20210813055819/https://community.looker.com/challenge-1025" title="Challenge" topicscount="10" class="link--text main-menu-link main-menu-link--category"><span>Challenge</span><span class="text--meta">10</span></a></li><li><a href="/web/20210813055819/https://community.looker.com/looker-development-1001" title="Looker development" class="link--text main-menu-link main-menu-link--category"><span><strong>Looker development</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/lookml-5" title="LookML" topicscount="1335" class="link--text main-menu-link main-menu-link--category"><span>LookML</span><span class="text--meta">1335</span></a><a href="/web/20210813055819/https://community.looker.com/sql-10" title="SQL" topicscount="256" class="link--text main-menu-link main-menu-link--category"><span>SQL</span><span class="text--meta">256</span></a></li><li><a href="/web/20210813055819/https://community.looker.com/exploring-curating-data-1002" title="Exploring & curating data" class="link--text main-menu-link main-menu-link--category"><span><strong>Exploring & curating data</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/explores-36" title="Explores" topicscount="428" class="link--text main-menu-link main-menu-link--category"><span>Explores</span><span class="text--meta">428</span></a><a href="/web/20210813055819/https://community.looker.com/dashboards-looks-7" title="Dashboards & looks" topicscount="1163" class="link--text main-menu-link main-menu-link--category"><span>Dashboards & looks</span><span class="text--meta">1163</span></a></li><li><a href="/web/20210813055819/https://community.looker.com/application-development-1003" title="Application development" class="link--text main-menu-link main-menu-link--category"><span><strong>Application development</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75" title="Embedding Looker / Powered by Looker" topicscount="103" class="link--text main-menu-link main-menu-link--category"><span>Embedding Looker / Powered by Looker</span><span class="text--meta">103</span></a><a href="/web/20210813055819/https://community.looker.com/open-source-projects-78" title="Open source projects" topicscount="44" class="link--text main-menu-link main-menu-link--category"><span>Open source projects</span><span class="text--meta">44</span></a><a href="/web/20210813055819/https://community.looker.com/looker-api-77" title="Looker API" topicscount="287" class="link--text main-menu-link main-menu-link--category"><span>Looker API</span><span class="text--meta">287</span></a></li><li><a href="/web/20210813055819/https://community.looker.com/administration-154" title="Administration" class="link--text main-menu-link main-menu-link--category"><span><strong>Administration</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/user-access-management-1009" title="User access & management" topicscount="20" class="link--text main-menu-link main-menu-link--category"><span>User access & management</span><span class="text--meta">20</span></a><a href="/web/20210813055819/https://community.looker.com/general-looker-administration-35" title="General Looker administration" topicscount="375" class="link--text main-menu-link main-menu-link--category"><span>General Looker administration</span><span class="text--meta">375</span></a></li><li><a href="/web/20210813055819/https://community.looker.com/data-science-analytics-158" title="Data science & analytics" class="link--text main-menu-link main-menu-link--category"><span><strong>Data science & analytics</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/got-a-question-79" title="Got a question?" topicscount="60" class="link--text main-menu-link main-menu-link--category"><span>Got a question?</span><span class="text--meta">60</span></a><a href="/web/20210813055819/https://community.looker.com/share-your-best-practices-80" title="Share your best practices" topicscount="11" class="link--text main-menu-link main-menu-link--category"><span>Share your best practices</span><span class="text--meta">11</span></a></li><li><a href="/web/20210813055819/https://community.looker.com/%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A9%E3%83%A0-japanese-161" title="コミュニティフォーラム (Japanese)" class="link--text main-menu-link main-menu-link--category"><span><strong>コミュニティフォーラム (Japanese)</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/%E3%83%8B%E3%83%A5%E3%83%BC%E3%82%B9%E3%81%A8%E5%91%8A%E7%9F%A5-100" title="ニュースと告知" topicscount="34" class="link--text main-menu-link main-menu-link--category"><span>ニュースと告知</span><span class="text--meta">34</span></a><a href="/web/20210813055819/https://community.looker.com/%E3%83%98%E3%83%AB%E3%83%97%E3%81%A8%E3%82%B5%E3%83%9D%E3%83%BC%E3%83%88-101" title="ヘルプとサポート" topicscount="10" class="link--text main-menu-link main-menu-link--category"><span>ヘルプとサポート</span><span class="text--meta">10</span></a><a href="/web/20210813055819/https://community.looker.com/%E3%82%B3%E3%83%A9%E3%83%A0-103" title="コラム" topicscount="54" class="link--text main-menu-link main-menu-link--category"><span>コラム</span><span class="text--meta">54</span></a></li><li><a href="/web/20210813055819/https://community.looker.com/the-kitchen-table-1020" title="The Kitchen Table" class="link--text main-menu-link main-menu-link--category"><span><strong>The Kitchen Table</strong></span><span class="text--meta"></span></a><a href="/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021" title="Technical Tips & Tricks" topicscount="1650" class="link--text main-menu-link main-menu-link--category"><span>Technical Tips & Tricks</span><span class="text--meta">1650</span></a><a href="/web/20210813055819/https://community.looker.com/common-account-questions-1024" title="Common Account Questions" topicscount="14" class="link--text main-menu-link main-menu-link--category"><span>Common Account Questions</span><span class="text--meta">14</span></a><a href="/web/20210813055819/https://community.looker.com/dcl-mic-drops-1022" title="DCL Mic Drops" topicscount="5" class="link--text main-menu-link main-menu-link--category"><span>DCL Mic Drops</span><span class="text--meta">5</span></a></li></section></li></ul></ul></div></div></section> <section class="main-navigation--nav-buttons-wrapper js-main-navigation"> <input type="hidden" data-id="" id="current-user-data"/> <ul> <li class="is-hidden-S"> <a href="/web/20210813055819/https://community.looker.com/topic/new" data-track="{"trigger":"navigation","type":"Topic Initiated"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Create topic clicked","eventLabel":{"Position":"Navigation"}}" class="link menu-create-topic qa-menu-create-topic" tabindex="0" role="button" title="Ask question / Create topic"> <span class="icon--pen icon--auto-width" aria-hidden="true"></span> <span>Ask question / Create topic</span> </a> </li> <li> <a href="#" class="link js-open-modal qa-header-login-button" tabindex="0" role="button" data-modal="login">Login</a> </li> </ul> </section> </div> </nav> </div> </div> <div class="sitewidth flash-message-wrapper"> <div class="col"> <div class="module templatehead"> </div> </div> </div> <div class="widget--notification qa-widget-notification custom-notification" data-preact="widget-notification/FeaturedTopicsWrapper" data-props="{"widget":"featuredBanner"}"></div> <div class="homepage-widget-container widget-container homepage-widget-container--header_navigation widget-container--header_navigation homepage-widget-container--header_navigation widget-container--header_navigation homepage-widget-container--index-2 widget-container--index-2" data-idx="2"> <div class="widget-placeholder"> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--topic_banner widget-container--topic_banner homepage-widget-container--topic_banner widget-container--topic_banner homepage-widget-container--index-3 widget-container--index-3" data-idx="3"> <div class="widget-placeholder"> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--hero_banner widget-container--hero_banner homepage-widget-container--hero_banner widget-container--hero_banner homepage-widget-container--index-4 widget-container--index-4" data-idx="4"> <div class="widget-placeholder"> <div class="brand-hero qa-brand-hero custom-hero-banner" style="background-image: url(https://web.archive.org/web/20210813055819im_/https://uploads-us-west-2.insided.com/looker-en/attachment/09972b8f-a54f-4893-85af-58259d95bf1d_thumb.jpg)"> <div class="sitewidth"> <h1 class="brand-hero-title content--centered qa-brand-hero-title"> Welcome to the Looker Community </h1> <div class="hero-search"> <form method="get" action="/web/20210813055819/https://community.looker.com/search"> <div class="searchbox searchbox--large qa-search-area"> <div class="searchbox__input qa-menu-search-input"> <div class=" algolia-search" data-preact="algolia/components/Search" data-props="{"isUserGuest":true,"isFederatedSalesforceSearch":false,"isFederatedSkilljarSearch":false,"isFederatedFreshdeskSearch":false,"isAlgoliaAnswersActive":true,"category":null,"isParentCategory":null,"searchByContentType":null,"groupId":null,"displayFilters":null,"phrases":{"Forum":{"live.search.placeholder":"Search for discussions, ideas, help, and best practices","live.search.search.text":"Search:","show.results":"Show results","advanced.search.filters":"Filters","live.search.no.result.found.text":"No results found for:","live.search.trending.text":"Trending","live.search.ask.question":"Ask question to the community","live.search.view.all":"View all","topic.form.type.discussion.label":"Conversation","content_type.label.article":"Article","content_type.label.question":"Question","answered.mark.title":"Solved","ask.question.title":"Ask question","ask.question.title.description":"Start your question with 'What', 'How' etc and phrase it like a question.","ask.question.optional.description":"Add description (optional)","cancel":"Cancel","create":"Create","title":"Title","Choose your subject":"Choose your category","post.textarea.label":"Description","topic.editor.subforum.title":"Category","topic.first.reply.placeholder.textarea":"Add as many details as possible, by providing details you\u2019ll make it easier for others to reply","wysiwyg.h1.btn.title":"Large heading","wysiwyg.h3.btn.title":"Small heading","wysiwyg.embed.btn.title":"Embed media","wysiwyg.video_embed.btn.title":"Video embed","Save":"Save","Cancel":"Cancel","wysiwyg.submenu.title":"More options","wysiwyg.features.links.text_input":"Text","wysiwyg.features.links.link_input":"URL","wysiwyg.features.links.link_input.placeholder":"Paste a link","wysiwyg.modals.embed.title":"Embed media","wysiwyg.modals.embed.placeholder":"Paste a link to embed media. Supported platforms: YouTube, Soundcloud, Deezer, Vimeo, Dailymotion.","wysiwyg.modals.embed.submit":"Insert","wysiwyg.features.links.link_button":"Save","Upload image":"Upload image","o_embed.error.error_no_url":"Missing embed URL","o_embed.error.error_not_valid_url":"URL provided is not valid","o_embed.error.error_service_not_supported":"The provided domain is not supported","o_embed.error.error_not_retrieved":"Embed data could not be retrieved","vraag":"Question","advanced.search.show.more.topics":"Show {number} results","forumList.meta.counter.post.user.new":"{n} new","beantwoord":"Solved","Sticky":"Sticky","topicList.meta.voted":"Voted","topicList.meta.vote":"Vote","Show more":"Show more activity"},"Control":{"editor.controls.quote":"Quote","editor.controls.spoiler":"Spoiler","editor.controls.code":"Code","editor.controls.url":"Url"},"Common":{"advanced.search.filter.clear.all":"Clear all","bb.spoiler.show-content":"Show content","bb.spoiler.hide-content":"Hide content","wrote":"wrote","js.attachments.place_in_text":"Place in text","js.attachments.show_as_attachment":"Show as attachment","js.attachments.delete":"Delete","js.uploader.error_file_type":"Sorry, we couldn't upload your file because we don't support that file type. Supported file types: {allowed_files_type}","js.uploader.error_file_size":"Sorry, we couldn\u2019t upload your file because it's too big. Maximum file size: {allowed_files_size}","content_type.label.idea":"Idea","js.uploader.error_on_upload":"Something went wrong, please check your link and try again."}}}"><div><input type="search" placeholder="Search for discussions, ideas, help, and best practices" class="search-box__input"></div></div> </div> </div> </form> </div> </div> </div> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--statistics_bar widget-container--statistics_bar homepage-widget-container--statistics_bar widget-container--statistics_bar homepage-widget-container--index-5 widget-container--index-5" data-idx="5"> <div class="widget-placeholder"> <section class="full-width Template-brand-stats custom-stats-bar"> <div class="stats-bar p-v qa-stats-bar"> <div class="sitewidth"> <div class="col"> <ul class="list list--stats-bar qa-stats-bar"> <li class="list__item"> <strong>7,046</strong> <span>Topics</span> </li> <li class="list__item"> <strong>15,700</strong> <span>Replies</span> </li> <li class="list__item"> <strong>13,281</strong> <span>Members</span> </li> </ul> <div id="last-visitors-widget" class="last-visitors qa-last-visitors is-hidden-M pull-right"> <div data-preact="widget-last-visitors/LastVisitors" class="" data-props="{"phrases":{"Forum":{"branded.last-visitors.title":"Recently online","Badges":"Badges","About":"About","Topic|Topics":"Topic|Topics","Reply|Replies":"Reply|Replies","Solved":"Solved","member.profile.no.badges":"{username} did not receive any badges yet."}},"liveData":null}"></div> </div> </div> </div> </div> </section> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--quick_links widget-container--quick_links homepage-widget-container--quick_links widget-container--quick_links homepage-widget-container--index-6 widget-container--index-6" data-idx="6"> <div class="widget-placeholder"> <div data-preact="quick-links/QuickLinksContainer" class="" data-props="{"data":[{"title":"Getting started","url":"https:\/\/community.looker.com\/getting-started-1006\/getting-started-in-the-looker-community-20572","description":"New user? Click here to get started in the Community.","openNewTab":false,"imageSrc":null,"iconSrc":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/9799073f-4d21-485d-b806-2822141d3e45_thumb.png","icon_src":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/9799073f-4d21-485d-b806-2822141d3e45_thumb.png","image_src":null,"target":false},{"title":"Events & (Virtual) Meetups","url":"https:\/\/community.looker.com\/events","description":"Learn about our awesome events","openNewTab":true,"imageSrc":null,"iconSrc":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/d53af519-d675-42de-8e87-2b589b33998a_thumb.png","icon_src":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/d53af519-d675-42de-8e87-2b589b33998a_thumb.png","image_src":null,"target":true},{"title":"Have a Question?","url":"https:\/\/community.looker.com\/topic\/new","description":"Ask away! Someone here has an answer.","openNewTab":true,"imageSrc":null,"iconSrc":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/58f03691-9083-4e8f-a537-2e6165f8dc8c_thumb.png","icon_src":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/58f03691-9083-4e8f-a537-2e6165f8dc8c_thumb.png","image_src":null,"target":true},{"title":"Community Groups","url":"https:\/\/community.looker.com\/groups","description":"Find others interested in the same topics as you.","openNewTab":false,"imageSrc":null,"iconSrc":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/c19aa1a9-3fbb-4fbc-8b1c-e109e682cdfc_thumb.png","icon_src":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/c19aa1a9-3fbb-4fbc-8b1c-e109e682cdfc_thumb.png","image_src":null,"target":false},{"title":"What's New","url":"https:\/\/community.looker.com\/news-announcements-1007","description":"Get the latest news about Looker & the Community","openNewTab":true,"imageSrc":null,"iconSrc":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/8f7cd6d1-9927-4e72-ba3e-b0b1ad8fb424_thumb.png","icon_src":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/8f7cd6d1-9927-4e72-ba3e-b0b1ad8fb424_thumb.png","image_src":null,"target":true},{"title":"The Kitchen Table","url":"https:\/\/community.looker.com\/the-kitchen-table-1020","description":"A collection of Looker knowledge for you to explore","openNewTab":true,"imageSrc":null,"iconSrc":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/29aef78a-add9-47c2-ab55-bec59f2a2dda_thumb.jpg","icon_src":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/29aef78a-add9-47c2-ab55-bec59f2a2dda_thumb.jpg","image_src":null,"target":true}],"settings":{"borderRadius":8,"enableBorder":true},"title":"","itemsPerContainer":6}"><section class="full-width Template-brand-featured qa-quicklinks-container quicklinks-wrapper homepage-widget-wrapper custom-quicklink"><div class="sitewidth"><div class="col"><div class="content--centered quicklink__container"><article class="featured-topic quicklink__box has-border card-widget-wrapper quicklink-icon" style="border-radius: 8px;"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/getting-started-in-the-looker-community-20572" class="quicklink__url" tabindex="0" target><figure class="figure-padding__icon"><div role="img" aria-label="Quicklink image 1" class="lazy padding__icon quicklink__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/9799073f-4d21-485d-b806-2822141d3e45_thumb.png"> </div></figure><div class="quicklink__title"><header><h3 class="card-widget-title">Getting started</h3></header><p class="text--meta card-widget-text">New user? Click here to get started in the Community.</p></div></a></article><article class="featured-topic quicklink__box has-border card-widget-wrapper quicklink-icon" style="border-radius: 8px;"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/events" class="quicklink__url" tabindex="0" target="_blank"><figure class="figure-padding__icon"><div role="img" aria-label="Quicklink image 2" class="lazy padding__icon quicklink__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/d53af519-d675-42de-8e87-2b589b33998a_thumb.png"> </div></figure><div class="quicklink__title"><header><h3 class="card-widget-title">Events & (Virtual) Meetups</h3></header><p class="text--meta card-widget-text">Learn about our awesome events</p></div></a></article><article class="featured-topic quicklink__box has-border card-widget-wrapper quicklink-icon" style="border-radius: 8px;"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/topic/new" class="quicklink__url" tabindex="0" target="_blank"><figure class="figure-padding__icon"><div role="img" aria-label="Quicklink image 3" class="lazy padding__icon quicklink__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/58f03691-9083-4e8f-a537-2e6165f8dc8c_thumb.png"> </div></figure><div class="quicklink__title"><header><h3 class="card-widget-title">Have a Question?</h3></header><p class="text--meta card-widget-text">Ask away! Someone here has an answer.</p></div></a></article><article class="featured-topic quicklink__box has-border card-widget-wrapper quicklink-icon" style="border-radius: 8px;"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/groups" class="quicklink__url" tabindex="0" target><figure class="figure-padding__icon"><div role="img" aria-label="Quicklink image 4" class="lazy padding__icon quicklink__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/c19aa1a9-3fbb-4fbc-8b1c-e109e682cdfc_thumb.png"> </div></figure><div class="quicklink__title"><header><h3 class="card-widget-title">Community Groups</h3></header><p class="text--meta card-widget-text">Find others interested in the same topics as you.</p></div></a></article><article class="featured-topic quicklink__box has-border card-widget-wrapper quicklink-icon" style="border-radius: 8px;"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/news-announcements-1007" class="quicklink__url" tabindex="0" target="_blank"><figure class="figure-padding__icon"><div role="img" aria-label="Quicklink image 5" class="lazy padding__icon quicklink__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/8f7cd6d1-9927-4e72-ba3e-b0b1ad8fb424_thumb.png"> </div></figure><div class="quicklink__title"><header><h3 class="card-widget-title">What's New</h3></header><p class="text--meta card-widget-text">Get the latest news about Looker & the Community</p></div></a></article><article class="featured-topic quicklink__box has-border card-widget-wrapper quicklink-icon" style="border-radius: 8px;"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/the-kitchen-table-1020" class="quicklink__url" tabindex="0" target="_blank"><figure class="figure-padding__icon"><div role="img" aria-label="Quicklink image 6" class="lazy padding__icon quicklink__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/29aef78a-add9-47c2-ab55-bec59f2a2dda_thumb.jpg"> </div></figure><div class="quicklink__title"><header><h3 class="card-widget-title">The Kitchen Table</h3></header><p class="text--meta card-widget-text">A collection of Looker knowledge for you to explore</p></div></a></article></div></div></div></section></div> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--featured_topics widget-container--featured_topics homepage-widget-container--featured_topics widget-container--featured_topics homepage-widget-container--index-7 widget-container--index-7" data-idx="7"> <div class="widget-placeholder"> <div data-preact="widget-featured-topics/index" class="" data-props="{"title":"Stay up to date with the latest","topicsFullWidth":1,"topicIds":[{"id":26799,"type":"article"},{"id":38,"type":"event"},{"id":27860,"type":"article"},{"id":"43","type":"event"}],"buttonLabel":"Register Now","buttonUrl":"","featuredTopics":[{"url":"https:\/\/community.looker.com\/news-announcements-1007\/join-the-new-google-cloud-community-26799","title":"Join the new Google Cloud Community!","description":"<p>Did you hear? <strong>We just launched the brand-new Google Cloud Community!<\/strong> \ud83c\udf89<\/p><p>\u00a0<\/p><p>For all you Looker community members that also use Google Cloud technologies, the <a href=\"https:\/\/www.googlecloudcommunity.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google Cloud Community<\/a> is the place to connect with Cloud experts, other users, and find opportunities to up-level your skills across Cloud.\u00a0<\/p><p>\u00a0<\/p><p><u>A great way to start:<\/u><\/p><p>To honor the launch of this new community, we\u2019re hosting a super fun <a href=\"https:\/\/www.googlecloudcommunity.com\/gc\/Learning-Forums\/Learning-Challenge-1-BigQuery\/td-p\/17\" target=\"_blank\" rel=\"noreferrer noopener\">Community Challenge<\/a> where you\u2019ll earn badges, compete for Google Swag, and learn practical BigQuery skills along the way.\u00a0<\/p><p>\u00a0<\/p><p><strong>Create an Google Cloud Community account and let us know that you did on this thread and you\u2019ll get a special Looker Community badge<\/strong> \ud83d\ude0e<\/p><p>\u00a0<\/p><section class=\"callout callout-blue\"><div><p>The Google Cloud Community is <strong>separate<\/strong>\u00a0than the Looker Community and it is\u00a0<strong>not replacing <\/strong>this Community. This is still the home for all Looker-related conversations and content.\u00a0<\/p><\/div><\/section>","id":26799,"featuredImage":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/c5d8ab3d-00c5-4b94-b673-79909460eef7_thumb.png","label":"","replyCount":0,"views":157,"post":{"id":48877,"author":{"id":7656,"url":"\/members\/michael-7656","name":"Michael","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/12af5872-4a7a-4848-bc1b-8a17b8760a7a.png","userTitle":"Community Admin","rank":{"isBold":true,"isItalic":false,"isUnderline":false,"icon":"9607f595-4f68-4a88-8a78-cfdf14155bbf.png","iconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/9607f595-4f68-4a88-8a78-cfdf14155bbf.png","avatarIcon":"359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","name":"Community Admin"},"userLevel":4},"content":"Did you hear? We just launched the brand-new Google Cloud Community! \ud83c\udf89\u00a0For all you Looker community members that also use Google Cloud technologies, the Google Cloud Community is the place to connect with Cloud experts, other users, and find opportunities to up-level your skills across Cloud.\u00a0\u00a0A great way to start:To honor the launch of this new community, we\u2019re hosting a super fun Community Challenge where you\u2019ll earn badges, compete for Google Swag, and learn practical BigQuery skills along the way.\u00a0\u00a0Create an Google Cloud Community account and let us know that you did on this thread and you\u2019ll get a special Looker Community badge \ud83d\ude0e\u00a0The Google Cloud Community is separate\u00a0than the Looker Community and it is\u00a0not replacing this Community. This is still the home for all Looker-related conversations and content.\u00a0","url":"\/news-announcements-1007\/join-the-new-google-cloud-community-26799?postid=48877#post48877","creationDate":"2021-06-23T20:26:11+0000","relativeCreationDate":"1 month ago"},"contentType":"article","type":0,"likes":3,"hasCurrentUserLiked":false},{"id":38,"title":"[NORAM] \"What's New in Looker?\" Aug 2021","content":"<p><span style=\"background-color:transparent;color:#000000;\">Join us on Wednesday, August 18th for our quarterly \u2018<a href=\"https:\/\/discover.looker.com\/NorAmQ3FeatureRoundup-reg.html?utm_source=community&amp;utm_medium=community&amp;utm_campaign=7014W0000017qpFQAQ&amp;utm_term=noram&amp;utm_content=NORAMq3FeatureRoundup\" target=\"_blank\" rel=\"noreferrer noopener\">What\u2019s New in Looker<\/a>\u2019 webinar!<\/span><\/p><p>\u00a0<\/p><p><span style=\"background-color:transparent;color:#000000;\">Tune in at 11am PT \/ 2pm ET to <\/span><span style=\"background-color:transparent;color:#202124;\">learn about <\/span><span style=\"background-color:transparent;color:#000000;\">easier, more intuitive ways to create custom fields and calculations on the fly, <\/span><span style=\"background-color:transparent;color:#202124;\">Looker\u2019s enhanced navigation and improved performance and the addition of Azure as your choice of hosting environment.<\/span><\/p><p>\u00a0<\/p><p><span style=\"background-color:transparent;color:#202124;\">The session will include demos from our product managers and a live Q&amp;A.<\/span><\/p><p>\u00a0<\/p><p><span style=\"background-color:transparent;color:#202124;\">We also have an <a href=\"https:\/\/discover.looker.com\/EMEAQ3FeatureRoundup-reg.html?utm_source=community&amp;utm_medium=community&amp;utm_campaign=7014W0000017qp0QAA&amp;utm_term=emea\" target=\"_blank\" rel=\"noreferrer noopener\">EMEA-friendly webinar<\/a>\u00a0time\u00a0as well.<\/span><\/p>","author":{"id":7656,"url":"\/members\/michael-7656","name":"Michael","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/12af5872-4a7a-4848-bc1b-8a17b8760a7a.png","userTitle":"Community Admin","rank":{"isBold":true,"isItalic":false,"isUnderline":false,"icon":"9607f595-4f68-4a88-8a78-cfdf14155bbf.png","iconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/9607f595-4f68-4a88-8a78-cfdf14155bbf.png","avatarIcon":"359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","name":"Community Admin"},"userLevel":4},"type":"Webinar","url":"https:\/\/community.looker.com\/events\/noram-what-s-new-in-looker-aug-2021-38","image":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/f2942b49-1d68-4c89-a4b3-abfe1514141d_thumb.png","location":"","startsAt":1629309600,"endsAt":1629312300,"contentType":"event","attendees":[{"id":9443,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/d48aee96-3da6-4c80-a861-3fccb2eda6da.png","name":"pmaxfield","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":9498,"avatar":"","name":"LaurenWi","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":14024,"avatar":"","name":"paul.buckmaster-1625066700","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":15542,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/38d5383d-8c48-4c74-a257-ff50b80e02d8.png","name":"eltonlms","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":15599,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/2ca5b7d5-b05c-4bb0-bc0a-d8442bc8d5fb.png","name":"Carly","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}}],"attendeeCount":5,"isLoggedInUserAttendee":false,"createdAt":"1627581590"},{"url":"https:\/\/community.looker.com\/challenge-1025\/new-free-hands-on-looker-training-27860","title":"New: Free hands-on Looker training!","description":"<p>Hey all!\u00a0<\/p><p>\u00a0<\/p><p>We\u2019re running a fun Looker Learning\u00a0Challenge to provide hands-on practice in core Looker skills!\u00a0\u00a0This Learning Challenge packages up some of our hands-on learning offerings for Looker - so you or others in your org can spin up a practice instance on demand, and go step-by-step through the learning modules for free.<\/p><p>\u00a0<\/p><p>This challenge is focused on Looker foundations, with upcoming challenges going deeper and deeper across various aspects of Looker.<\/p><p>\u00a0<\/p><p><a href=\"https:\/\/www.googlecloudcommunity.com\/gc\/Learning-Forums\/New-Learning-Challenge-Looker-Data-Analytics\/td-p\/165876\" target=\"_blank\" rel=\"noreferrer noopener\">Join the game now<\/a>!<\/p><p>\u00a0<\/p><p>Happy learning \ud83d\ude42<\/p>","id":27860,"featuredImage":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/3133ab26-36de-4444-a34d-844c251cbf5c_thumb.jpg","label":"","replyCount":0,"views":81,"post":{"id":50575,"author":{"id":7656,"url":"\/members\/michael-7656","name":"Michael","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/12af5872-4a7a-4848-bc1b-8a17b8760a7a.png","userTitle":"Community Admin","rank":{"isBold":true,"isItalic":false,"isUnderline":false,"icon":"9607f595-4f68-4a88-8a78-cfdf14155bbf.png","iconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/9607f595-4f68-4a88-8a78-cfdf14155bbf.png","avatarIcon":"359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","name":"Community Admin"},"userLevel":4},"content":"Hey all!\u00a0\u00a0We\u2019re running a fun Looker Learning\u00a0Challenge to provide hands-on practice in core Looker skills!\u00a0\u00a0This Learning Challenge packages up some of our hands-on learning offerings for Looker - so you or others in your org can spin up a practice instance on demand, and go step-by-step through the learning modules for free.\u00a0This challenge is focused on Looker foundations, with upcoming challenges going deeper and deeper across various aspects of Looker.\u00a0Join the game now!\u00a0Happy learning \ud83d\ude42","url":"\/challenge-1025\/new-free-hands-on-looker-training-27860?postid=50575#post50575","creationDate":"2021-08-02T19:46:19+0000","relativeCreationDate":"10 days ago"},"contentType":"article","type":0,"likes":0,"hasCurrentUserLiked":false},{"id":43,"title":"Data Monetization Webinar with CyberGrants","content":"<section class=\"callout callout-green\"><div><p>The second webinar of our Data Monetization series.<\/p><\/div><\/section><p>\u00a0<\/p><p>The CyberGrants platform puts resources into the hands of non-profits faster by giving the world\u2019s most generous organizations the tools needed to amplify their giving, gain unsurpassed efficiencies and maximize impact for the causes they support. CyberGrants Insights helps customers quickly and easily see how effective their philanthropic efforts are, enabling them to organize, optimize, and adapt giving programs faster than ever before.<\/p><p>\u00a0<\/p><p>In this webinar, we\u2019ll sit down for a fireside chat with Erik LaRochelle, Director of Data and Analytics for CyberGrants. You\u2019ll learn about how CyberGrants:<\/p><ul><li>Used Looker to transform and differentiate their product in the market<\/li>\t<li>Went to market within 12 weeks and immediately saw their pipeline increase<\/li>\t<li>Leveraged the Looker API to build enterprise-level data experiences into their product<\/li><\/ul><p>You\u2019ll walk away with a functional understanding of how to approach an external data product strategy and have the opportunity to ask your own questions.<\/p><p>\u00a0<\/p><p><a href=\"https:\/\/discover.looker.com\/DataMonetizationWebinarSeries_Part2.html\">Register here<\/a>!<\/p>","author":{"id":7656,"url":"\/members\/michael-7656","name":"Michael","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/12af5872-4a7a-4848-bc1b-8a17b8760a7a.png","userTitle":"Community Admin","rank":{"isBold":true,"isItalic":false,"isUnderline":false,"icon":"9607f595-4f68-4a88-8a78-cfdf14155bbf.png","iconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/9607f595-4f68-4a88-8a78-cfdf14155bbf.png","avatarIcon":"359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/359c8543-b903-43cf-accb-1dffd919aed8_thumb.png","name":"Community Admin"},"userLevel":4},"type":"Webinar","url":"https:\/\/community.looker.com\/events\/data-monetization-webinar-with-cybergrants-43","image":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/2754b748-da9d-4cd2-9d66-6ff40dbb7c42_thumb.png","location":"","startsAt":1630432800,"endsAt":1630435500,"contentType":"event","attendees":[],"attendeeCount":0,"isLoggedInUserAttendee":false,"createdAt":"1628792845"}],"allProductAreas":[],"phrases":{"Forum":{"{n} year|{n} years":"{n} year|{n} years","{n} month|{n} months":"{n} month|{n} months","{n} day|{n} days":"{n} day|{n} days","{n} hour|{n} hours":"{n} hour|{n} hours","{n} minute|{n} minutes":"{n} minute|{n} minutes","just":"just now","{plural} ago":"{plural} ago"}}}"><section class="featured-topics qa-featured-topics-container sitewidth"><h3 class="widget__heading featured-topics__heading">Stay up to date with the latest</h3><div class="featured-topics__list "><article class="featured-topic featured-topic--full-width featured-topic--featured-image "><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/news-announcements-1007/join-the-new-google-cloud-community-26799" class="featured-topic__url-link"></a><div class="featured-topic__url card-widget-wrapper"><div><figure><div role="img" aria-label="Featured topic image 1" class="lazy featured-topic__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/c5d8ab3d-00c5-4b94-b673-79909460eef7_thumb.png"> </div></figure></div><div class="featured-topic__title"><h3 class="featured-topic__heading card-widget-title ">Join the new Google Cloud Community!</h3><div class="post-meta__container"><div class="post-meta__container--left"><div class="avatar avatar avatar--XS" style="float: none;"><div class="profilepicture qa-profile-picture"><a class="default-avatar-link qa-topic-meta-last-user-icon" href="/web/20210813055819/https://community.looker.com/members/michael-7656" rel="noreferrer"><img class="lazy " data-src="https://web.archive.org/web/20210813055819/https://uploads-us-west-2.insided.com/looker-en/icon/200x200/12af5872-4a7a-4848-bc1b-8a17b8760a7a.png" style="width: 100%;" title alt="Michael"/></a></div></div><span class="thread-meta-item__date">1 month ago</span></div><div class="post-meta__container--right"><span class="topic__views-count"><i class="thread-meta-item__icon icon--eye icon--auto-width" aria-hidden="true"></i><span class="thread-meta-item__text">157</span></span><span class="topic__reply-count"><i class="thread-meta-item__icon icon--comment icon--auto-width"></i><span class="thread-meta-item__text">0</span></span></div></div></div></div></article><article class="featured-topic--featured-image featured-topic "><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/events/noram-what-s-new-in-looker-aug-2021-38" class="event-list-item__url qa-event-list-item-url qa-event-"><div class="featured-event__item event-list-item-container card-widget-wrapper"><div class="event-item-image-container"><span class=" event-item__type pill pill--uppercase pill--article qa-content-type-pill">Webinar</span><div class="event-item__image" style="background-image: url(https://web.archive.org/web/20210813055819im_/https://uploads-us-west-2.insided.com/looker-en/attachment/f2942b49-1d68-4c89-a4b3-abfe1514141d_thumb.png);"></div></div><div class="event-item-detail-container"><div class=" event-item__date">Wed, Aug 18, 6:00 PM</div><h3 class="event-item__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/events/noram-what-s-new-in-looker-aug-2021-38" class="event-item__title qa-event-title card-widget-title">[NORAM] "What's New in Looker?" Aug 2021</a></h3><div class="event-item__location"><div class="event-item__location_icon"><svg width="20" height="20" viewbox="0 0 20 20"><path d="M16.6667 15C17.5833 15 18.325 14.25 18.325 13.3334L18.3333 5.00004C18.3333 4.08337 17.5833 3.33337 16.6667 3.33337H3.33333C2.41667 3.33337 1.66667 4.08337 1.66667 5.00004V13.3334C1.66667 14.25 2.41667 15 3.33333 15H0V16.6667H20V15H16.6667ZM3.33333 5.00004H16.6667V13.3334H3.33333V5.00004Z" fill="currentColor"></path></svg> </div><div></div></div></div></div></a></article><article class="featured-topic featured-topic--featured-image "><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/challenge-1025/new-free-hands-on-looker-training-27860" class="featured-topic__url-link"></a><div class="featured-topic__url card-widget-wrapper"><div><figure><div role="img" aria-label="Featured topic image 3" class="lazy featured-topic__hero" data-src="https://web.archive.org/web/20210813055819oe_/https://uploads-us-west-2.insided.com/looker-en/attachment/3133ab26-36de-4444-a34d-844c251cbf5c_thumb.jpg"> </div></figure></div><div class="featured-topic__title"><h3 class="featured-topic__heading card-widget-title ">New: Free hands-on Looker training!</h3><div class="post-meta__container"><div class="post-meta__container--left"><div class="avatar avatar avatar--XS" style="float: none;"><div class="profilepicture qa-profile-picture"><a class="default-avatar-link qa-topic-meta-last-user-icon" href="/web/20210813055819/https://community.looker.com/members/michael-7656" rel="noreferrer"><img class="lazy " data-src="https://web.archive.org/web/20210813055819/https://uploads-us-west-2.insided.com/looker-en/icon/200x200/12af5872-4a7a-4848-bc1b-8a17b8760a7a.png" style="width: 100%;" title alt="Michael"/></a></div></div><span class="thread-meta-item__date">10 days ago</span></div><div class="post-meta__container--right"><span class="topic__views-count"><i class="thread-meta-item__icon icon--eye icon--auto-width" aria-hidden="true"></i><span class="thread-meta-item__text">81</span></span><span class="topic__reply-count"><i class="thread-meta-item__icon icon--comment icon--auto-width"></i><span class="thread-meta-item__text">0</span></span></div></div></div></div></article><article class="featured-topic--featured-image featured-topic "><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/events/data-monetization-webinar-with-cybergrants-43" class="event-list-item__url qa-event-list-item-url qa-event-"><div class="featured-event__item event-list-item-container card-widget-wrapper"><div class="event-item-image-container"><span class=" event-item__type pill pill--uppercase pill--article qa-content-type-pill">Webinar</span><div class="event-item__image" style="background-image: url(https://web.archive.org/web/20210813055819im_/https://uploads-us-west-2.insided.com/looker-en/attachment/2754b748-da9d-4cd2-9d66-6ff40dbb7c42_thumb.png);"></div></div><div class="event-item-detail-container"><div class=" event-item__date">Tue, Aug 31, 6:00 PM</div><h3 class="event-item__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/events/data-monetization-webinar-with-cybergrants-43" class="event-item__title qa-event-title card-widget-title">Data Monetization Webinar with CyberGrants</a></h3><div class="event-item__location"><div class="event-item__location_icon"><svg width="20" height="20" viewbox="0 0 20 20"><path d="M16.6667 15C17.5833 15 18.325 14.25 18.325 13.3334L18.3333 5.00004C18.3333 4.08337 17.5833 3.33337 16.6667 3.33337H3.33333C2.41667 3.33337 1.66667 4.08337 1.66667 5.00004V13.3334C1.66667 14.25 2.41667 15 3.33333 15H0V16.6667H20V15H16.6667ZM3.33333 5.00004H16.6667V13.3334H3.33333V5.00004Z" fill="currentColor"></path></svg> </div><div></div></div></div></div></a></article></div></section></div> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--container_2_1 widget-container--container_2_1 homepage-widget-container--container_2_1 widget-container--container_2_1 homepage-widget-container--index-8 widget-container--index-8" data-idx="8"> <div class="widget-placeholder"> <div class="full-width Template-content"><div class="sitewidth custom-content-stream_with_sidebar homepage-widget-wrapper widget-wrapper"><div class="col col--main has--side qa-div-main custom-content-stream widget-container--container-2-1-column_1"><div class="widget-container widget-container--category_and_topics_stream_only widget-container--container-2-1-column_1-index-0" data-idx="0"><div class="widget-placeholder"><div class="sitewidth"><div class="box pagebox box--unbox"><div class="box__content"><div class="module widget--tabs tabs qa-widget-tabs"><nav class="sections__nav sections__nav--accordion-S" data-helper="tabs" data-data="{"openLastVisitedTab":true,"storagePostfix":"homepage"}"><div class="tabs--nav__container"><div class="tabs--nav"><ul class="tabs--navigation qa-tabs-menu"><li class="tabs__item tabs__item--M qa-tab"><a href="/web/20210813055819/https://community.looker.com/search/activity/recent" class="qa-link-tab js-tab branded/_index-recent-topics is-active" data-tab="1"> Recently active </a></li><li class="tabs__item tabs__item--M qa-tab"><a href="#" class="qa-link-tab js-tab _index-forums " data-tab="2"> Categories </a></li><li class="tabs__item tabs__item--M qa-tab"><a href="/web/20210813055819/https://community.looker.com/search/activity/unanswered" class="qa-link-tab js-tab branded/_index-unanswered-topics " data-tab="3"> Help others </a></li></ul></div></div><div class="tabs--navigation"><li class="tabs__item tabs__item--S"><a href="/web/20210813055819/https://community.looker.com/search/activity/recent" class="qa-link-tab js-tab branded/_index-recent-topics is-active" data-tab="1"> Recently active </a></li><div class="tabs qa-tabs"><div class="js-content js-content-1 qa-tab-isVisible"><div class=" qa-widget-recent-topics topic-list-view" data-preact="topic-list-view/TopicListView" data-props="{"isGuest":true,"tab":"Recently Active","requestUrl":"\/search\/recentTopics","query":{"sort":"lastPostDate","sortOrder":"DESC","minReplies":0,"maxResults":10,"notForumIds":[1011]},"translations":{"Custom":{"in":"in"},"Forum":{"vraag":"Question","topic.form.type.discussion.label":"Conversation","forumList.meta.counter.post.user.new":"{n} new","beantwoord":"Solved","Sticky":"Sticky","topicList.meta.voted":"Voted","topicList.meta.vote":"Vote","Show more":"Show more activity"}},"attachmentCdn":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/","topics":[{"firstPost":{"id":1518,"author":{"id":197,"url":"\/members\/shohei-197","name":"shohei","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/824c529071c2a306702ac26084a23255ef183082_197.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"About This Block\u00a0Note: you can find an alternative pattern for multi-level peer comparison and \u201cshare of wallet\u201d comparison here\u00a0\u00a0Peer comparison analysis shows you how one group, categorized by an individual or set of determinants, is performing against another group. You can take this one step further, and compare that first group against of the rest of the population of users\/items. This helps companies get a comprehensive view of an individual item\u2019s performance based on any number of attributes that you collect about that product, user, etc. Peer comparison has helped companies answer many questions, such as:\u00a0\u00a0How is Sales Rep A performing compared to others in his\/her geography? Compared to the national average?\tHow is the average weekly growth of Stock A trending compared to the rest of the portfolio?\tWhat is the customer conversion rate for visitors referred from Google and Facebook compared to all other channels?\tWhat is the most popular or profitable category of item sold by Brand A, compared to every other brand?In this example, we will demonstrate how you can implement peer comparison, or Rest of the Population, analysis in Looker using a sample eCommerce dataset. In the process, we will uncover two key takeaways:\u00a0How average profit dollars vary between item categories across brands\tWhich item category is the most popular in one brand compared, to all other brands\u00a0Ideal Data TypesThis Block is best suited for datasets containing individual or groups of populations such as brands, sales representatives, regions, etc. This data may come from Salesforce, web analytics tools (Google Analytics, Segment, etc.), and other transactional data tied to groups that can be singled out for comparison against everybody else.\u00a0In terms of KPIs, averages or percent-of-total calculations work best, as these KPIs enable you to look at apples-to-apples comparisons across groups. On the flip side, totals and cumulative calculations will skew the results towards larger groups, especially for the Rest of the Population category. We will explore both results to show you what kind of insights you should be looking for in peer comparisons.\u00a0Expected OutputPeer comparison analysis allows you to see how one individual \/ group is performing compared to the rest of the population in one or more KPIs.\u00a0This sample image compares the number of Calvin Klein products with the rest of the products offered by this retailer. With this info in hand, a brand manager may decide to focus on marketing campaigns to increase sales for Calvin Klein by focusing on the items with the highest product count.\u00a0\u00a0Try it yourself!\u00a0How It\u2019s Done\u00a0This is a very simple and easy-to-implement pattern utilizing both filter-only fields and Liquid parameters to specify individual groups to compare with the rest of the population. Part of the beauty of this approach of using Liquid in Looker is that it allows end-users to make the item selection straight from the user interface, which is then safely inserted as SQL into our optimizer.\u00a0\u00a0We will first start with creating a filter-only field in LookML. Filter-only fields are created using the following syntax:\u00a0 filter: insert filter field name here { suggest_dimension: (insert dimension name where potential values come from)}\u00a0The suggest_dimension parameter enables you to use an existing dimension from which to select your desired individual \/ group. While the use of suggest_dimension is optional, it is highly recommended, especially if you have dimensions referring to brand names, sales representative names, region \/ state names, etc., to ensure users select the correct values rather than mistyping them using free form text.\u00a0\u00a0For our example, we\u2019ll want to define a filter-only field to select specific brand names as described below:\u00a0\u00a0 filter: brand_select { suggest_dimension: brand.name }\u00a0The second field we\u2019ll define is a comparitor dimension. This is where Liquid parameters come into play:\u00a0\u00a0 dimension: brand_comparitor { type: string sql: CASE WHEN {% condition brand_select %} ${brand_name} {% endcondition %} THEN ${brand_name} ELSE 'Rest of Population' END ;; }\u00a0What\u2019s happening here is the following:\u00a0\u00a0The brand_comparitor dimension reads the values specified in the brand_select filter\tFor each brand_name entry in the data table, if the brand_name value matches the value in brand_select, that same brand_name is returned.\tIf the brand_name value does not match what\u2019s in brand_select, it gets grouped into \u201cRest of Population.\u201d\t\u00a0\t\u00a0\u00a0Now you can select any measure and slice it by this brand_comparitor to see the results grouped by each value captured in brand_select, as well as all other values captured in \u201cRest of Population\u201d!\u00a0\u00a0With this Looker Analytics Block under your belt, you\u2019re on your way to creating more peer comparison patterns. Some common combinations of filter-only fields and comparitor dimensions include:\u00a0Sales reps\tStock and other securities\tProduct categories\tSKUs in inventory management\tetc.\u00a0\u00a0Compare to Entire Population\u00a0\u00a0This design can also be used to compare groups to the entire population just by tweaking the LookML logic. Let\u2019s take a look at the following LookML:\u00a0\u00a0**Model File**explore: products { hidden: true join: num { type: cross relationship: one_to_many }}**View File**view: num { derived_table : { sql: SELECT 1 as n UNION SELECT 2 ;;} dimension: n { hidden: true}\u00a0Notice the cross join to num containing the values 1 and 2; we\u2019ve just created a fanout in order to obtain two rows per entry in products so we can aggregate data for selected groups using num.n = 2. Though other groups will each have two rows, the one_to_many relationship lets Looker know to be aware of this fanout in order to avoid double-counting, and correctly calculate symmetric aggregates.\u00a0\u00a0Next, we\u2019ll edit the brand_comparitor dimension to reflect the change in business logic:\u00a0\u00a0dimension: brand_comparitor {type: string sql: CASE WHEN {% condition brand_select %} ${brand_name} {% endcondition %} AND ${num.n} = 1 THEN ${brand_name} ELSE 'Total Of Population' END ;;}\u00a0This CASE statement runs through the following steps:\u00a0\u00a0For each row, look for brand_name that matches brand_select, and where num.n = 1\tIf brand_name indeed matches brand_select, that entry gets grouped by brand_name\tIf the brand_name doesn\u2019t match brand_select or num.n = 2, that entry gets thrown into the Total of Population category\t\u00a0\t\u00a0\u00a0Due to the one_to_many relationship, Looker will use COUNT DISTINCT instead of COUNT to accurately aggregate whatever measure you\u2019re using.\u00a0\u00a0The following is an example of what the results look like:\u00a0\u00a0\u00a0","url":"https:\/\/community.looker.com\/lookml-5\/analytic-block-peer-comparison-compare-against-rest-of-population-1518","creationDate":"2015-10-15T19:18:26+0000","relativeCreationDate":"5 years ago"},"isTopicUnread":true,"privateId":24,"id":1518,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[],"forum":{"id":5,"isIdeation":false,"url":"\/lookml-5","title":"LookML","description":"LookML design patterns, best practices, hacks, and knowledge sharing"},"url":"https:\/\/community.looker.com\/lookml-5\/analytic-block-peer-comparison-compare-against-rest-of-population-1518","title":"[Analytic Block] Peer Comparison: Compare Against Rest of Population","lastPost":{"id":531,"author":{"id":7621,"url":"\/members\/gendemo-7621","name":"GenDemo","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/c718834f-a21d-4a08-9aa3-edb30f2cb7ef.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":3},"content":"","url":"https:\/\/community.looker.com\/lookml-5\/analytic-block-peer-comparison-compare-against-rest-of-population-1518?postid=50758#post50758","creationDate":"2021-08-13T05:11:12+0000","relativeCreationDate":"47 minutes ago"},"numberOfUnreadReplies":0,"numberOfReplies":3,"numberOfLikes":3,"relevantPost":{"id":1518,"author":{"id":197,"url":"\/members\/shohei-197","name":"shohei","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/824c529071c2a306702ac26084a23255ef183082_197.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"About This Block\u00a0Note: you can find an alternative pattern for multi-level peer comparison and \u201cshare of wallet\u201d comparison here\u00a0\u00a0Peer comparison analysis shows you how one group, categorized by an individual or set of determinants, is performing against another group. You can take this one step further, and compare that first group against of the rest of the population of users\/items. This helps companies get a comprehensive view of an individual item\u2019s performance based on any number of attributes that you collect about that product, user, etc. Peer comparison has helped companies answer many questions, such as:\u00a0\u00a0How is Sales Rep A performing compared to others in his\/her geography? Compared to the national average?\tHow is the average weekly growth of Stock A trending compared to the rest of the portfolio?\tWhat is the customer conversion rate for visitors referred from Google and Facebook compared to all other channels?\tWhat is the most popular or profitable category of item sold by Brand A, compared to every other brand?In this example, we will demonstrate how you can implement peer comparison, or Rest of the Population, analysis in Looker using a sample eCommerce dataset. In the process, we will uncover two key takeaways:\u00a0How average profit dollars vary between item categories across brands\tWhich item category is the most popular in one brand compared, to all other brands\u00a0Ideal Data TypesThis Block is best suited for datasets containing individual or groups of populations such as brands, sales representatives, regions, etc. This data may come from Salesforce, web analytics tools (Google Analytics, Segment, etc.), and other transactional data tied to groups that can be singled out for comparison against everybody else.\u00a0In terms of KPIs, averages or percent-of-total calculations work best, as these KPIs enable you to look at apples-to-apples comparisons across groups. On the flip side, totals and cumulative calculations will skew the results towards larger groups, especially for the Rest of the Population category. We will explore both results to show you what kind of insights you should be looking for in peer comparisons.\u00a0Expected OutputPeer comparison analysis allows you to see how one individual \/ group is performing compared to the rest of the population in one or more KPIs.\u00a0This sample image compares the number of Calvin Klein products with the rest of the products offered by this retailer. With this info in hand, a brand manager may decide to focus on marketing campaigns to increase sales for Calvin Klein by focusing on the items with the highest product count.\u00a0\u00a0Try it yourself!\u00a0How It\u2019s Done\u00a0This is a very simple and easy-to-implement pattern utilizing both filter-only fields and Liquid parameters to specify individual groups to compare with the rest of the population. Part of the beauty of this approach of using Liquid in Looker is that it allows end-users to make the item selection straight from the user interface, which is then safely inserted as SQL into our optimizer.\u00a0\u00a0We will first start with creating a filter-only field in LookML. Filter-only fields are created using the following syntax:\u00a0 filter: insert filter field name here { suggest_dimension: (insert dimension name where potential values come from)}\u00a0The suggest_dimension parameter enables you to use an existing dimension from which to select your desired individual \/ group. While the use of suggest_dimension is optional, it is highly recommended, especially if you have dimensions referring to brand names, sales representative names, region \/ state names, etc., to ensure users select the correct values rather than mistyping them using free form text.\u00a0\u00a0For our example, we\u2019ll want to define a filter-only field to select specific brand names as described below:\u00a0\u00a0 filter: brand_select { suggest_dimension: brand.name }\u00a0The second field we\u2019ll define is a comparitor dimension. This is where Liquid parameters come into play:\u00a0\u00a0 dimension: brand_comparitor { type: string sql: CASE WHEN {% condition brand_select %} ${brand_name} {% endcondition %} THEN ${brand_name} ELSE 'Rest of Population' END ;; }\u00a0What\u2019s happening here is the following:\u00a0\u00a0The brand_comparitor dimension reads the values specified in the brand_select filter\tFor each brand_name entry in the data table, if the brand_name value matches the value in brand_select, that same brand_name is returned.\tIf the brand_name value does not match what\u2019s in brand_select, it gets grouped into \u201cRest of Population.\u201d\t\u00a0\t\u00a0\u00a0Now you can select any measure and slice it by this brand_comparitor to see the results grouped by each value captured in brand_select, as well as all other values captured in \u201cRest of Population\u201d!\u00a0\u00a0With this Looker Analytics Block under your belt, you\u2019re on your way to creating more peer comparison patterns. Some common combinations of filter-only fields and comparitor dimensions include:\u00a0Sales reps\tStock and other securities\tProduct categories\tSKUs in inventory management\tetc.\u00a0\u00a0Compare to Entire Population\u00a0\u00a0This design can also be used to compare groups to the entire population just by tweaking the LookML logic. Let\u2019s take a look at the following LookML:\u00a0\u00a0**Model File**explore: products { hidden: true join: num { type: cross relationship: one_to_many }}**View File**view: num { derived_table : { sql: SELECT 1 as n UNION SELECT 2 ;;} dimension: n { hidden: true}\u00a0Notice the cross join to num containing the values 1 and 2; we\u2019ve just created a fanout in order to obtain two rows per entry in products so we can aggregate data for selected groups using num.n = 2. Though other groups will each have two rows, the one_to_many relationship lets Looker know to be aware of this fanout in order to avoid double-counting, and correctly calculate symmetric aggregates.\u00a0\u00a0Next, we\u2019ll edit the brand_comparitor dimension to reflect the change in business logic:\u00a0\u00a0dimension: brand_comparitor {type: string sql: CASE WHEN {% condition brand_select %} ${brand_name} {% endcondition %} AND ${num.n} = 1 THEN ${brand_name} ELSE 'Total Of Population' END ;;}\u00a0This CASE statement runs through the following steps:\u00a0\u00a0For each row, look for brand_name that matches brand_select, and where num.n = 1\tIf brand_name indeed matches brand_select, that entry gets grouped by brand_name\tIf the brand_name doesn\u2019t match brand_select or num.n = 2, that entry gets thrown into the Total of Population category\t\u00a0\t\u00a0\u00a0Due to the one_to_many relationship, Looker will use COUNT DISTINCT instead of COUNT to accurately aggregate whatever measure you\u2019re using.\u00a0\u00a0The following is an example of what the results look like:\u00a0\u00a0\u00a0","url":"https:\/\/community.looker.com\/lookml-5\/analytic-block-peer-comparison-compare-against-rest-of-population-1518","creationDate":"2015-10-15T19:18:26+0000","relativeCreationDate":"5 years ago"},"numberOfViews":746,"contentType":"article","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"531"},{"firstPost":{"id":27933,"author":{"id":8648,"url":"\/members\/tattyklass-8648","name":"tattyklass","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/6a80bec075e1fbf81baaa8a55b2f846c7def94b3_8648.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you\u2019ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this affect my instance?Your workflow in Looker should only be interrupted by this change if you have projects that connect to git using HTTPS, and these projects do not have two factor authentication (2FA) setup. For projects connected to git using HTTPS with a password, git actions will not be available until the project's git connection is reconfigured with one of the two options listed below. Option 1.) Continue using HTTPS but re-configure to use a token for authentication, as described in this community article.Option 2.)\u00a0 Reconfigure and connect to GitHub using SSH\u00a0instead of HTTPS.How do I know if I\u2019m using SSH or HTTPS?You can check to see how your project is connected to git by running a git connection test from the git action panel to see your remote repository URL. If this URL starts with \u201chttps:\/\/github\u201d it is configured using https, if it starts with git@ it is configured using ssh. Will I lose any development by reconfiguring?The reconfiguration process should just be changing how you are authenticating into your git repository from Looker, so no commits that are there when you reconfigure should get lost. You may want to ensure that all users have committed their changes before you reconfigure. What if I have a bare repo? Will I be affected?No, bar repos are not connected to GitHub or any other remote repo. This change only affects GitHub with password authentication.What if I have a looker-hosted remote repository?Looker hosted repositories are connected with ssh keys or two factor authentication, so these should not be affected by this change.Will there be downtime while I reconfigure the connection?There will be no downtime for your instance during a git connection reconfiguration. For projects connected to git that use\u00a0HTTPS with a password, git actions (ex. Committing changes or pulling from production) will not be available until the project's Git connection is reconfigured.","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","creationDate":"2021-08-13T00:17:42+0000","relativeCreationDate":"5 hours ago"},"isTopicUnread":true,"privateId":4087,"id":27933,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1021,"isIdeation":false,"url":"\/technical-tips-tricks-1021","title":"Technical Tips & Tricks","description":"Previously internal product knowledge now available for you to explore!"},"url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","title":"Common Questions About GitHub Authentication Changes Made on August 13th","lastPost":{"id":27933,"author":{"id":8648,"url":"\/members\/tattyklass-8648","name":"tattyklass","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/6a80bec075e1fbf81baaa8a55b2f846c7def94b3_8648.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you\u2019ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this affect my instance?Your workflow in Looker should only be interrupted by this change if you have projects that connect to git using HTTPS, and these projects do not have two factor authentication (2FA) setup. For projects connected to git using HTTPS with a password, git actions will not be available until the project's git connection is reconfigured with one of the two options listed below. Option 1.) Continue using HTTPS but re-configure to use a token for authentication, as described in this community article.Option 2.)\u00a0 Reconfigure and connect to GitHub using SSH\u00a0instead of HTTPS.How do I know if I\u2019m using SSH or HTTPS?You can check to see how your project is connected to git by running a git connection test from the git action panel to see your remote repository URL. If this URL starts with \u201chttps:\/\/github\u201d it is configured using https, if it starts with git@ it is configured using ssh. Will I lose any development by reconfiguring?The reconfiguration process should just be changing how you are authenticating into your git repository from Looker, so no commits that are there when you reconfigure should get lost. You may want to ensure that all users have committed their changes before you reconfigure. What if I have a bare repo? Will I be affected?No, bar repos are not connected to GitHub or any other remote repo. This change only affects GitHub with password authentication.What if I have a looker-hosted remote repository?Looker hosted repositories are connected with ssh keys or two factor authentication, so these should not be affected by this change.Will there be downtime while I reconfigure the connection?There will be no downtime for your instance during a git connection reconfiguration. For projects connected to git that use\u00a0HTTPS with a password, git actions (ex. Committing changes or pulling from production) will not be available until the project's Git connection is reconfigured.","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","creationDate":"2021-08-13T00:17:42+0000","relativeCreationDate":"5 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":4,"relevantPost":{"id":27933,"author":{"id":8648,"url":"\/members\/tattyklass-8648","name":"tattyklass","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/6a80bec075e1fbf81baaa8a55b2f846c7def94b3_8648.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you\u2019ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this affect my instance?Your workflow in Looker should only be interrupted by this change if you have projects that connect to git using HTTPS, and these projects do not have two factor authentication (2FA) setup. For projects connected to git using HTTPS with a password, git actions will not be available until the project's git connection is reconfigured with one of the two options listed below. Option 1.) Continue using HTTPS but re-configure to use a token for authentication, as described in this community article.Option 2.)\u00a0 Reconfigure and connect to GitHub using SSH\u00a0instead of HTTPS.How do I know if I\u2019m using SSH or HTTPS?You can check to see how your project is connected to git by running a git connection test from the git action panel to see your remote repository URL. If this URL starts with \u201chttps:\/\/github\u201d it is configured using https, if it starts with git@ it is configured using ssh. Will I lose any development by reconfiguring?The reconfiguration process should just be changing how you are authenticating into your git repository from Looker, so no commits that are there when you reconfigure should get lost. You may want to ensure that all users have committed their changes before you reconfigure. What if I have a bare repo? Will I be affected?No, bar repos are not connected to GitHub or any other remote repo. This change only affects GitHub with password authentication.What if I have a looker-hosted remote repository?Looker hosted repositories are connected with ssh keys or two factor authentication, so these should not be affected by this change.Will there be downtime while I reconfigure the connection?There will be no downtime for your instance during a git connection reconfiguration. For projects connected to git that use\u00a0HTTPS with a password, git actions (ex. Committing changes or pulling from production) will not be available until the project's Git connection is reconfigured.","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","creationDate":"2021-08-13T00:17:42+0000","relativeCreationDate":"5 hours ago"},"numberOfViews":23,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/the-kitchen-table-1020","categoryId":1020,"title":"The Kitchen Table","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27931,"author":{"id":15419,"url":"\/members\/carosierpe-15419","name":"Carosierpe","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/7e551d94-8904-4537-a055-0eaffe97b22b.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hello Looker community!I\u2019m in need of help, i\u2019ve been struggling with this for a while and I\u2019m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows\u00a0how many orders I\u2019ve got in a period of time compared to last year. When I click that Look being in explore mode, the drill overlay appears with the detail of every single order in that period.But when I add the\u00a0Look to a dashboard, if I click the value nothing happens, but\u00a0I expect it to show the same drill overlay\u00a0When clicking \u201c1.637\u201d the drill overlay should appear but it doesn\u2019t.\u00a0Is there something I\u2019m missing? I thought this would be very straightforward.Thanks!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","creationDate":"2021-08-12T20:57:30+0000","relativeCreationDate":"9 hours ago"},"isTopicUnread":true,"privateId":4086,"id":27931,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":7,"isIdeation":false,"url":"\/dashboards-looks-7","title":"Dashboards & looks","description":"Building reports & visualizations in Looker"},"url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","title":"Drilling though a tile in a dashboard","lastPost":{"id":27931,"author":{"id":15419,"url":"\/members\/carosierpe-15419","name":"Carosierpe","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/7e551d94-8904-4537-a055-0eaffe97b22b.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hello Looker community!I\u2019m in need of help, i\u2019ve been struggling with this for a while and I\u2019m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows\u00a0how many orders I\u2019ve got in a period of time compared to last year. When I click that Look being in explore mode, the drill overlay appears with the detail of every single order in that period.But when I add the\u00a0Look to a dashboard, if I click the value nothing happens, but\u00a0I expect it to show the same drill overlay\u00a0When clicking \u201c1.637\u201d the drill overlay should appear but it doesn\u2019t.\u00a0Is there something I\u2019m missing? I thought this would be very straightforward.Thanks!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","creationDate":"2021-08-12T20:57:30+0000","relativeCreationDate":"9 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27931,"author":{"id":15419,"url":"\/members\/carosierpe-15419","name":"Carosierpe","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/7e551d94-8904-4537-a055-0eaffe97b22b.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hello Looker community!I\u2019m in need of help, i\u2019ve been struggling with this for a while and I\u2019m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows\u00a0how many orders I\u2019ve got in a period of time compared to last year. When I click that Look being in explore mode, the drill overlay appears with the detail of every single order in that period.But when I add the\u00a0Look to a dashboard, if I click the value nothing happens, but\u00a0I expect it to show the same drill overlay\u00a0When clicking \u201c1.637\u201d the drill overlay should appear but it doesn\u2019t.\u00a0Is there something I\u2019m missing? I thought this would be very straightforward.Thanks!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","creationDate":"2021-08-12T20:57:30+0000","relativeCreationDate":"9 hours ago"},"numberOfViews":3,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27930,"author":{"id":9152,"url":"\/members\/dylan-hornstein-9152","name":"dylan.hornstein","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0b0299c4a9a2f84cf3c41357f8a2d8d31db66980_9152.jpg","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We have a large base_table in our Snowflake database that contains row-by-row transactions\u00a0from all of our subscribers.I\u2019m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally,\u00a0I would stage the data for that subscriber one time, and then have various tiles\/queries utilize the staged data to\u00a0avoid\u00a0querying the large base_table over and over with each tile.\u00a0Here is a simple SQL example.CREATE TABLE stage_data AS( SELECT subscriber_id, country, transaction_id, ... FROM base_table WHERE subscriber_id = &lt;subscriber_id&gt; AND date &gt;= &lt;start_date&gt; AND date &lt; &lt;end_date&gt; );--query1SELECT &lt;query1 cols&gt; FROM stage_data;--query2SELECT &lt;query2 cols&gt; FROM stage_data;...--query10SELECT &lt;query10 cols&gt; FROM stage_data;Or, in LookML...view: aggregate_1 { sql_table_name: stage_data.SQL_TABLE_NAME dimension: country {} measure: txn_cnt {type: count_distinct sql: ${tracking_id}} ...}view: aggregate_2 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_3 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_10 { sql_table_name: stage_data.SQL_TABLE_NAME ...}explore: stage_data {}view: stage_data { derived_table: { persist_for: \"10 minutes\" sql: SELECT subscriber_id, msg_day, tracking_id, country, ... FROM base_table WHERE {% condition stage_data.subscriber_id %} subscriber_id {% endcondition %} AND {% condition stage_data.msg_day_date %} msg_day {% endcondition %} ;; } dimension: subscriber_id {} dimension_group: msg_day {type: time} dimension: tracking_id {} dimension: country {} ...}The problem: The user needs to be able to select the subscriber_id and date range for the report, but\u00a0I cannot dynamically pass a liquid variable into the CREATE TABLE process. It seems that liquid variable reference simply isn\u2019t supported for PDTs.\u00a0We don\u2019t want to\u00a0stage data for every customer individually\u00a0because this report will\u00a0only be used for new customers in a POC. Staging data for every customer\u00a0is not necessary, and costly in terms of storage and query time.I\u2019ve tried many ways to get this to work, with no success. I\u2019ve tried both SQL-derived-tables and NDTs. NDTs produce a LookML error \u201cCannot persist NDTs with dynamic filters\u201d. SQL-derived-tables do not produce any LookML errors, but it leave\u00a0the liquid syntax in the query that gets\u00a0sent to Snowflake, which results in a syntax error\u00a0\u00a0Has anyone figured out how to stage data using dynamic filters???","url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","creationDate":"2021-08-12T19:59:33+0000","relativeCreationDate":"9 hours ago"},"isTopicUnread":true,"privateId":4085,"id":27930,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":5,"isIdeation":false,"url":"\/lookml-5","title":"LookML","description":"LookML design patterns, best practices, hacks, and knowledge sharing"},"url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","title":"Issue Staging Data Dynamically","lastPost":{"id":27930,"author":{"id":9152,"url":"\/members\/dylan-hornstein-9152","name":"dylan.hornstein","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0b0299c4a9a2f84cf3c41357f8a2d8d31db66980_9152.jpg","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We have a large base_table in our Snowflake database that contains row-by-row transactions\u00a0from all of our subscribers.I\u2019m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally,\u00a0I would stage the data for that subscriber one time, and then have various tiles\/queries utilize the staged data to\u00a0avoid\u00a0querying the large base_table over and over with each tile.\u00a0Here is a simple SQL example.CREATE TABLE stage_data AS( SELECT subscriber_id, country, transaction_id, ... FROM base_table WHERE subscriber_id = &lt;subscriber_id&gt; AND date &gt;= &lt;start_date&gt; AND date &lt; &lt;end_date&gt; );--query1SELECT &lt;query1 cols&gt; FROM stage_data;--query2SELECT &lt;query2 cols&gt; FROM stage_data;...--query10SELECT &lt;query10 cols&gt; FROM stage_data;Or, in LookML...view: aggregate_1 { sql_table_name: stage_data.SQL_TABLE_NAME dimension: country {} measure: txn_cnt {type: count_distinct sql: ${tracking_id}} ...}view: aggregate_2 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_3 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_10 { sql_table_name: stage_data.SQL_TABLE_NAME ...}explore: stage_data {}view: stage_data { derived_table: { persist_for: \"10 minutes\" sql: SELECT subscriber_id, msg_day, tracking_id, country, ... FROM base_table WHERE {% condition stage_data.subscriber_id %} subscriber_id {% endcondition %} AND {% condition stage_data.msg_day_date %} msg_day {% endcondition %} ;; } dimension: subscriber_id {} dimension_group: msg_day {type: time} dimension: tracking_id {} dimension: country {} ...}The problem: The user needs to be able to select the subscriber_id and date range for the report, but\u00a0I cannot dynamically pass a liquid variable into the CREATE TABLE process. It seems that liquid variable reference simply isn\u2019t supported for PDTs.\u00a0We don\u2019t want to\u00a0stage data for every customer individually\u00a0because this report will\u00a0only be used for new customers in a POC. Staging data for every customer\u00a0is not necessary, and costly in terms of storage and query time.I\u2019ve tried many ways to get this to work, with no success. I\u2019ve tried both SQL-derived-tables and NDTs. NDTs produce a LookML error \u201cCannot persist NDTs with dynamic filters\u201d. SQL-derived-tables do not produce any LookML errors, but it leave\u00a0the liquid syntax in the query that gets\u00a0sent to Snowflake, which results in a syntax error\u00a0\u00a0Has anyone figured out how to stage data using dynamic filters???","url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","creationDate":"2021-08-12T19:59:33+0000","relativeCreationDate":"9 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27930,"author":{"id":9152,"url":"\/members\/dylan-hornstein-9152","name":"dylan.hornstein","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0b0299c4a9a2f84cf3c41357f8a2d8d31db66980_9152.jpg","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We have a large base_table in our Snowflake database that contains row-by-row transactions\u00a0from all of our subscribers.I\u2019m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally,\u00a0I would stage the data for that subscriber one time, and then have various tiles\/queries utilize the staged data to\u00a0avoid\u00a0querying the large base_table over and over with each tile.\u00a0Here is a simple SQL example.CREATE TABLE stage_data AS( SELECT subscriber_id, country, transaction_id, ... FROM base_table WHERE subscriber_id = &lt;subscriber_id&gt; AND date &gt;= &lt;start_date&gt; AND date &lt; &lt;end_date&gt; );--query1SELECT &lt;query1 cols&gt; FROM stage_data;--query2SELECT &lt;query2 cols&gt; FROM stage_data;...--query10SELECT &lt;query10 cols&gt; FROM stage_data;Or, in LookML...view: aggregate_1 { sql_table_name: stage_data.SQL_TABLE_NAME dimension: country {} measure: txn_cnt {type: count_distinct sql: ${tracking_id}} ...}view: aggregate_2 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_3 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_10 { sql_table_name: stage_data.SQL_TABLE_NAME ...}explore: stage_data {}view: stage_data { derived_table: { persist_for: \"10 minutes\" sql: SELECT subscriber_id, msg_day, tracking_id, country, ... FROM base_table WHERE {% condition stage_data.subscriber_id %} subscriber_id {% endcondition %} AND {% condition stage_data.msg_day_date %} msg_day {% endcondition %} ;; } dimension: subscriber_id {} dimension_group: msg_day {type: time} dimension: tracking_id {} dimension: country {} ...}The problem: The user needs to be able to select the subscriber_id and date range for the report, but\u00a0I cannot dynamically pass a liquid variable into the CREATE TABLE process. It seems that liquid variable reference simply isn\u2019t supported for PDTs.\u00a0We don\u2019t want to\u00a0stage data for every customer individually\u00a0because this report will\u00a0only be used for new customers in a POC. Staging data for every customer\u00a0is not necessary, and costly in terms of storage and query time.I\u2019ve tried many ways to get this to work, with no success. I\u2019ve tried both SQL-derived-tables and NDTs. NDTs produce a LookML error \u201cCannot persist NDTs with dynamic filters\u201d. SQL-derived-tables do not produce any LookML errors, but it leave\u00a0the liquid syntax in the query that gets\u00a0sent to Snowflake, which results in a syntax error\u00a0\u00a0Has anyone figured out how to stage data using dynamic filters???","url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","creationDate":"2021-08-12T19:59:33+0000","relativeCreationDate":"9 hours ago"},"numberOfViews":5,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":23474,"author":{"id":1171,"url":"\/members\/sam-1171","name":"sam","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1f003aa7-dfb2-4f91-bf22-41c6add5d89f.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":5},"content":"Last tested: March 2021Looker\u2019s\u00a0\u201cyesno\u201d dimensions return boolean values (TRUE or FALSE) rather than a string \u201cyes\u201d or \u201cno\u201d. For this reason, when SQL is involved, you don\u2019t need to write \u201cfield == yes\u201d, you can simply write \u201cfield\u201d, as this will return TRUE or FALSE by itself. Here are specific examples depending on where you\u2019d like to reference it:\u00a0SQL:You can treat it as a boolean.sql: CASE WHEN ${field} THEN ...Filtered Measure: measure: first_purchase_count { type: count filters:[is_first_purchase:\"Yes\"]Liquid HTML{% if value == 'Yes' %} will do it.Note: it is case sensitive.Templated filter:We put a boolean in between the condition, like:derived_table: {sql:SELECT murder FROM public.rawhere {% condition filter %} murder=10 {% endcondition %} ;; }dimension: filter {type: yesnosql: ${TABLE}.murder=10;;}\u00a0cite docs for type yesno , docs for filtered measures and docs for liquid variables\u00a0This content is subject to limited support.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/how-do-you-reference-a-yesno-dimension-field-value-23474","creationDate":"2021-03-26T00:16:59+0000","relativeCreationDate":"4 months ago"},"isTopicUnread":true,"privateId":313,"id":23474,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[],"forum":{"id":1021,"isIdeation":false,"url":"\/technical-tips-tricks-1021","title":"Technical Tips & Tricks","description":"Previously internal product knowledge now available for you to explore!"},"url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/how-do-you-reference-a-yesno-dimension-field-value-23474","title":"How do you reference a yesno dimension field value?","lastPost":{"id":529,"author":{"id":1171,"url":"\/members\/sam-1171","name":"sam","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1f003aa7-dfb2-4f91-bf22-41c6add5d89f.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":5},"content":"","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/how-do-you-reference-a-yesno-dimension-field-value-23474?postid=50752#post50752","creationDate":"2021-08-12T19:10:21+0000","relativeCreationDate":"10 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":2,"numberOfLikes":0,"relevantPost":{"id":23474,"author":{"id":1171,"url":"\/members\/sam-1171","name":"sam","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1f003aa7-dfb2-4f91-bf22-41c6add5d89f.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":5},"content":"Last tested: March 2021Looker\u2019s\u00a0\u201cyesno\u201d dimensions return boolean values (TRUE or FALSE) rather than a string \u201cyes\u201d or \u201cno\u201d. For this reason, when SQL is involved, you don\u2019t need to write \u201cfield == yes\u201d, you can simply write \u201cfield\u201d, as this will return TRUE or FALSE by itself. Here are specific examples depending on where you\u2019d like to reference it:\u00a0SQL:You can treat it as a boolean.sql: CASE WHEN ${field} THEN ...Filtered Measure: measure: first_purchase_count { type: count filters:[is_first_purchase:\"Yes\"]Liquid HTML{% if value == 'Yes' %} will do it.Note: it is case sensitive.Templated filter:We put a boolean in between the condition, like:derived_table: {sql:SELECT murder FROM public.rawhere {% condition filter %} murder=10 {% endcondition %} ;; }dimension: filter {type: yesnosql: ${TABLE}.murder=10;;}\u00a0cite docs for type yesno , docs for filtered measures and docs for liquid variables\u00a0This content is subject to limited support.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/how-do-you-reference-a-yesno-dimension-field-value-23474","creationDate":"2021-03-26T00:16:59+0000","relativeCreationDate":"4 months ago"},"numberOfViews":587,"contentType":"article","featuredImage":"","publicLabel":"Knowledge Drop","category":{"url":"\/the-kitchen-table-1020","categoryId":1020,"title":"The Kitchen Table","metaRobots":"index, follow","type":0},"lastPostId":"529"},{"firstPost":{"id":27893,"author":{"id":15400,"url":"\/members\/avikdebnath21-15400","name":"avikdebnath21","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/39342066-70ae-448d-b626-d55758d438a6.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have registered myself for the \u201cGetting Started with LookML\u201d course on Looker training. After filling up the form for learn.looker sandbox access, I still haven\u2019t received access (invite) to the Sandbox.\u00a0\u00a0Usually how long does it take for a new user to get the sandbox access ?","url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893","creationDate":"2021-08-06T13:59:26+0000","relativeCreationDate":"6 days ago"},"isTopicUnread":true,"privateId":4055,"id":27893,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1006,"isIdeation":false,"url":"\/getting-started-1006","title":"Getting started","description":"Getting Started in the Looker Community"},"url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893","title":"Did not get access to Sandbox","lastPost":{"id":12427,"author":{"id":6469,"url":"\/members\/olga-6469","name":"olga","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/353795222d43f7b787ba5e70c1de1d858395694c_6469.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893?postid=50751#post50751","creationDate":"2021-08-12T18:16:28+0000","relativeCreationDate":"11 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27893,"author":{"id":15400,"url":"\/members\/avikdebnath21-15400","name":"avikdebnath21","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/39342066-70ae-448d-b626-d55758d438a6.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have registered myself for the \u201cGetting Started with LookML\u201d course on Looker training. After filling up the form for learn.looker sandbox access, I still haven\u2019t received access (invite) to the Sandbox.\u00a0\u00a0Usually how long does it take for a new user to get the sandbox access ?","url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893","creationDate":"2021-08-06T13:59:26+0000","relativeCreationDate":"6 days ago"},"numberOfViews":13,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/welcome-1000","categoryId":1000,"title":"Welcome","metaRobots":"index, follow","type":0},"lastPostId":"12427"},{"firstPost":{"id":27916,"author":{"id":15648,"url":"\/members\/nttdata-15648","name":"NTTData","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/04f5d993-c1e3-468c-b6ea-bbffd0e0babd.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m Newbie at Looker. I\u2019m trying to understand the capabilities of this tool and compare with other BI tools. I\u2019m working with Power BI and SAP Analytics Cloud in the last few years. I have some questions, I will be glad if you answer what you know from the questions.\u00a0How does Looker work ? Import data method or Live connection method ?\tDoes Looker need any setup to connect databases ? Like gateway etc\u2026\tDoes Looker has ETL Layer to make transformations ?\tCan we create a report from excel file ?\u00a0\tCan I create my own connection. (For example Dremio or SAP Business Warehouse)\tCan we connect multiple data source and combine them ?\u00a0\tDoes Looker only developed from Web or can be worked on desktop with offline ? (For ex. Power BI can allow working offline on personal computer)\tDoes Looker have a Mobil integration ? (Can we reach reports from mobile)\tIs there any option to develop predictive models in Looker ?\tDoes Looker has IBCS certification ?\u00a0(International Business\u00a0Communication Standards )If anyone have experience at Power BI or SAP Analytics cloud and working with Looker, Could you please make some comments what Looker does better\/worse compare to other BI tools.","url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916","creationDate":"2021-08-11T08:56:10+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":4073,"id":27916,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1006,"isIdeation":false,"url":"\/getting-started-1006","title":"Getting started","description":"Getting Started in the Looker Community"},"url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916","title":"Looker Abilities","lastPost":{"id":12426,"author":{"id":6469,"url":"\/members\/olga-6469","name":"olga","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/353795222d43f7b787ba5e70c1de1d858395694c_6469.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916?postid=50750#post50750","creationDate":"2021-08-12T18:07:06+0000","relativeCreationDate":"11 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27916,"author":{"id":15648,"url":"\/members\/nttdata-15648","name":"NTTData","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/04f5d993-c1e3-468c-b6ea-bbffd0e0babd.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m Newbie at Looker. I\u2019m trying to understand the capabilities of this tool and compare with other BI tools. I\u2019m working with Power BI and SAP Analytics Cloud in the last few years. I have some questions, I will be glad if you answer what you know from the questions.\u00a0How does Looker work ? Import data method or Live connection method ?\tDoes Looker need any setup to connect databases ? Like gateway etc\u2026\tDoes Looker has ETL Layer to make transformations ?\tCan we create a report from excel file ?\u00a0\tCan I create my own connection. (For example Dremio or SAP Business Warehouse)\tCan we connect multiple data source and combine them ?\u00a0\tDoes Looker only developed from Web or can be worked on desktop with offline ? (For ex. Power BI can allow working offline on personal computer)\tDoes Looker have a Mobil integration ? (Can we reach reports from mobile)\tIs there any option to develop predictive models in Looker ?\tDoes Looker has IBCS certification ?\u00a0(International Business\u00a0Communication Standards )If anyone have experience at Power BI or SAP Analytics cloud and working with Looker, Could you please make some comments what Looker does better\/worse compare to other BI tools.","url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916","creationDate":"2021-08-11T08:56:10+0000","relativeCreationDate":"1 day ago"},"numberOfViews":22,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/welcome-1000","categoryId":1000,"title":"Welcome","metaRobots":"index, follow","type":0},"lastPostId":"12426"},{"firstPost":{"id":27929,"author":{"id":15497,"url":"\/members\/tkshimon-15497","name":"tkshimon","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have created a Looker extension in ReactJS application. Able to run React app locally and its working fine with the Looker (added localhost url in the Looker project manifest file). But since the extension running in my local machine it is not accessible to\u00a0 other developers\u00a0whos working on the same Looker instance.\u00a0How do I need to deploy the extension so that it should able to access all the developers who has access to that looker instance?\u00a0Does Looker provides any app server to run my extension app?","url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929","creationDate":"2021-08-12T17:59:12+0000","relativeCreationDate":"11 hours ago"},"isTopicUnread":true,"privateId":4084,"id":27929,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":75,"isIdeation":false,"url":"\/embedding-looker-powered-by-looker-75","title":"Embedding Looker \/ Powered by Looker","description":"Sharing data with a broader audience"},"url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929","title":"Looker ReactJS Extension Deployment","lastPost":{"id":12425,"author":{"id":2336,"url":"\/members\/iant-2336","name":"IanT","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0f3174688e96c69dee18423738cc386ce627985d_2336.png","userTitle":"Good Looker","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Good Looker"},"userLevel":6},"content":"","url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929?postid=50749#post50749","creationDate":"2021-08-12T18:01:44+0000","relativeCreationDate":"11 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27929,"author":{"id":15497,"url":"\/members\/tkshimon-15497","name":"tkshimon","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have created a Looker extension in ReactJS application. Able to run React app locally and its working fine with the Looker (added localhost url in the Looker project manifest file). But since the extension running in my local machine it is not accessible to\u00a0 other developers\u00a0whos working on the same Looker instance.\u00a0How do I need to deploy the extension so that it should able to access all the developers who has access to that looker instance?\u00a0Does Looker provides any app server to run my extension app?","url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929","creationDate":"2021-08-12T17:59:12+0000","relativeCreationDate":"11 hours ago"},"numberOfViews":5,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/application-development-1003","categoryId":1003,"title":"Application development","metaRobots":"index, follow","type":0},"lastPostId":"12425"},{"firstPost":{"id":27926,"author":{"id":15715,"url":"\/members\/jchan-15715","name":"jchan","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/fc52630d-7136-4fa3-8280-dd039ee171b9.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"As a beginner in Looker,\u00a0 I\u2019m currently tasked with making the row limit as a global filter.My goal is that letting\u00a0users\u00a0to decide\u00a0how many rows they want to get on each tile (top 5, top 10 etc) by selecting any number in customized filter.I tried using `row()` function in table calculation to get the row number, but still cannot assign it as a global-view filter finally.Is there any workaround such as creating a measure to deal with this, or there is already a solution?Thanks for the time and help!\u00a0","url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926","creationDate":"2021-08-12T06:23:48+0000","relativeCreationDate":"23 hours ago"},"isTopicUnread":true,"privateId":4081,"id":27926,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":7,"isIdeation":false,"url":"\/dashboards-looks-7","title":"Dashboards & looks","description":"Building reports & visualizations in Looker"},"url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926","title":"Can row limit be set as a global filter?","lastPost":{"id":12424,"author":{"id":6469,"url":"\/members\/olga-6469","name":"olga","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/353795222d43f7b787ba5e70c1de1d858395694c_6469.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926?postid=50747#post50747","creationDate":"2021-08-12T17:38:11+0000","relativeCreationDate":"12 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27926,"author":{"id":15715,"url":"\/members\/jchan-15715","name":"jchan","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/fc52630d-7136-4fa3-8280-dd039ee171b9.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"As a beginner in Looker,\u00a0 I\u2019m currently tasked with making the row limit as a global filter.My goal is that letting\u00a0users\u00a0to decide\u00a0how many rows they want to get on each tile (top 5, top 10 etc) by selecting any number in customized filter.I tried using `row()` function in table calculation to get the row number, but still cannot assign it as a global-view filter finally.Is there any workaround such as creating a measure to deal with this, or there is already a solution?Thanks for the time and help!\u00a0","url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926","creationDate":"2021-08-12T06:23:48+0000","relativeCreationDate":"23 hours ago"},"numberOfViews":30,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12424"},{"firstPost":{"id":27928,"author":{"id":15747,"url":"\/members\/ericdjshepherd-15747","name":"ericdjshepherd","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m new to Looker but enjoying learning my way around.I would like to use this block -\u00a0https:\/\/looker.com\/platform\/blocks\/source\/cost-and-usage-analysis-by-snowflake\u00a0- but I\u2019m not able to figure out how to import it into my Looker environment.The \u201cNew LookML Project\u201d option does appear to allow pulling code in from a remote repository; however, it only works with repos that allow access using the \u2018git:\/\/\u2019 protocol and the one referenced above does not.Are there any other options to enable me to import this code?\u00a0 The link above is hosted by Looker so it seems logical that there should be some way to make use of it.Thanks,Eric","url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928","creationDate":"2021-08-12T15:23:10+0000","relativeCreationDate":"14 hours ago"},"isTopicUnread":true,"privateId":4083,"id":27928,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1006,"isIdeation":false,"url":"\/getting-started-1006","title":"Getting started","description":"Getting Started in the Looker Community"},"url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928","title":"Snowflake Usage Block","lastPost":{"id":12423,"author":{"id":15747,"url":"\/members\/ericdjshepherd-15747","name":"ericdjshepherd","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928?postid=50745#post50745","creationDate":"2021-08-12T16:17:57+0000","relativeCreationDate":"13 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27928,"author":{"id":15747,"url":"\/members\/ericdjshepherd-15747","name":"ericdjshepherd","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m new to Looker but enjoying learning my way around.I would like to use this block -\u00a0https:\/\/looker.com\/platform\/blocks\/source\/cost-and-usage-analysis-by-snowflake\u00a0- but I\u2019m not able to figure out how to import it into my Looker environment.The \u201cNew LookML Project\u201d option does appear to allow pulling code in from a remote repository; however, it only works with repos that allow access using the \u2018git:\/\/\u2019 protocol and the one referenced above does not.Are there any other options to enable me to import this code?\u00a0 The link above is hosted by Looker so it seems logical that there should be some way to make use of it.Thanks,Eric","url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928","creationDate":"2021-08-12T15:23:10+0000","relativeCreationDate":"14 hours ago"},"numberOfViews":4,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/welcome-1000","categoryId":1000,"title":"Welcome","metaRobots":"index, follow","type":0},"lastPostId":"12423"}]}"><div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><span class="thread-list-block__title-label thread-list-block__title-label--article pill pill--uppercase pill--article pill--align-top"> Article </span><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/lookml-5/analytic-block-peer-comparison-compare-against-rest-of-population-1518" class="qa-topic-title thread-list-block__title-link"> [Analytic Block] Peer Comparison: Compare Against Rest of Population </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/lookml-5/analytic-block-peer-comparison-compare-against-rest-of-population-1518"> About This Block Note: you can find an alternative pattern for multi-level peer comparison and “share of wallet” comparison here Peer comparison analysis shows you how one group, categorized by an individual or set of determinants, is performing against another group. You can take this one step fur... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/lookml-5" class="thread-list-block__category-link"> LookML </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021/common-questions-about-github-authentication-changes-made-on-august-13th-27933" class="qa-topic-title thread-list-block__title-link"> Common Questions About GitHub Authentication Changes Made on August 13th </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021/common-questions-about-github-authentication-changes-made-on-august-13th-27933"> What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you’ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this af... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021" class="thread-list-block__category-link"> Technical Tips & Tricks </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/drilling-though-a-tile-in-a-dashboard-27931" class="qa-topic-title thread-list-block__title-link"> Drilling though a tile in a dashboard </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/drilling-though-a-tile-in-a-dashboard-27931"> Hello Looker community!I’m in need of help, i’ve been struggling with this for a while and I’m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows how... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/dashboards-looks-7" class="thread-list-block__category-link"> Dashboards & looks </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/lookml-5/issue-staging-data-dynamically-27930" class="qa-topic-title thread-list-block__title-link"> Issue Staging Data Dynamically </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/lookml-5/issue-staging-data-dynamically-27930"> We have a large base_table in our Snowflake database that contains row-by-row transactions from all of our subscribers.I’m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally, I would stage the data for that subscriber one time, and then have... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/lookml-5" class="thread-list-block__category-link"> LookML </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><span class="thread-list-block__title-label thread-list-block__title-label--article pill pill--uppercase pill--article pill--align-top"> Article </span><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021/how-do-you-reference-a-yesno-dimension-field-value-23474" class="qa-topic-title thread-list-block__title-link"> How do you reference a yesno dimension field value? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021/how-do-you-reference-a-yesno-dimension-field-value-23474"> Last tested: March 2021Looker’s “yesno” dimensions return boolean values (TRUE or FALSE) rather than a string “yes” or “no”. For this reason, when SQL is involved, you don’t need to write “field == yes”, you can simply write “field”, as this will return TRUE or FALSE by itself. Here are specific exa... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021" class="thread-list-block__category-link"> Technical Tips & Tricks </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/did-not-get-access-to-sandbox-27893" class="qa-topic-title thread-list-block__title-link"> Did not get access to Sandbox </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/did-not-get-access-to-sandbox-27893"> I have registered myself for the “Getting Started with LookML” course on Looker training. After filling up the form for learn.looker sandbox access, I still haven’t received access (invite) to the Sandbox. Usually how long does it take for a new user to get the sandbox access ? </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" class="thread-list-block__category-link"> Getting started </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/looker-abilities-27916" class="qa-topic-title thread-list-block__title-link"> Looker Abilities </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/looker-abilities-27916"> Hi All,I’m Newbie at Looker. I’m trying to understand the capabilities of this tool and compare with other BI tools. I’m working with Power BI and SAP Analytics Cloud in the last few years. I have some questions, I will be glad if you answer what you know from the questions. How does Looker work ? I... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" class="thread-list-block__category-link"> Getting started </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75/looker-reactjs-extension-deployment-27929" class="qa-topic-title thread-list-block__title-link"> Looker ReactJS Extension Deployment </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75/looker-reactjs-extension-deployment-27929"> I have created a Looker extension in ReactJS application. Able to run React app locally and its working fine with the Looker (added localhost url in the Looker project manifest file). But since the extension running in my local machine it is not accessible to other developers whos working on the sa... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75" class="thread-list-block__category-link"> Embedding Looker / Powered by Looker </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/can-row-limit-be-set-as-a-global-filter-27926" class="qa-topic-title thread-list-block__title-link"> Can row limit be set as a global filter? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/can-row-limit-be-set-as-a-global-filter-27926"> As a beginner in Looker, I’m currently tasked with making the row limit as a global filter.My goal is that letting users to decide how many rows they want to get on each tile (top 5, top 10 etc) by selecting any number in customized filter.I tried using `row()` function in table calculation to get... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/dashboards-looks-7" class="thread-list-block__category-link"> Dashboards & looks </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/snowflake-usage-block-27928" class="qa-topic-title thread-list-block__title-link"> Snowflake Usage Block </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/snowflake-usage-block-27928"> Hi All,I’m new to Looker but enjoying learning my way around.I would like to use this block - https://looker.com/platform/blocks/source/cost-and-usage-analysis-by-snowflake - but I’m not able to figure out how to import it into my Looker environment.The “New LookML Project” option does appear to all... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" class="thread-list-block__category-link"> Getting started </a></span></span></div></div></div></div></div><li class="tabs__item tabs__item--S"><a href="#" class="qa-link-tab js-tab _index-forums " data-tab="2"> Categories </a></li><div class="tabs qa-tabs"><div class="js-content js-content-2 is-hidden--loose qa-tab-isVisible"><div class="forum-list"><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-1000"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/welcome-1000" data-track="{"type":"Category Clicked","category_title":"Welcome","category_url":"\/welcome-1000","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Welcome","Link":"\/welcome-1000","Type":"parent category"}}" class="link--subforum qa-category-link">Welcome</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="category-description text--meta">Rules, announcements, and important information</div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1006" id="category-1006"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Getting started","category_url":"\/getting-started-1006","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Getting started","Link":"\/getting-started-1006","Type":"community"}}">Getting started</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">67 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">166 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1007" id="category-1007"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/news-announcements-1007" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"News & announcements","category_url":"\/news-announcements-1007","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"News & announcements","Link":"\/news-announcements-1007","Type":"community"}}">News & announcements</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">104 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">151 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="66" id="category-66"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/who-s-hiring-66" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Who's hiring","category_url":"\/who-s-hiring-66","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Who's hiring","Link":"\/who-s-hiring-66","Type":"community"}}">Who's hiring</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">381 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">31 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="71" id="category-71"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/release-notes-archive-71" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Release notes (archive)","category_url":"\/release-notes-archive-71","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Release notes (archive)","Link":"\/release-notes-archive-71","Type":"community"}}">Release notes (archive)</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">63 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">512 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1017" id="category-1017"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/lesson-comments-1017" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Lesson Comments","category_url":"\/lesson-comments-1017","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Lesson Comments","Link":"\/lesson-comments-1017","Type":"community"}}">Lesson Comments</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">11 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">0 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1025" id="category-1025"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/challenge-1025" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Challenge","category_url":"\/challenge-1025","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Challenge","Link":"\/challenge-1025","Type":"community"}}">Challenge</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">10 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">10 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-1001"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/looker-development-1001" data-track="{"type":"Category Clicked","category_title":"Looker development","category_url":"\/looker-development-1001","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Looker development","Link":"\/looker-development-1001","Type":"parent category"}}" class="link--subforum qa-category-link">Looker development</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="category-description text--meta">Developing LookML, writing SQL, and modeling data</div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="5" id="category-5"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/lookml-5" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"LookML","category_url":"\/lookml-5","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"LookML","Link":"\/lookml-5","Type":"community"}}">LookML</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">1335 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">3791 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="10" id="category-10"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/sql-10" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"SQL","category_url":"\/sql-10","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"SQL","Link":"\/sql-10","Type":"community"}}">SQL</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">256 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">698 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-1002"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/exploring-curating-data-1002" data-track="{"type":"Category Clicked","category_title":"Exploring & curating data","category_url":"\/exploring-curating-data-1002","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Exploring & curating data","Link":"\/exploring-curating-data-1002","Type":"parent category"}}" class="link--subforum qa-category-link">Exploring & curating data</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="category-description text--meta">Dashboards, Looks, Visualizations— it all happens here</div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="36" id="category-36"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/explores-36" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Explores","category_url":"\/explores-36","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Explores","Link":"\/explores-36","Type":"community"}}">Explores</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">428 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">1281 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="7" id="category-7"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/dashboards-looks-7" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Dashboards & looks","category_url":"\/dashboards-looks-7","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Dashboards & looks","Link":"\/dashboards-looks-7","Type":"community"}}">Dashboards & looks</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">1163 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">3342 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-1003"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/application-development-1003" data-track="{"type":"Category Clicked","category_title":"Application development","category_url":"\/application-development-1003","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Application development","Link":"\/application-development-1003","Type":"parent category"}}" class="link--subforum qa-category-link">Application development</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="category-description text--meta">Extensions, open source tools, the Looker API, and embedding Looker</div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="75" id="category-75"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Embedding Looker \/ Powered by Looker","category_url":"\/embedding-looker-powered-by-looker-75","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Embedding Looker \/ Powered by Looker","Link":"\/embedding-looker-powered-by-looker-75","Type":"community"}}">Embedding Looker / Powered by Looker</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">103 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">269 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="78" id="category-78"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/open-source-projects-78" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Open source projects","category_url":"\/open-source-projects-78","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Open source projects","Link":"\/open-source-projects-78","Type":"community"}}">Open source projects</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">44 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">141 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="77" id="category-77"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/looker-api-77" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Looker API","category_url":"\/looker-api-77","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Looker API","Link":"\/looker-api-77","Type":"community"}}">Looker API</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">287 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">1054 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-154"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/administration-154" data-track="{"type":"Category Clicked","category_title":"Administration","category_url":"\/administration-154","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Administration","Link":"\/administration-154","Type":"parent category"}}" class="link--subforum qa-category-link">Administration</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="category-description text--meta">Looker set-up and management</div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1009" id="category-1009"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/user-access-management-1009" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"User access & management","category_url":"\/user-access-management-1009","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"User access & management","Link":"\/user-access-management-1009","Type":"community"}}">User access & management</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">20 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">33 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="35" id="category-35"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/general-looker-administration-35" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"General Looker administration","category_url":"\/general-looker-administration-35","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"General Looker administration","Link":"\/general-looker-administration-35","Type":"community"}}">General Looker administration</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">375 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">1093 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-158"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/data-science-analytics-158" data-track="{"type":"Category Clicked","category_title":"Data science & analytics","category_url":"\/data-science-analytics-158","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Data science & analytics","Link":"\/data-science-analytics-158","Type":"parent category"}}" class="link--subforum qa-category-link">Data science & analytics</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="category-description text--meta">Everything from mean() to machine learning</div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="79" id="category-79"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/got-a-question-79" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Got a question?","category_url":"\/got-a-question-79","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Got a question?","Link":"\/got-a-question-79","Type":"community"}}">Got a question?</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">60 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">164 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="80" id="category-80"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/share-your-best-practices-80" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Share your best practices","category_url":"\/share-your-best-practices-80","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Share your best practices","Link":"\/share-your-best-practices-80","Type":"community"}}">Share your best practices</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">11 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">7 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-161"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A9%E3%83%A0-japanese-161" data-track="{"type":"Category Clicked","category_title":"\u30b3\u30df\u30e5\u30cb\u30c6\u30a3\u30d5\u30a9\u30fc\u30e9\u30e0 (Japanese)","category_url":"\/%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A9%E3%83%A0-japanese-161","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"\u30b3\u30df\u30e5\u30cb\u30c6\u30a3\u30d5\u30a9\u30fc\u30e9\u30e0 (Japanese)","Link":"\/%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E3%83%95%E3%82%A9%E3%83%BC%E3%83%A9%E3%83%A0-japanese-161","Type":"parent category"}}" class="link--subforum qa-category-link">コミュニティフォーラム (Japanese)</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="100" id="category-100"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/%E3%83%8B%E3%83%A5%E3%83%BC%E3%82%B9%E3%81%A8%E5%91%8A%E7%9F%A5-100" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"\u30cb\u30e5\u30fc\u30b9\u3068\u544a\u77e5","category_url":"\/%E3%83%8B%E3%83%A5%E3%83%BC%E3%82%B9%E3%81%A8%E5%91%8A%E7%9F%A5-100","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"\u30cb\u30e5\u30fc\u30b9\u3068\u544a\u77e5","Link":"\/%E3%83%8B%E3%83%A5%E3%83%BC%E3%82%B9%E3%81%A8%E5%91%8A%E7%9F%A5-100","Type":"community"}}">ニュースと告知</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">34 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">21 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="101" id="category-101"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/%E3%83%98%E3%83%AB%E3%83%97%E3%81%A8%E3%82%B5%E3%83%9D%E3%83%BC%E3%83%88-101" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"\u30d8\u30eb\u30d7\u3068\u30b5\u30dd\u30fc\u30c8","category_url":"\/%E3%83%98%E3%83%AB%E3%83%97%E3%81%A8%E3%82%B5%E3%83%9D%E3%83%BC%E3%83%88-101","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"\u30d8\u30eb\u30d7\u3068\u30b5\u30dd\u30fc\u30c8","Link":"\/%E3%83%98%E3%83%AB%E3%83%97%E3%81%A8%E3%82%B5%E3%83%9D%E3%83%BC%E3%83%88-101","Type":"community"}}">ヘルプとサポート</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">10 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">17 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="103" id="category-103"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/%E3%82%B3%E3%83%A9%E3%83%A0-103" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"\u30b3\u30e9\u30e0","category_url":"\/%E3%82%B3%E3%83%A9%E3%83%A0-103","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"\u30b3\u30e9\u30e0","Link":"\/%E3%82%B3%E3%83%A9%E3%83%A0-103","Type":"community"}}">コラム</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">54 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">5 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div><div class="box"><div class="table has--caption is-collapsed qa-category" id="category-1020"><div class="table__caption category-title"><h2><a href="/web/20210813055819/https://community.looker.com/the-kitchen-table-1020" data-track="{"type":"Category Clicked","category_title":"The Kitchen Table","category_url":"\/the-kitchen-table-1020","click_source":"Homepage","category_type":"parent category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"The Kitchen Table","Link":"\/the-kitchen-table-1020","Type":"parent category"}}" class="link--subforum qa-category-link">The Kitchen Table</a></h2><span title="Collapse or expand" class="table__collapse collapse-trigger js-collapse-trigger"><svg width="12" height="8" viewbox="0 0 12 8" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1.41 7.41L6 2.83L10.59 7.41L12 6L6 0L0 6L1.41 7.41Z" fill="#6B707E"/></svg></span></div><div class="table forum-table js-collapse-content js-unread-overview"><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1021" id="category-1021"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Technical Tips & Tricks","category_url":"\/technical-tips-tricks-1021","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Technical Tips & Tricks","Link":"\/technical-tips-tricks-1021","Type":"community"}}">Technical Tips & Tricks</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">1650 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">56 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1024" id="category-1024"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/common-account-questions-1024" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"Common Account Questions","category_url":"\/common-account-questions-1024","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"Common Account Questions","Link":"\/common-account-questions-1024","Type":"community"}}">Common Account Questions</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">14 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">2 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div><div class="table__row qa-table-row forum-default qa-forum-default" data-value="1022" id="category-1022"><div class="table__cell grid--7 cell--S--first"><div class="user flag"><div class="flag__image"><div class="forum-image"></div></div><div class="user_data flag__body"><h3><a href="/web/20210813055819/https://community.looker.com/dcl-mic-drops-1022" class="link--quiet link--topic link--subforum qa-forum-overview-subforum" data-track="{"type":"Category Clicked","category_title":"DCL Mic Drops","category_url":"\/dcl-mic-drops-1022","click_source":"Homepage","category_type":"category"}" data-ga-track="{"eventCategory":"Homepage","eventAction":"Category clicked","eventLabel":{"Title":"DCL Mic Drops","Link":"\/dcl-mic-drops-1022","Type":"community"}}">DCL Mic Drops</a></h3><ul class="list list--dot-seperated text--meta m-v-S"><li class="qa-forum-overview-topic-counter">5 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">4 Replies <span class="js-post-new is-hidden qa-forum-overview-new-posts"> ({n} new) </span></li></ul></div></div></div></div></div></div></div></div></div></div><li class="tabs__item tabs__item--S"><a href="/web/20210813055819/https://community.looker.com/search/activity/unanswered" class="qa-link-tab js-tab branded/_index-unanswered-topics " data-tab="3"> Help others </a></li><div class="tabs qa-tabs"><div class="js-content js-content-3 is-hidden--loose qa-tab-isVisible"><div class=" qa-widget-recent-topics topic-list-view" data-preact="topic-list-view/TopicListView" data-props="{"isGuest":true,"tab":"Help Others","requestUrl":"\/widget\/topics","query":{"sort":"lastPostDate","sortOrder":"DESC","minReplies":0,"maxResults":10,"contentType":"question","hasBestAnswer":false,"prefixIds":["vraag"],"notForumIds":[1011]},"translations":{"Custom":{"in":"in"},"Forum":{"vraag":"Question","topic.form.type.discussion.label":"Conversation","forumList.meta.counter.post.user.new":"{n} new","Sticky":"Sticky","Show more":"Show more activity"}},"attachmentCdn":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/","topics":[{"firstPost":{"id":27933,"author":{"id":8648,"url":"\/members\/tattyklass-8648","name":"tattyklass","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/6a80bec075e1fbf81baaa8a55b2f846c7def94b3_8648.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you\u2019ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this affect my instance?Your workflow in Looker should only be interrupted by this change if you have projects that connect to git using HTTPS, and these projects do not have two factor authentication (2FA) setup. For projects connected to git using HTTPS with a password, git actions will not be available until the project's git connection is reconfigured with one of the two options listed below. Option 1.) Continue using HTTPS but re-configure to use a token for authentication, as described in this community article.Option 2.)\u00a0 Reconfigure and connect to GitHub using SSH\u00a0instead of HTTPS.How do I know if I\u2019m using SSH or HTTPS?You can check to see how your project is connected to git by running a git connection test from the git action panel to see your remote repository URL. If this URL starts with \u201chttps:\/\/github\u201d it is configured using https, if it starts with git@ it is configured using ssh. Will I lose any development by reconfiguring?The reconfiguration process should just be changing how you are authenticating into your git repository from Looker, so no commits that are there when you reconfigure should get lost. You may want to ensure that all users have committed their changes before you reconfigure. What if I have a bare repo? Will I be affected?No, bar repos are not connected to GitHub or any other remote repo. This change only affects GitHub with password authentication.What if I have a looker-hosted remote repository?Looker hosted repositories are connected with ssh keys or two factor authentication, so these should not be affected by this change.Will there be downtime while I reconfigure the connection?There will be no downtime for your instance during a git connection reconfiguration. For projects connected to git that use\u00a0HTTPS with a password, git actions (ex. Committing changes or pulling from production) will not be available until the project's Git connection is reconfigured.","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","creationDate":"2021-08-13T00:17:42+0000","relativeCreationDate":"5 hours ago"},"isTopicUnread":true,"privateId":4087,"id":27933,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1021,"isIdeation":false,"url":"\/technical-tips-tricks-1021","title":"Technical Tips & Tricks","description":"Previously internal product knowledge now available for you to explore!"},"url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","title":"Common Questions About GitHub Authentication Changes Made on August 13th","lastPost":{"id":27933,"author":{"id":8648,"url":"\/members\/tattyklass-8648","name":"tattyklass","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/6a80bec075e1fbf81baaa8a55b2f846c7def94b3_8648.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you\u2019ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this affect my instance?Your workflow in Looker should only be interrupted by this change if you have projects that connect to git using HTTPS, and these projects do not have two factor authentication (2FA) setup. For projects connected to git using HTTPS with a password, git actions will not be available until the project's git connection is reconfigured with one of the two options listed below. Option 1.) Continue using HTTPS but re-configure to use a token for authentication, as described in this community article.Option 2.)\u00a0 Reconfigure and connect to GitHub using SSH\u00a0instead of HTTPS.How do I know if I\u2019m using SSH or HTTPS?You can check to see how your project is connected to git by running a git connection test from the git action panel to see your remote repository URL. If this URL starts with \u201chttps:\/\/github\u201d it is configured using https, if it starts with git@ it is configured using ssh. Will I lose any development by reconfiguring?The reconfiguration process should just be changing how you are authenticating into your git repository from Looker, so no commits that are there when you reconfigure should get lost. You may want to ensure that all users have committed their changes before you reconfigure. What if I have a bare repo? Will I be affected?No, bar repos are not connected to GitHub or any other remote repo. This change only affects GitHub with password authentication.What if I have a looker-hosted remote repository?Looker hosted repositories are connected with ssh keys or two factor authentication, so these should not be affected by this change.Will there be downtime while I reconfigure the connection?There will be no downtime for your instance during a git connection reconfiguration. For projects connected to git that use\u00a0HTTPS with a password, git actions (ex. Committing changes or pulling from production) will not be available until the project's Git connection is reconfigured.","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","creationDate":"2021-08-13T00:17:42+0000","relativeCreationDate":"5 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":4,"relevantPost":{"id":27933,"author":{"id":8648,"url":"\/members\/tattyklass-8648","name":"tattyklass","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/6a80bec075e1fbf81baaa8a55b2f846c7def94b3_8648.png","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you\u2019ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this affect my instance?Your workflow in Looker should only be interrupted by this change if you have projects that connect to git using HTTPS, and these projects do not have two factor authentication (2FA) setup. For projects connected to git using HTTPS with a password, git actions will not be available until the project's git connection is reconfigured with one of the two options listed below. Option 1.) Continue using HTTPS but re-configure to use a token for authentication, as described in this community article.Option 2.)\u00a0 Reconfigure and connect to GitHub using SSH\u00a0instead of HTTPS.How do I know if I\u2019m using SSH or HTTPS?You can check to see how your project is connected to git by running a git connection test from the git action panel to see your remote repository URL. If this URL starts with \u201chttps:\/\/github\u201d it is configured using https, if it starts with git@ it is configured using ssh. Will I lose any development by reconfiguring?The reconfiguration process should just be changing how you are authenticating into your git repository from Looker, so no commits that are there when you reconfigure should get lost. You may want to ensure that all users have committed their changes before you reconfigure. What if I have a bare repo? Will I be affected?No, bar repos are not connected to GitHub or any other remote repo. This change only affects GitHub with password authentication.What if I have a looker-hosted remote repository?Looker hosted repositories are connected with ssh keys or two factor authentication, so these should not be affected by this change.Will there be downtime while I reconfigure the connection?There will be no downtime for your instance during a git connection reconfiguration. For projects connected to git that use\u00a0HTTPS with a password, git actions (ex. Committing changes or pulling from production) will not be available until the project's Git connection is reconfigured.","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-questions-about-github-authentication-changes-made-on-august-13th-27933","creationDate":"2021-08-13T00:17:42+0000","relativeCreationDate":"5 hours ago"},"numberOfViews":23,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/the-kitchen-table-1020","categoryId":1020,"title":"The Kitchen Table","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27931,"author":{"id":15419,"url":"\/members\/carosierpe-15419","name":"Carosierpe","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/7e551d94-8904-4537-a055-0eaffe97b22b.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hello Looker community!I\u2019m in need of help, i\u2019ve been struggling with this for a while and I\u2019m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows\u00a0how many orders I\u2019ve got in a period of time compared to last year. When I click that Look being in explore mode, the drill overlay appears with the detail of every single order in that period.But when I add the\u00a0Look to a dashboard, if I click the value nothing happens, but\u00a0I expect it to show the same drill overlay\u00a0When clicking \u201c1.637\u201d the drill overlay should appear but it doesn\u2019t.\u00a0Is there something I\u2019m missing? I thought this would be very straightforward.Thanks!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","creationDate":"2021-08-12T20:57:30+0000","relativeCreationDate":"9 hours ago"},"isTopicUnread":true,"privateId":4086,"id":27931,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":7,"isIdeation":false,"url":"\/dashboards-looks-7","title":"Dashboards & looks","description":"Building reports & visualizations in Looker"},"url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","title":"Drilling though a tile in a dashboard","lastPost":{"id":27931,"author":{"id":15419,"url":"\/members\/carosierpe-15419","name":"Carosierpe","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/7e551d94-8904-4537-a055-0eaffe97b22b.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hello Looker community!I\u2019m in need of help, i\u2019ve been struggling with this for a while and I\u2019m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows\u00a0how many orders I\u2019ve got in a period of time compared to last year. When I click that Look being in explore mode, the drill overlay appears with the detail of every single order in that period.But when I add the\u00a0Look to a dashboard, if I click the value nothing happens, but\u00a0I expect it to show the same drill overlay\u00a0When clicking \u201c1.637\u201d the drill overlay should appear but it doesn\u2019t.\u00a0Is there something I\u2019m missing? I thought this would be very straightforward.Thanks!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","creationDate":"2021-08-12T20:57:30+0000","relativeCreationDate":"9 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27931,"author":{"id":15419,"url":"\/members\/carosierpe-15419","name":"Carosierpe","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/7e551d94-8904-4537-a055-0eaffe97b22b.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hello Looker community!I\u2019m in need of help, i\u2019ve been struggling with this for a while and I\u2019m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows\u00a0how many orders I\u2019ve got in a period of time compared to last year. When I click that Look being in explore mode, the drill overlay appears with the detail of every single order in that period.But when I add the\u00a0Look to a dashboard, if I click the value nothing happens, but\u00a0I expect it to show the same drill overlay\u00a0When clicking \u201c1.637\u201d the drill overlay should appear but it doesn\u2019t.\u00a0Is there something I\u2019m missing? I thought this would be very straightforward.Thanks!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/drilling-though-a-tile-in-a-dashboard-27931","creationDate":"2021-08-12T20:57:30+0000","relativeCreationDate":"9 hours ago"},"numberOfViews":3,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27930,"author":{"id":9152,"url":"\/members\/dylan-hornstein-9152","name":"dylan.hornstein","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0b0299c4a9a2f84cf3c41357f8a2d8d31db66980_9152.jpg","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We have a large base_table in our Snowflake database that contains row-by-row transactions\u00a0from all of our subscribers.I\u2019m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally,\u00a0I would stage the data for that subscriber one time, and then have various tiles\/queries utilize the staged data to\u00a0avoid\u00a0querying the large base_table over and over with each tile.\u00a0Here is a simple SQL example.CREATE TABLE stage_data AS( SELECT subscriber_id, country, transaction_id, ... FROM base_table WHERE subscriber_id = &lt;subscriber_id&gt; AND date &gt;= &lt;start_date&gt; AND date &lt; &lt;end_date&gt; );--query1SELECT &lt;query1 cols&gt; FROM stage_data;--query2SELECT &lt;query2 cols&gt; FROM stage_data;...--query10SELECT &lt;query10 cols&gt; FROM stage_data;Or, in LookML...view: aggregate_1 { sql_table_name: stage_data.SQL_TABLE_NAME dimension: country {} measure: txn_cnt {type: count_distinct sql: ${tracking_id}} ...}view: aggregate_2 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_3 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_10 { sql_table_name: stage_data.SQL_TABLE_NAME ...}explore: stage_data {}view: stage_data { derived_table: { persist_for: \"10 minutes\" sql: SELECT subscriber_id, msg_day, tracking_id, country, ... FROM base_table WHERE {% condition stage_data.subscriber_id %} subscriber_id {% endcondition %} AND {% condition stage_data.msg_day_date %} msg_day {% endcondition %} ;; } dimension: subscriber_id {} dimension_group: msg_day {type: time} dimension: tracking_id {} dimension: country {} ...}The problem: The user needs to be able to select the subscriber_id and date range for the report, but\u00a0I cannot dynamically pass a liquid variable into the CREATE TABLE process. It seems that liquid variable reference simply isn\u2019t supported for PDTs.\u00a0We don\u2019t want to\u00a0stage data for every customer individually\u00a0because this report will\u00a0only be used for new customers in a POC. Staging data for every customer\u00a0is not necessary, and costly in terms of storage and query time.I\u2019ve tried many ways to get this to work, with no success. I\u2019ve tried both SQL-derived-tables and NDTs. NDTs produce a LookML error \u201cCannot persist NDTs with dynamic filters\u201d. SQL-derived-tables do not produce any LookML errors, but it leave\u00a0the liquid syntax in the query that gets\u00a0sent to Snowflake, which results in a syntax error\u00a0\u00a0Has anyone figured out how to stage data using dynamic filters???","url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","creationDate":"2021-08-12T19:59:33+0000","relativeCreationDate":"9 hours ago"},"isTopicUnread":true,"privateId":4085,"id":27930,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":5,"isIdeation":false,"url":"\/lookml-5","title":"LookML","description":"LookML design patterns, best practices, hacks, and knowledge sharing"},"url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","title":"Issue Staging Data Dynamically","lastPost":{"id":27930,"author":{"id":9152,"url":"\/members\/dylan-hornstein-9152","name":"dylan.hornstein","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0b0299c4a9a2f84cf3c41357f8a2d8d31db66980_9152.jpg","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We have a large base_table in our Snowflake database that contains row-by-row transactions\u00a0from all of our subscribers.I\u2019m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally,\u00a0I would stage the data for that subscriber one time, and then have various tiles\/queries utilize the staged data to\u00a0avoid\u00a0querying the large base_table over and over with each tile.\u00a0Here is a simple SQL example.CREATE TABLE stage_data AS( SELECT subscriber_id, country, transaction_id, ... FROM base_table WHERE subscriber_id = &lt;subscriber_id&gt; AND date &gt;= &lt;start_date&gt; AND date &lt; &lt;end_date&gt; );--query1SELECT &lt;query1 cols&gt; FROM stage_data;--query2SELECT &lt;query2 cols&gt; FROM stage_data;...--query10SELECT &lt;query10 cols&gt; FROM stage_data;Or, in LookML...view: aggregate_1 { sql_table_name: stage_data.SQL_TABLE_NAME dimension: country {} measure: txn_cnt {type: count_distinct sql: ${tracking_id}} ...}view: aggregate_2 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_3 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_10 { sql_table_name: stage_data.SQL_TABLE_NAME ...}explore: stage_data {}view: stage_data { derived_table: { persist_for: \"10 minutes\" sql: SELECT subscriber_id, msg_day, tracking_id, country, ... FROM base_table WHERE {% condition stage_data.subscriber_id %} subscriber_id {% endcondition %} AND {% condition stage_data.msg_day_date %} msg_day {% endcondition %} ;; } dimension: subscriber_id {} dimension_group: msg_day {type: time} dimension: tracking_id {} dimension: country {} ...}The problem: The user needs to be able to select the subscriber_id and date range for the report, but\u00a0I cannot dynamically pass a liquid variable into the CREATE TABLE process. It seems that liquid variable reference simply isn\u2019t supported for PDTs.\u00a0We don\u2019t want to\u00a0stage data for every customer individually\u00a0because this report will\u00a0only be used for new customers in a POC. Staging data for every customer\u00a0is not necessary, and costly in terms of storage and query time.I\u2019ve tried many ways to get this to work, with no success. I\u2019ve tried both SQL-derived-tables and NDTs. NDTs produce a LookML error \u201cCannot persist NDTs with dynamic filters\u201d. SQL-derived-tables do not produce any LookML errors, but it leave\u00a0the liquid syntax in the query that gets\u00a0sent to Snowflake, which results in a syntax error\u00a0\u00a0Has anyone figured out how to stage data using dynamic filters???","url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","creationDate":"2021-08-12T19:59:33+0000","relativeCreationDate":"9 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27930,"author":{"id":9152,"url":"\/members\/dylan-hornstein-9152","name":"dylan.hornstein","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0b0299c4a9a2f84cf3c41357f8a2d8d31db66980_9152.jpg","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We have a large base_table in our Snowflake database that contains row-by-row transactions\u00a0from all of our subscribers.I\u2019m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally,\u00a0I would stage the data for that subscriber one time, and then have various tiles\/queries utilize the staged data to\u00a0avoid\u00a0querying the large base_table over and over with each tile.\u00a0Here is a simple SQL example.CREATE TABLE stage_data AS( SELECT subscriber_id, country, transaction_id, ... FROM base_table WHERE subscriber_id = &lt;subscriber_id&gt; AND date &gt;= &lt;start_date&gt; AND date &lt; &lt;end_date&gt; );--query1SELECT &lt;query1 cols&gt; FROM stage_data;--query2SELECT &lt;query2 cols&gt; FROM stage_data;...--query10SELECT &lt;query10 cols&gt; FROM stage_data;Or, in LookML...view: aggregate_1 { sql_table_name: stage_data.SQL_TABLE_NAME dimension: country {} measure: txn_cnt {type: count_distinct sql: ${tracking_id}} ...}view: aggregate_2 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_3 { sql_table_name: stage_data.SQL_TABLE_NAME ...}view: aggregate_10 { sql_table_name: stage_data.SQL_TABLE_NAME ...}explore: stage_data {}view: stage_data { derived_table: { persist_for: \"10 minutes\" sql: SELECT subscriber_id, msg_day, tracking_id, country, ... FROM base_table WHERE {% condition stage_data.subscriber_id %} subscriber_id {% endcondition %} AND {% condition stage_data.msg_day_date %} msg_day {% endcondition %} ;; } dimension: subscriber_id {} dimension_group: msg_day {type: time} dimension: tracking_id {} dimension: country {} ...}The problem: The user needs to be able to select the subscriber_id and date range for the report, but\u00a0I cannot dynamically pass a liquid variable into the CREATE TABLE process. It seems that liquid variable reference simply isn\u2019t supported for PDTs.\u00a0We don\u2019t want to\u00a0stage data for every customer individually\u00a0because this report will\u00a0only be used for new customers in a POC. Staging data for every customer\u00a0is not necessary, and costly in terms of storage and query time.I\u2019ve tried many ways to get this to work, with no success. I\u2019ve tried both SQL-derived-tables and NDTs. NDTs produce a LookML error \u201cCannot persist NDTs with dynamic filters\u201d. SQL-derived-tables do not produce any LookML errors, but it leave\u00a0the liquid syntax in the query that gets\u00a0sent to Snowflake, which results in a syntax error\u00a0\u00a0Has anyone figured out how to stage data using dynamic filters???","url":"https:\/\/community.looker.com\/lookml-5\/issue-staging-data-dynamically-27930","creationDate":"2021-08-12T19:59:33+0000","relativeCreationDate":"9 hours ago"},"numberOfViews":5,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27893,"author":{"id":15400,"url":"\/members\/avikdebnath21-15400","name":"avikdebnath21","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/39342066-70ae-448d-b626-d55758d438a6.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have registered myself for the \u201cGetting Started with LookML\u201d course on Looker training. After filling up the form for learn.looker sandbox access, I still haven\u2019t received access (invite) to the Sandbox.\u00a0\u00a0Usually how long does it take for a new user to get the sandbox access ?","url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893","creationDate":"2021-08-06T13:59:26+0000","relativeCreationDate":"6 days ago"},"isTopicUnread":true,"privateId":4055,"id":27893,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1006,"isIdeation":false,"url":"\/getting-started-1006","title":"Getting started","description":"Getting Started in the Looker Community"},"url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893","title":"Did not get access to Sandbox","lastPost":{"id":12427,"author":{"id":6469,"url":"\/members\/olga-6469","name":"olga","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/353795222d43f7b787ba5e70c1de1d858395694c_6469.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893?postid=50751#post50751","creationDate":"2021-08-12T18:16:28+0000","relativeCreationDate":"11 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27893,"author":{"id":15400,"url":"\/members\/avikdebnath21-15400","name":"avikdebnath21","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/39342066-70ae-448d-b626-d55758d438a6.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have registered myself for the \u201cGetting Started with LookML\u201d course on Looker training. After filling up the form for learn.looker sandbox access, I still haven\u2019t received access (invite) to the Sandbox.\u00a0\u00a0Usually how long does it take for a new user to get the sandbox access ?","url":"https:\/\/community.looker.com\/getting-started-1006\/did-not-get-access-to-sandbox-27893","creationDate":"2021-08-06T13:59:26+0000","relativeCreationDate":"6 days ago"},"numberOfViews":13,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/welcome-1000","categoryId":1000,"title":"Welcome","metaRobots":"index, follow","type":0},"lastPostId":"12427"},{"firstPost":{"id":27916,"author":{"id":15648,"url":"\/members\/nttdata-15648","name":"NTTData","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/04f5d993-c1e3-468c-b6ea-bbffd0e0babd.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m Newbie at Looker. I\u2019m trying to understand the capabilities of this tool and compare with other BI tools. I\u2019m working with Power BI and SAP Analytics Cloud in the last few years. I have some questions, I will be glad if you answer what you know from the questions.\u00a0How does Looker work ? Import data method or Live connection method ?\tDoes Looker need any setup to connect databases ? Like gateway etc\u2026\tDoes Looker has ETL Layer to make transformations ?\tCan we create a report from excel file ?\u00a0\tCan I create my own connection. (For example Dremio or SAP Business Warehouse)\tCan we connect multiple data source and combine them ?\u00a0\tDoes Looker only developed from Web or can be worked on desktop with offline ? (For ex. Power BI can allow working offline on personal computer)\tDoes Looker have a Mobil integration ? (Can we reach reports from mobile)\tIs there any option to develop predictive models in Looker ?\tDoes Looker has IBCS certification ?\u00a0(International Business\u00a0Communication Standards )If anyone have experience at Power BI or SAP Analytics cloud and working with Looker, Could you please make some comments what Looker does better\/worse compare to other BI tools.","url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916","creationDate":"2021-08-11T08:56:10+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":4073,"id":27916,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1006,"isIdeation":false,"url":"\/getting-started-1006","title":"Getting started","description":"Getting Started in the Looker Community"},"url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916","title":"Looker Abilities","lastPost":{"id":12426,"author":{"id":6469,"url":"\/members\/olga-6469","name":"olga","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/353795222d43f7b787ba5e70c1de1d858395694c_6469.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916?postid=50750#post50750","creationDate":"2021-08-12T18:07:06+0000","relativeCreationDate":"11 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27916,"author":{"id":15648,"url":"\/members\/nttdata-15648","name":"NTTData","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/04f5d993-c1e3-468c-b6ea-bbffd0e0babd.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m Newbie at Looker. I\u2019m trying to understand the capabilities of this tool and compare with other BI tools. I\u2019m working with Power BI and SAP Analytics Cloud in the last few years. I have some questions, I will be glad if you answer what you know from the questions.\u00a0How does Looker work ? Import data method or Live connection method ?\tDoes Looker need any setup to connect databases ? Like gateway etc\u2026\tDoes Looker has ETL Layer to make transformations ?\tCan we create a report from excel file ?\u00a0\tCan I create my own connection. (For example Dremio or SAP Business Warehouse)\tCan we connect multiple data source and combine them ?\u00a0\tDoes Looker only developed from Web or can be worked on desktop with offline ? (For ex. Power BI can allow working offline on personal computer)\tDoes Looker have a Mobil integration ? (Can we reach reports from mobile)\tIs there any option to develop predictive models in Looker ?\tDoes Looker has IBCS certification ?\u00a0(International Business\u00a0Communication Standards )If anyone have experience at Power BI or SAP Analytics cloud and working with Looker, Could you please make some comments what Looker does better\/worse compare to other BI tools.","url":"https:\/\/community.looker.com\/getting-started-1006\/looker-abilities-27916","creationDate":"2021-08-11T08:56:10+0000","relativeCreationDate":"1 day ago"},"numberOfViews":22,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/welcome-1000","categoryId":1000,"title":"Welcome","metaRobots":"index, follow","type":0},"lastPostId":"12426"},{"firstPost":{"id":27929,"author":{"id":15497,"url":"\/members\/tkshimon-15497","name":"tkshimon","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have created a Looker extension in ReactJS application. Able to run React app locally and its working fine with the Looker (added localhost url in the Looker project manifest file). But since the extension running in my local machine it is not accessible to\u00a0 other developers\u00a0whos working on the same Looker instance.\u00a0How do I need to deploy the extension so that it should able to access all the developers who has access to that looker instance?\u00a0Does Looker provides any app server to run my extension app?","url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929","creationDate":"2021-08-12T17:59:12+0000","relativeCreationDate":"11 hours ago"},"isTopicUnread":true,"privateId":4084,"id":27929,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":75,"isIdeation":false,"url":"\/embedding-looker-powered-by-looker-75","title":"Embedding Looker \/ Powered by Looker","description":"Sharing data with a broader audience"},"url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929","title":"Looker ReactJS Extension Deployment","lastPost":{"id":12425,"author":{"id":2336,"url":"\/members\/iant-2336","name":"IanT","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0f3174688e96c69dee18423738cc386ce627985d_2336.png","userTitle":"Good Looker","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Good Looker"},"userLevel":6},"content":"","url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929?postid=50749#post50749","creationDate":"2021-08-12T18:01:44+0000","relativeCreationDate":"11 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27929,"author":{"id":15497,"url":"\/members\/tkshimon-15497","name":"tkshimon","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have created a Looker extension in ReactJS application. Able to run React app locally and its working fine with the Looker (added localhost url in the Looker project manifest file). But since the extension running in my local machine it is not accessible to\u00a0 other developers\u00a0whos working on the same Looker instance.\u00a0How do I need to deploy the extension so that it should able to access all the developers who has access to that looker instance?\u00a0Does Looker provides any app server to run my extension app?","url":"https:\/\/community.looker.com\/embedding-looker-powered-by-looker-75\/looker-reactjs-extension-deployment-27929","creationDate":"2021-08-12T17:59:12+0000","relativeCreationDate":"11 hours ago"},"numberOfViews":5,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/application-development-1003","categoryId":1003,"title":"Application development","metaRobots":"index, follow","type":0},"lastPostId":"12425"},{"firstPost":{"id":27926,"author":{"id":15715,"url":"\/members\/jchan-15715","name":"jchan","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/fc52630d-7136-4fa3-8280-dd039ee171b9.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"As a beginner in Looker,\u00a0 I\u2019m currently tasked with making the row limit as a global filter.My goal is that letting\u00a0users\u00a0to decide\u00a0how many rows they want to get on each tile (top 5, top 10 etc) by selecting any number in customized filter.I tried using `row()` function in table calculation to get the row number, but still cannot assign it as a global-view filter finally.Is there any workaround such as creating a measure to deal with this, or there is already a solution?Thanks for the time and help!\u00a0","url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926","creationDate":"2021-08-12T06:23:48+0000","relativeCreationDate":"23 hours ago"},"isTopicUnread":true,"privateId":4081,"id":27926,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":7,"isIdeation":false,"url":"\/dashboards-looks-7","title":"Dashboards & looks","description":"Building reports & visualizations in Looker"},"url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926","title":"Can row limit be set as a global filter?","lastPost":{"id":12424,"author":{"id":6469,"url":"\/members\/olga-6469","name":"olga","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/353795222d43f7b787ba5e70c1de1d858395694c_6469.jpg","userTitle":"Looker Staff","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"avatarIcon":"880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","avatarIconUrl":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/880deb88-fb80-49e5-a95a-52a4ec0bd350_thumb.png","name":"Looker Staff","color":"#5a2fc2"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926?postid=50747#post50747","creationDate":"2021-08-12T17:38:11+0000","relativeCreationDate":"12 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27926,"author":{"id":15715,"url":"\/members\/jchan-15715","name":"jchan","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/fc52630d-7136-4fa3-8280-dd039ee171b9.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"As a beginner in Looker,\u00a0 I\u2019m currently tasked with making the row limit as a global filter.My goal is that letting\u00a0users\u00a0to decide\u00a0how many rows they want to get on each tile (top 5, top 10 etc) by selecting any number in customized filter.I tried using `row()` function in table calculation to get the row number, but still cannot assign it as a global-view filter finally.Is there any workaround such as creating a measure to deal with this, or there is already a solution?Thanks for the time and help!\u00a0","url":"https:\/\/community.looker.com\/dashboards-looks-7\/can-row-limit-be-set-as-a-global-filter-27926","creationDate":"2021-08-12T06:23:48+0000","relativeCreationDate":"23 hours ago"},"numberOfViews":30,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12424"},{"firstPost":{"id":27928,"author":{"id":15747,"url":"\/members\/ericdjshepherd-15747","name":"ericdjshepherd","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m new to Looker but enjoying learning my way around.I would like to use this block -\u00a0https:\/\/looker.com\/platform\/blocks\/source\/cost-and-usage-analysis-by-snowflake\u00a0- but I\u2019m not able to figure out how to import it into my Looker environment.The \u201cNew LookML Project\u201d option does appear to allow pulling code in from a remote repository; however, it only works with repos that allow access using the \u2018git:\/\/\u2019 protocol and the one referenced above does not.Are there any other options to enable me to import this code?\u00a0 The link above is hosted by Looker so it seems logical that there should be some way to make use of it.Thanks,Eric","url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928","creationDate":"2021-08-12T15:23:10+0000","relativeCreationDate":"14 hours ago"},"isTopicUnread":true,"privateId":4083,"id":27928,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":1006,"isIdeation":false,"url":"\/getting-started-1006","title":"Getting started","description":"Getting Started in the Looker Community"},"url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928","title":"Snowflake Usage Block","lastPost":{"id":12423,"author":{"id":15747,"url":"\/members\/ericdjshepherd-15747","name":"ericdjshepherd","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928?postid=50745#post50745","creationDate":"2021-08-12T16:17:57+0000","relativeCreationDate":"13 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27928,"author":{"id":15747,"url":"\/members\/ericdjshepherd-15747","name":"ericdjshepherd","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,I\u2019m new to Looker but enjoying learning my way around.I would like to use this block -\u00a0https:\/\/looker.com\/platform\/blocks\/source\/cost-and-usage-analysis-by-snowflake\u00a0- but I\u2019m not able to figure out how to import it into my Looker environment.The \u201cNew LookML Project\u201d option does appear to allow pulling code in from a remote repository; however, it only works with repos that allow access using the \u2018git:\/\/\u2019 protocol and the one referenced above does not.Are there any other options to enable me to import this code?\u00a0 The link above is hosted by Looker so it seems logical that there should be some way to make use of it.Thanks,Eric","url":"https:\/\/community.looker.com\/getting-started-1006\/snowflake-usage-block-27928","creationDate":"2021-08-12T15:23:10+0000","relativeCreationDate":"14 hours ago"},"numberOfViews":4,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/welcome-1000","categoryId":1000,"title":"Welcome","metaRobots":"index, follow","type":0},"lastPostId":"12423"},{"firstPost":{"id":652,"author":{"id":185,"url":"\/members\/lucas-185","name":"Lucas","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"PDTs are great for Looker users, but our heavy data users\/early company employees\/founders are married to their own SQL queries where they can do all kinds of crazy ad-hoc reporting.\nSince PDTs are stored with a hashed names in our database, those users can\u2019t reference Looker\u2019s PDTs. The same people are worried that building out PDTs in Looker instead of our database makes us more dependent on Looker. Therefore, the executive team has mandated that we either\n\ndo not hash the PDT names anymore or\nmove all PDTs out of Looker and into our database.\n\nMaintaining PDTs in Looker is easier for me. Can anyone help me figure out how I can go with solution 1?\nThanks,\n\nLucas","url":"https:\/\/community.looker.com\/general-looker-administration-35\/pdts-in-looker-useless-outside-of-looker-652","creationDate":"2015-04-06T16:02:32+0000","relativeCreationDate":"6 years ago"},"isTopicUnread":true,"privateId":70,"id":652,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":35,"isIdeation":false,"url":"\/general-looker-administration-35","title":"General Looker administration","description":"All your administration & self-hosting questions and content"},"url":"https:\/\/community.looker.com\/general-looker-administration-35\/pdts-in-looker-useless-outside-of-looker-652","title":"PDTs in Looker - Useless outside of Looker?!","lastPost":{"id":12422,"author":{"id":15756,"url":"\/members\/atea-15756","name":"atea","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/c4348756-9e27-4a89-bf8e-3787d867ed0f.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/general-looker-administration-35\/pdts-in-looker-useless-outside-of-looker-652?postid=50744#post50744","creationDate":"2021-08-12T15:47:53+0000","relativeCreationDate":"14 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":35,"numberOfLikes":2,"relevantPost":{"id":652,"author":{"id":185,"url":"\/members\/lucas-185","name":"Lucas","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"PDTs are great for Looker users, but our heavy data users\/early company employees\/founders are married to their own SQL queries where they can do all kinds of crazy ad-hoc reporting.\nSince PDTs are stored with a hashed names in our database, those users can\u2019t reference Looker\u2019s PDTs. The same people are worried that building out PDTs in Looker instead of our database makes us more dependent on Looker. Therefore, the executive team has mandated that we either\n\ndo not hash the PDT names anymore or\nmove all PDTs out of Looker and into our database.\n\nMaintaining PDTs in Looker is easier for me. Can anyone help me figure out how I can go with solution 1?\nThanks,\n\nLucas","url":"https:\/\/community.looker.com\/general-looker-administration-35\/pdts-in-looker-useless-outside-of-looker-652","creationDate":"2015-04-06T16:02:32+0000","relativeCreationDate":"6 years ago"},"numberOfViews":703,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/administration-154","categoryId":154,"title":"Administration","metaRobots":"index, follow","type":0},"lastPostId":"12422"},{"firstPost":{"id":17014,"author":{"id":6376,"url":"\/members\/adstott90-6376","name":"adstott90","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"Hi all,\nI\u2019m working on a query at the moment and I want to compare the weekly revenue and customers with that of the previous year. Sounds straightforward, except that I want to compare weeks of the financial year (starts 01\/04\/2020) with last year. So essentially what I want the table to look like is something like this:\nWeek No. | FY 2020 Revenue | FY 2019 Revenue | Year on Year change |\n\n1\n\n2\n\n3\n\n4\n\netc.\nThe problem is I can\u2019t seem to work out how to generate the week number of the financial year consistently - anyone done this previously or have any tips on where to start?\nThanks, Adam","url":"https:\/\/community.looker.com\/explores-36\/fiscal-week-of-year-17014","creationDate":"2020-04-01T08:24:48+0000","relativeCreationDate":"1 year ago"},"isTopicUnread":true,"privateId":2408,"id":17014,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[{"id":"isQuestion","label":"vraag"}],"forum":{"id":36,"isIdeation":false,"url":"\/explores-36","title":"Explores","description":"Discovering Data in Looker"},"url":"https:\/\/community.looker.com\/explores-36\/fiscal-week-of-year-17014","title":"Fiscal Week of Year","lastPost":{"id":12421,"author":{"id":15751,"url":"\/members\/bkeyesslack-15751","name":"bkeyesSlack","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/4af369a8-6816-4f76-858d-b652af0e78ed.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/explores-36\/fiscal-week-of-year-17014?postid=50742#post50742","creationDate":"2021-08-12T15:32:55+0000","relativeCreationDate":"14 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":6,"numberOfLikes":0,"relevantPost":{"id":17014,"author":{"id":6376,"url":"\/members\/adstott90-6376","name":"adstott90","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"Hi all,\nI\u2019m working on a query at the moment and I want to compare the weekly revenue and customers with that of the previous year. Sounds straightforward, except that I want to compare weeks of the financial year (starts 01\/04\/2020) with last year. So essentially what I want the table to look like is something like this:\nWeek No. | FY 2020 Revenue | FY 2019 Revenue | Year on Year change |\n\n1\n\n2\n\n3\n\n4\n\netc.\nThe problem is I can\u2019t seem to work out how to generate the week number of the financial year consistently - anyone done this previously or have any tips on where to start?\nThanks, Adam","url":"https:\/\/community.looker.com\/explores-36\/fiscal-week-of-year-17014","creationDate":"2020-04-01T08:24:48+0000","relativeCreationDate":"1 year ago"},"numberOfViews":340,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12421"}]}"><div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021/common-questions-about-github-authentication-changes-made-on-august-13th-27933" class="qa-topic-title thread-list-block__title-link"> Common Questions About GitHub Authentication Changes Made on August 13th </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021/common-questions-about-github-authentication-changes-made-on-august-13th-27933"> What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you’ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this af... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/technical-tips-tricks-1021" class="thread-list-block__category-link"> Technical Tips & Tricks </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/drilling-though-a-tile-in-a-dashboard-27931" class="qa-topic-title thread-list-block__title-link"> Drilling though a tile in a dashboard </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/drilling-though-a-tile-in-a-dashboard-27931"> Hello Looker community!I’m in need of help, i’ve been struggling with this for a while and I’m sure some of you guys have done this before.What I want to accomplish is drilling through a visualization that is tiled into a dashboard. Let me explain:I created a Look, a single value viz, that shows how... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/dashboards-looks-7" class="thread-list-block__category-link"> Dashboards & looks </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/lookml-5/issue-staging-data-dynamically-27930" class="qa-topic-title thread-list-block__title-link"> Issue Staging Data Dynamically </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/lookml-5/issue-staging-data-dynamically-27930"> We have a large base_table in our Snowflake database that contains row-by-row transactions from all of our subscribers.I’m building a dashboard with 10 tiles that aggregates data from this base_table for a single subscriber. Ideally, I would stage the data for that subscriber one time, and then have... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/lookml-5" class="thread-list-block__category-link"> LookML </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/did-not-get-access-to-sandbox-27893" class="qa-topic-title thread-list-block__title-link"> Did not get access to Sandbox </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/did-not-get-access-to-sandbox-27893"> I have registered myself for the “Getting Started with LookML” course on Looker training. After filling up the form for learn.looker sandbox access, I still haven’t received access (invite) to the Sandbox. Usually how long does it take for a new user to get the sandbox access ? </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" class="thread-list-block__category-link"> Getting started </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/looker-abilities-27916" class="qa-topic-title thread-list-block__title-link"> Looker Abilities </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/looker-abilities-27916"> Hi All,I’m Newbie at Looker. I’m trying to understand the capabilities of this tool and compare with other BI tools. I’m working with Power BI and SAP Analytics Cloud in the last few years. I have some questions, I will be glad if you answer what you know from the questions. How does Looker work ? I... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" class="thread-list-block__category-link"> Getting started </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75/looker-reactjs-extension-deployment-27929" class="qa-topic-title thread-list-block__title-link"> Looker ReactJS Extension Deployment </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75/looker-reactjs-extension-deployment-27929"> I have created a Looker extension in ReactJS application. Able to run React app locally and its working fine with the Looker (added localhost url in the Looker project manifest file). But since the extension running in my local machine it is not accessible to other developers whos working on the sa... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/embedding-looker-powered-by-looker-75" class="thread-list-block__category-link"> Embedding Looker / Powered by Looker </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/can-row-limit-be-set-as-a-global-filter-27926" class="qa-topic-title thread-list-block__title-link"> Can row limit be set as a global filter? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/dashboards-looks-7/can-row-limit-be-set-as-a-global-filter-27926"> As a beginner in Looker, I’m currently tasked with making the row limit as a global filter.My goal is that letting users to decide how many rows they want to get on each tile (top 5, top 10 etc) by selecting any number in customized filter.I tried using `row()` function in table calculation to get... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/dashboards-looks-7" class="thread-list-block__category-link"> Dashboards & looks </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/snowflake-usage-block-27928" class="qa-topic-title thread-list-block__title-link"> Snowflake Usage Block </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/snowflake-usage-block-27928"> Hi All,I’m new to Looker but enjoying learning my way around.I would like to use this block - https://looker.com/platform/blocks/source/cost-and-usage-analysis-by-snowflake - but I’m not able to figure out how to import it into my Looker environment.The “New LookML Project” option does appear to all... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/getting-started-1006" class="thread-list-block__category-link"> Getting started </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/general-looker-administration-35/pdts-in-looker-useless-outside-of-looker-652" class="qa-topic-title thread-list-block__title-link"> PDTs in Looker - Useless outside of Looker?! </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/general-looker-administration-35/pdts-in-looker-useless-outside-of-looker-652"> PDTs are great for Looker users, but our heavy data users/early company employees/founders are married to their own SQL queries where they can do all kinds of crazy ad-hoc reporting. Since PDTs are stored with a hashed names in our database, those users can’t reference Looker’s PDTs. The same people... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/general-looker-administration-35" class="thread-list-block__category-link"> General Looker administration </a></span></span></div><div class="box__pad qa-topic-block thread-list-item forum-list-view-spacing"><h4 class="thread-list-block__title"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/explores-36/fiscal-week-of-year-17014" class="qa-topic-title thread-list-block__title-link"> Fiscal Week of Year </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210813055819/https://community.looker.com/explores-36/fiscal-week-of-year-17014"> Hi all, I’m working on a query at the moment and I want to compare the weekly revenue and customers with that of the previous year. Sounds straightforward, except that I want to compare weeks of the financial year (starts 01/04/2020) with last year. So essentially what I want the table to look like... </a></p><span class="thread-meta-item thread-meta-item--parent-forum qa-topic-meta-in-subforum extra-category-level"><span class="thread-list-block__forum-link thread-meta-item__text"><a href="/web/20210813055819/https://community.looker.com/explores-36" class="thread-list-block__category-link"> Explores </a></span></span></div></div></div></div></div></div></nav></div></div></div></div></div></div></div><div class="col col--side Sidebar qa-div-sidebar custom-sidebar Sidebarmodule Sidebarmodule--no-margin widget-container--container-2-1-column_2"><div class="widget-container widget-container--event_calendar widget-container--container-2-1-column_2-index-0" data-idx="0"><div class="widget-placeholder"><div class="box widget widget--event-calendar sitewidth qa-widget-event_calendar"><div class="box__content box__pad"><div data-preact="widget-events-calendar/index" data-props="{"maxResults":3,"title":"Upcoming events"}"></div></div></div></div></div><div class="widget-container widget-container--tag_cloud widget-container--container-2-1-column_2-index-1" data-idx="1"><div class="widget-placeholder"><div data-preact="widget-popular-tags/WidgetPopularTags" data-props="{"title":"People are talking about...","count":8}"></div></div></div><div class="widget-container widget-container--leaderboard_points widget-container--container-2-1-column_2-index-2" data-idx="2"><div class="widget-placeholder"><div data-preact="widget-points-leaderboard/indexWidget" data-props="{"maxResults":10,"timeRange":["thisWeek"],"title":"Most active members","emptyMessage":"No activity yet! ","isPreviewEmptyMessage":false,"excludeUserRole":["roles.banned","roles.community-manager","roles.administrator","Looker Staff"],"showLink":true,"linkText":"Show full leaderboard","showLoggedInUserSection":null,"phrases":{"Forum":{"{n} point| {n} points":"{n} point| {n} points","leaderboard.logged.in.user":"You","leaderboard.header.ranking":"Ranking","leaderboard.header.points":"Points"}}}"></div></div></div><div class="widget-container widget-container--solved_topics widget-container--container-2-1-column_2-index-3" data-idx="3"><div class="widget-placeholder"><div class="box widget widget--solved-topics" data-preact="widget-solved-topics/SolvedTopics" data-props="{"query":{"sort":"answerDate","sortOrder":"DESC","minReplies":0,"maxResults":7,"prefixIds":["beantwoord"]},"translations":{"Forum":{"Reply":"Reply|Replies"}},"attachmentCdn":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/","title":"Recently solved"}"></div></div></div></div></div></div> </div> </div> <div class="Template-footer"> <div class="sitewidth box box--blend" data-component="scrollTopStickyButton"> <div class="templatefoot col"> <a href="https://web.archive.org/web/20210813055819/http://www.insided.com/powered-by-the-insided-platform?utm_medium=referral&utm_source=community.looker.com&utm_content=powered-by-widget" class="logo-insided" title="Visit inSided.com" target="_blank"> <span class="is-hidden">Powered by inSided</span> </a> </div> <span class="scroll-to-top-sticky-button js-scrollto widget--base-shadow is-hidden-S custom-scroll-to-top" title="Back to top"></span> </div> </div> <div class="homepage-widget-container widget-container homepage-widget-container--footer widget-container--footer homepage-widget-container--footer widget-container--footer homepage-widget-container--index-9 widget-container--index-9" data-idx="9"> <div class="widget-placeholder"> <footer class="footer"> <div style="text-align:center"> © 2020 Looker Data Sciences, Inc.<br><a href="https://web.archive.org/web/20210813055819/https://looker.com/privacy">Privacy</a> | <a href="https://web.archive.org/web/20210813055819/https://looker.com/terms">Terms</a> | <a href="https://web.archive.org/web/20210813055819/https://looker.com/trust-center/privacy/cookies">Cookies</a> | <a href="https://web.archive.org/web/20210813055819/https://community.looker.com/getting-started-1006/looker-community-guidelines-15386">Community Guidelines </a> </div> <div class="footer-inner"> <div class="footer-language-selector"> </div> </div> </footer> </div> </div> <div class="modals box is-hidden"> <div class="qa-register-modal" data-helper="modal" data-data="{"modal_id": "register", "mainClass": "modal--register"}" id="modal_register"> <label for=""> </label> <h2> Sign up </h2> <p> Already have an account? <a class="js-open-modal qa-register-have-account-link" data-modal="login">Login</a> </p> <div id="modal_login"> <h4>Social Login </h4> <div data-preact="social-buttons/google" data-props="{"href":"https:\/\/community.looker.com\/ssoproxy\/login?ssoType=google","phrase":"Sign In with Google"}"></div> <div class="seperator--text"><span>or</span></div> </div> <form name="register" method="post" action="/web/20210813055819/https://community.looker.com/member/register" class="form js-ajax-form--registration" novalidate="novalidate"> <div class="js-notification "> </div> <div class="form__row"> <div class="first"> <label data-required="1" class="label required" for="register_user_username"> Username * </label> </div> <div class="second"> <input type="text" id="register_user_username" name="register[user][username]" required="required"/> </div> </div> <div class="form__row"> <div class="first"> <label data-required="1" class="label required" for="register_user_email"> E-mail address * </label> </div> <div class="second"> <input type="email" id="register_user_email" name="register[user][email]" required="required"/> </div> </div> <div class="form__row"> <div class="first"> <label data-required="1" data-private="1" data-private-label="Private" data-private-description="Only you and moderators can see this information" class="label" for="register_customfield_7"> Company <div data-view="Tooltip" class="tooltip tooltip--day text--normal"> <span class="text--meta tooltip-trigger js-tooltip-trigger">(Private)</span> <div class="tooltip__content tooltip__content--profile js-tooltip-content"> Only you and moderators can see this information </div> </div> * </label> </div> <div class="second"> <input type="text" id="register_customfield_7" name="register[customfield][7]" data-minchar="" data-maxchar="1000" placeholder="" data-labels="{"single":"{n} character left","plural":"{n} characters left"}"/> </div> </div> <div class="form__row"> <div class="first"> <label data-required="1" class="label required" for="register_user_password"> Password * </label> </div> <div class="second"> <input type="password" id="register_user_password" name="register[user][password]" required="required"/> </div> </div> <div class="form__row"> <div class="first choices--stacked fancyselect"> <input type="checkbox" id="register_terms" name="register[terms]" required="required" value="1"/> <label for="register_terms" class="required"> I accept the <a href="/web/20210813055819/https://community.looker.com/site/terms" target="_blank" class="terms"> terms & conditions </a> </label> </div> </div> <div class="email_repeat"> <div class="form__row"> <div class="first"> <label class="label" for="register_email_repeat"> loginBox.register.email_repeat </label> </div> <div class="second"> <input type="text" id="register_email_repeat" name="register[email_repeat]"/> </div> </div> </div> <button type="submit" id="register_submit" name="register[submit]" class="btn btn--cta btn--full-width"> Register </button> <input type="hidden" id="register_is_invite" name="register[is_invite]"/> <input type="hidden" id="register__token" name="register[_token]" value="Lq7wiPIxSnxJra5QBPT7_hFG9_HH9qH2je3wysmWJLI"/> </form> <script type="application/javascript"> if (document.querySelector('.email_repeat')) { document.querySelector('.email_repeat').style.display = 'none' } //invite tricks if(document.querySelector('#register_is_invite') && document.querySelector('#register_is_invite').value) { let name = document.querySelector('#register_user_username'); if (name.value === '--removed--') { name.value = '' } let email = document.querySelector('#register_user_email') email.readOnly = 1 email.classList.add('register_user_email--disabled') } </script> </div> <div class="qa-login-modal" data-helper="modal" data-data="{"modal_id": "login", "mainClass": "modal--login"}" id="modal_login"> <label for=""> </label> <h2>Login to the community</h2> <p>No account yet? <a class="js-open-modal" data-modal="register">Create an account</a> </p> <h4>Social Login </h4> <div data-preact="social-buttons/google" data-props="{"href":"https:\/\/community.looker.com\/ssoproxy\/login?ssoType=google","phrase":"Sign In with Google"}"></div> <div class="seperator--text"><span>or</span></div> <form name="login" method="post" action="/web/20210813055819/https://community.looker.com/member/login" class="form js-ajax-form--login"> <div class="js-notification"> </div> <div class="form__row"> <div class="first"> <label class="label required" for="login_usernameOrEmail"> Username </label> </div> <div class="second"> <input type="text" id="login_usernameOrEmail" name="login[usernameOrEmail]" required="required"/> </div> </div> <div class="form__row"> <div class="first"> <label class="label required" for="login_password"> Password </label> </div> <div class="second"> <input type="password" id="login_password" name="login[password]" required="required"/> </div> </div> <div class="form__row"> <div class="first choices--stacked fancyselect"> <input type="checkbox" id="login_remember" name="login[remember]" value="1"/> <label for="login_remember"> Remember me </label> </div> </div> <button type="submit" id="login_submit" name="login[submit]" class="btn btn--cta btn--full-width"> Log in </button> <div class="box__pad box--note box--blend"> <a href="#" class="js-open-modal" data-modal="forgot" tabindex="-1">Forgot password?</a> </div> <input type="hidden" id="login__token" name="login[_token]" value="kBKZFY0Q-rTYopDF_1nGvoOX1ehHoS_4Rthrgt1OB0w"/> </form> </div> <div class="qa-forgot-modal" data-helper="modal" data-data="{"modal_id": "forgot", "mainClass": "modal--forgot"}" id="modal_forgot"> <p>Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.</p> <form name="forgotPassword" method="post" action="/web/20210813055819/https://community.looker.com/member/forgotPassword" class="form js-ajax-form--forgot" id="form--forgot__1893577172"> <div class="js-notification"> </div> <div class="form__row"> <div class="first"> <label class="label required" for="forgotPassword_username"> Username or e-mail </label> </div> <div class="second"> <input type="text" id="forgotPassword_username" name="forgotPassword[username]" required="required"/> </div> </div> <div class="form-row first"> <button type="submit" id="forgotPassword_submit" name="forgotPassword[submit]" class="btn btn--cta qa-submit-button"> Post </button> <a href="#" class="group__item end js-open-modal qa-forgot-password-overview-link" data-modal="login">Back to overview</a> </div> <input type="hidden" id="forgotPassword__token" name="forgotPassword[_token]" value="TLgUZJs0pyU4N3FSqc13jhqE5OvCBqfD37am0MyPFh8"/> </form> </div> <div class="attachments--modal" data-helper="modal" data-data="{"modal_id": "attachments-pending-modal"}"> <h2>Scanning file for viruses.</h2> <p>Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.</p> <a href="#" class="mfp-close btn--cta">OK</a> </div> <div class="attachments--modal" data-helper="modal" data-data="{"modal_id": "attachments-infected-modal"}"> <h2>This file cannot be downloaded</h2> <p>Sorry, our virus scanner detected that this file isn't safe to download.</p> <a href="#" class="mfp-close btn--cta">OK</a> </div> </div> <input id="csrftoken" type="hidden" value="83063d0e886904be953cfc0d10bdd0f847e2e890"/> <script crossorigin="anonymous" src="https://web.archive.org/web/20210813055819js_/https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/dist/js/preact-app.js" id="insided-preact-app" data-basepath="https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/dist/js/" data-environment="production" data-region="us-west-2" data-communityid="looker-en" data-modules="["badges","reputation","unreadPostCounter","metadataPostDetails","ideation","subforumSubscription","emoji","mentions","channelConfiguration","pageConfiguration","conversationalWidget","fileAttachments","privateMessage","TopicSocialShare","webmasterManagement","heroImageSearchbar","nonModeratorsCanUploadImagesAndVideos","knowledgeBase","zendeskFederatedSearch","zendeskTicketEscalation","event","eventEngagement","topicItemView","group","publicTagManagement","publicTagDestination","publicTagAutoSuggestion","integrationsApi","integrationsApps","userOverviewStatistics","rank","thirdPartyScripts","customCss","pointSystem","richTopicCards","analyticsV2","analyticsV2SelfService","privateGroup","moderationOverviewBetaDefault","productAreas","ActivityStreamsUnified","imageResizingAndAlignment","ssr","algoliaAnswers","productboardIntegration","freshdeskV2","skilljarFederatedSearch","knowledgeBaseOverview"]" data-csslink="https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/dist/css/forum.css" data-defaultcdn="" data-fb-app-id="" data-communityurl="https://community.looker.com" data-controlurl="https://looker-en.insided.com" data-eventlogger="https://t3t09eztsd.execute-api.us-west-2.amazonaws.com/v1/event" data-application="forum"></script> <script src="https://web.archive.org/web/20210813055819js_/https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/dist/js/app.js" id="insided-app" data-basepath="https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/dist/js/" nonce="" data-environment="production" data-region="us-west-2" data-communityid="looker-en" data-modules="["badges","reputation","unreadPostCounter","metadataPostDetails","ideation","subforumSubscription","emoji","mentions","channelConfiguration","pageConfiguration","conversationalWidget","fileAttachments","privateMessage","TopicSocialShare","webmasterManagement","heroImageSearchbar","nonModeratorsCanUploadImagesAndVideos","knowledgeBase","zendeskFederatedSearch","zendeskTicketEscalation","event","eventEngagement","topicItemView","group","publicTagManagement","publicTagDestination","publicTagAutoSuggestion","integrationsApi","integrationsApps","userOverviewStatistics","rank","thirdPartyScripts","customCss","pointSystem","richTopicCards","analyticsV2","analyticsV2SelfService","privateGroup","moderationOverviewBetaDefault","productAreas","ActivityStreamsUnified","imageResizingAndAlignment","ssr","algoliaAnswers","productboardIntegration","freshdeskV2","skilljarFederatedSearch","knowledgeBaseOverview"]" data-csslink="https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/dist/css/forum.css" data-defaultcdn="https://dowpznhhyvkm4.cloudfront.net/2021-08-12-15-05-08-a28edd26/control/assets" data-fb-app-id="" data-language="en"></script><script>app.init([{"model":"csrf","data":{"name":"yip_csrf_token","token":"83063d0e886904be953cfc0d10bdd0f847e2e890"}},{"el":"head","component":"google-analytics","data":{"tokens":[{"token":"UA-XXX","name":"insided","verification":""}],"privacyLevel":1,"nonce":""}},{"data":{"data":{"communityId":"looker-en","environment":"production","language":"en","device":"desktop","page":{"pageNumber":1,"name":"Home","path":"looker-en:Home:","section":"Home","site":"looker-en","title":null,"url":"\/","firstRender":false},"user":{"userid":null,"rank":null,"role":"roles.guest","mainRole":"roles.guest","name":"guest","loginSource":null,"registerSource":null,"company":{"name":null,"status":null}},"form":{"name":"","step":""},"content":{"category":{"id":null,"title":null,"type":null},"topic":{"id":null,"title":null,"type":null,"content_type":null,"source_id":null,"created":null,"replies":null,"is_sticky":null,"prefix":null,"tags":null},"post":{"id":null},"path":":"},"search":{"phrase":null,"count":null}},"map":null},"component":"tracker"},{"el":"#category-1000","view":"Collapsetable","data":{"id":1000}},{"el":"#category-1001","view":"Collapsetable","data":{"id":1001}},{"el":"#category-1002","view":"Collapsetable","data":{"id":1002}},{"el":"#category-1003","view":"Collapsetable","data":{"id":1003}},{"el":"#category-154","view":"Collapsetable","data":{"id":154}},{"el":"#category-158","view":"Collapsetable","data":{"id":158}},{"el":"#category-161","view":"Collapsetable","data":{"id":161}},{"el":"#category-1020","view":"Collapsetable","data":{"id":1020}},{"el":".js-ajax-form--registration","component":"ajax-form"},{"el":".js-ajax-form--login","component":"ajax-form"},{"el":"#form--forgot__1893577172","component":"ajax-form"},{"el":".js-open-modal","helper":"show-modal"},{"el":"body","helper":"collapse"},{"el":"body","helper":"ajax-link"},{"model":"global_translations","data":{"ajax-form":{"connection_error":"Unable to submit form. Please refresh the page and try again."},"modal":{"close":"Close","loading":"Loading","gallery_previous":"Previous","gallery_next":"Next","gallery_counter":"%curr% of %total%","image_error":"The image could not be loaded","content_error":"The content could not be loaded"}}},{"view":"MainNavigation","el":".js-main-navigation"}]);</script> </main> </body>

CINXE.COM

Looker Community | Looker Community