Looker Community | Looker Community

<!DOCTYPE html> <html lang="en"> <head><script type="text/javascript" src="https://web-static.archive.org/_static/js/bundle-playback.js?v=7YQSqjSh" charset="utf-8"></script> <script type="text/javascript" src="https://web-static.archive.org/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script>window.RufflePlayer=window.RufflePlayer||{};window.RufflePlayer.config={"autoplay":"on","unmuteOverlay":"hidden"};</script> <script type="text/javascript" src="https://web-static.archive.org/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("https://community.looker.com/","20210726121850","https://web.archive.org/","web","https://web-static.archive.org/_static/", "1627301930"); </script> <link rel="stylesheet" type="text/css" href="https://web-static.archive.org/_static/css/banner-styles.css?v=p7PEIJWi" /> <link rel="stylesheet" type="text/css" href="https://web-static.archive.org/_static/css/iconochive.css?v=3PDvdIFv" />  <script src="https://web.archive.org/web/20210726121850js_/https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <link href="https://web.archive.org/web/20210726121850cs_/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/20210726121850cs_/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/20210726121850/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/20210726121850/https://community.looker.com/groups/looker-adoption-community-1014') { window.location = "https://web.archive.org/web/20210726121850/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/20210726121850im_/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/20210726121850/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/20210726121850im_/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/20210726121850/https://community.looker.com/"/> <style id="css-variables">@font-face{ font-family:Roboto; src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.eot); src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.woff) format("woff"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bold/Roboto-Bold-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210726121850im_/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/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.eot); src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.woff) format("woff"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/bolditalic/Roboto-BoldItalic-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210726121850im_/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/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.eot); src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.woff) format("woff"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/italic/Roboto-Italic-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210726121850im_/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/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.eot); src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.woff) format("woff"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/light/Roboto-Light-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210726121850im_/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/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.eot); src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.woff) format("woff"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/medium/Roboto-Medium-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210726121850im_/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/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.eot); src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.woff) format("woff"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/mediumitalic/Roboto-MediumItalic-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210726121850im_/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/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.eot); src:url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.eot#iefix) format("embedded-opentype"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.woff) format("woff"),url(https://web.archive.org/web/20210726121850im_/https://d2cn40jarzxub5.cloudfront.net/_fonts/fonts/roboto/regular/Roboto-Regular-webfont.ttf) format("truetype"),url(https://web.archive.org/web/20210726121850im_/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/20210726121850cs_/https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/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/20210726121850if_/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/20210726121850/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/20210726121850cs_/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/20210726121850/https://looker.com/" class="nav-logo"> <img src="https://web.archive.org/web/20210726121850im_/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/20210726121850/https://looker.com/guide" class="custres-gtm-nav-link"> User Guide </a> </li> <li> <a href="https://web.archive.org/web/20210726121850/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> </li> <li> <a href="https://web.archive.org/web/20210726121850/https://help.looker.com/" class="custres-gtm-nav-link"> Help Center </a> </li> <li> <a href="https://web.archive.org/web/20210726121850/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </li> <li> <a href="https://web.archive.org/web/20210726121850/https://community.looker.com/" class="custres-gtm-nav-link active"> Community </a> </li> <li> <a href="https://web.archive.org/web/20210726121850/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </li> <li> <a href="https://web.archive.org/web/20210726121850/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/20210726121850/https://looker.com/guide" class="custres-gtm-nav-link"> User Guide </a> </p> <p> <a href="https://web.archive.org/web/20210726121850/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> </p> <p> <a href="https://web.archive.org/web/20210726121850/https://help.looker.com/" class="custres-gtm-nav-link"> Help Center </a> </p> <p> <a href="https://web.archive.org/web/20210726121850/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </p> <p> <a href="https://web.archive.org/web/20210726121850/https://community.looker.com/" class="custres-gtm-nav-link"> Community </a> </p> <p> <a href="https://web.archive.org/web/20210726121850/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </p> <p> <a href="https://web.archive.org/web/20210726121850/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":61,"replyCount":161},{"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":103,"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":376,"replyCount":27},{"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":10,"replyCount":0},{"id":1025,"url":"\/challenge-1025","title":"Challenge","description":"Challenges and activities for hands-on learning","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":8,"replyCount":9}],"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":1307,"replyCount":3745},{"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":252,"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":421,"replyCount":1274},{"id":7,"url":"\/dashboards-looks-7","title":"Dashboards & looks","description":"Building reports & visualizations in Looker","type":"default","thumbnailUrl":"","heroImageUrl":"","showDescriptionOnHomepage":true,"topicCount":1139,"replyCount":3324}],"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":99,"replyCount":267},{"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":140},{"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":281,"replyCount":1042}],"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":19,"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":372,"replyCount":1083}],"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":59,"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":1647,"replyCount":45},{"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":15,"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 overview","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/20210726121850/https://community.looker.com/" class="main-menu-link link--text">Forum overview</a></li><li class="main-menu-list__item"><a href="/web/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/https://community.looker.com/getting-started-1006" title="Getting started" topicscount="61" class="link--text main-menu-link main-menu-link--category"><span>Getting started</span><span class="text--meta">61</span></a><a href="/web/20210726121850/https://community.looker.com/news-announcements-1007" title="News & announcements" topicscount="103" class="link--text main-menu-link main-menu-link--category"><span>News & announcements</span><span class="text--meta">103</span></a><a href="/web/20210726121850/https://community.looker.com/who-s-hiring-66" title="Who's hiring" topicscount="376" class="link--text main-menu-link main-menu-link--category"><span>Who's hiring</span><span class="text--meta">376</span></a><a href="/web/20210726121850/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/20210726121850/https://community.looker.com/lesson-comments-1017" title="Lesson Comments" topicscount="10" class="link--text main-menu-link main-menu-link--category"><span>Lesson Comments</span><span class="text--meta">10</span></a><a href="/web/20210726121850/https://community.looker.com/challenge-1025" title="Challenge" topicscount="8" class="link--text main-menu-link main-menu-link--category"><span>Challenge</span><span class="text--meta">8</span></a></li><li><a href="/web/20210726121850/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/20210726121850/https://community.looker.com/lookml-5" title="LookML" topicscount="1307" class="link--text main-menu-link main-menu-link--category"><span>LookML</span><span class="text--meta">1307</span></a><a href="/web/20210726121850/https://community.looker.com/sql-10" title="SQL" topicscount="252" class="link--text main-menu-link main-menu-link--category"><span>SQL</span><span class="text--meta">252</span></a></li><li><a href="/web/20210726121850/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/20210726121850/https://community.looker.com/explores-36" title="Explores" topicscount="421" class="link--text main-menu-link main-menu-link--category"><span>Explores</span><span class="text--meta">421</span></a><a href="/web/20210726121850/https://community.looker.com/dashboards-looks-7" title="Dashboards & looks" topicscount="1139" class="link--text main-menu-link main-menu-link--category"><span>Dashboards & looks</span><span class="text--meta">1139</span></a></li><li><a href="/web/20210726121850/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/20210726121850/https://community.looker.com/embedding-looker-powered-by-looker-75" title="Embedding Looker / Powered by Looker" topicscount="99" class="link--text main-menu-link main-menu-link--category"><span>Embedding Looker / Powered by Looker</span><span class="text--meta">99</span></a><a href="/web/20210726121850/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/20210726121850/https://community.looker.com/looker-api-77" title="Looker API" topicscount="281" class="link--text main-menu-link main-menu-link--category"><span>Looker API</span><span class="text--meta">281</span></a></li><li><a href="/web/20210726121850/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/20210726121850/https://community.looker.com/user-access-management-1009" title="User access & management" topicscount="19" class="link--text main-menu-link main-menu-link--category"><span>User access & management</span><span class="text--meta">19</span></a><a href="/web/20210726121850/https://community.looker.com/general-looker-administration-35" title="General Looker administration" topicscount="372" class="link--text main-menu-link main-menu-link--category"><span>General Looker administration</span><span class="text--meta">372</span></a></li><li><a href="/web/20210726121850/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/20210726121850/https://community.looker.com/got-a-question-79" title="Got a question?" topicscount="59" class="link--text main-menu-link main-menu-link--category"><span>Got a question?</span><span class="text--meta">59</span></a><a href="/web/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/https://community.looker.com/technical-tips-tricks-1021" title="Technical Tips & Tricks" topicscount="1647" class="link--text main-menu-link main-menu-link--category"><span>Technical Tips & Tricks</span><span class="text--meta">1647</span></a><a href="/web/20210726121850/https://community.looker.com/common-account-questions-1024" title="Common Account Questions" topicscount="15" class="link--text main-menu-link main-menu-link--category"><span>Common Account Questions</span><span class="text--meta">15</span></a><a href="/web/20210726121850/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/20210726121850/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--hero_banner widget-container--hero_banner homepage-widget-container--hero_banner widget-container--hero_banner homepage-widget-container--index-3 widget-container--index-3" data-idx="3"> <div class="widget-placeholder"> <div class="brand-hero qa-brand-hero custom-hero-banner" style="background-image: url(https://web.archive.org/web/20210726121850im_/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/20210726121850/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-4 widget-container--index-4" data-idx="4"> <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>6,956</strong> <span>Topics</span> </li> <li class="list__item"> <strong>15,587</strong> <span>Replies</span> </li> <li class="list__item"> <strong>12,225</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-5 widget-container--index-5" data-idx="5"> <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/20210726121850/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/20210726121850oe_/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/20210726121850/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/20210726121850oe_/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/20210726121850/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/20210726121850oe_/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/20210726121850/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/20210726121850oe_/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/20210726121850/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/20210726121850oe_/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/20210726121850/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/20210726121850oe_/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-6 widget-container--index-6" data-idx="6"> <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":34,"type":"event"},{"id":30,"type":"event"},{"id":"35","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":116,"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":2,"hasCurrentUserLiked":false},{"id":34,"title":"Harver monetizes data by improving the customer experience","content":"<section class=\"callout callout-green\"><div><div><p><strong>Part 1 of our <a href=\"https:\/\/community.looker.com\/news-announcements-1007\/upcoming-3-part-webinar-series-on-data-monetization-27252\" target=\"_self\" rel=\"noreferrer\">Data Monetization Strategies webinar series<\/a>.<\/strong><\/p><\/div><\/div><\/section><p>\u00a0<\/p><h2>Monetizing data by improving the customer experience with Harver<\/h2><p>\u00a0<\/p><p>Harver has transformed the volume recruitment landscape through unprecedented automation, while empowering businesses with real-time intelligence to connect hiring data across the entire talent lifecycle. In this webinar you\u2019ll learn how Harver took a customer-first approach to analytics when building their product and how that focus has helped indirectly monetize their data.<\/p><p>\u00a0<\/p><p><strong>You\u2019ll walk away with first-hand insights on how to approach an external data product strategy and have the opportunity to ask your own questions.<\/strong><\/p><p>\u00a0<\/p><p><a href=\"https:\/\/discover.looker.com\/DataMonetizationWebinarSeries_Part1.html?utm_source=community&amp;utm_medium=community&amp;utm_campaign=7014W0000017pfg&amp;utm_term=noram&amp;utm_content=datamonetizationwebinar\" target=\"_blank\" rel=\"noreferrer noopener\">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\/harver-monetizes-data-by-improving-the-customer-experience-34","image":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/2aae3b6f-7c81-41d1-b797-51a434ed4bf2_thumb.png","location":"","startsAt":1626804000,"endsAt":1626806700,"contentType":"event","attendees":[{"id":14156,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/96c45377-884c-4ebc-ad4a-3fe3406617b5.png","name":"NazarKO","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}}],"attendeeCount":1,"isLoggedInUserAttendee":false},{"id":30,"title":"July Data Explorers Guild -- Early","content":"<section><section class=\"callout callout-blue\"><div><p>\u00a0<\/p><p>The Data Explorers Guild is a group of data enthusiasts that meet virtually each month to learn from one another, share experiences with Looker and data, and explore fun datasets in a collaborative environment. Join us for an hour of interactive data-driven fun &amp; education with your fellow data explorers. All are welcome!<\/p><\/div><\/section><\/section><p>\u00a0<\/p><p><strong>The July\u00a0meeting of the Data Explorers Guild will be on Wednesday, July 21st, 2021. This is the \u201cEarly\u201d meeting, happening at 4-5pm GMT. If you\u2019re in the US, you may want to attend the \u201cLate\u201d meeting, from 3-4pm PST.\u00a0<\/strong><\/p><p>\u00a0<\/p><p>Head to the\u00a0<a href=\"https:\/\/community.looker.com\/data-explorers-guild-1012\/welcome-to-the-data-explorers-guild-20578\">Data Explorers Guild<\/a>\u00a0group to join, get dataset access, and see more details!<\/p>","author":{"id":7636,"url":"\/members\/nicholas-alexander-7636","name":"Nicholas_Alexander","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/39b6b91f-3d5d-48d6-9aa9-999bd29484ea.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":0},"type":"Meetup","url":"https:\/\/community.looker.com\/events\/july-data-explorers-guild-early-30","image":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/5d7341e7-0781-402f-a315-aa986978ec87_thumb.png","location":"","startsAt":1626883200,"endsAt":1626886800,"contentType":"event","attendees":[{"id":8909,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/135c236aa1a3b88046e18dad82708bb9eb14f21b_8909.jpg","name":"Ruth_O","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":13900,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/09e3aefa-1d77-4cb6-b128-72e332f2d502.png","name":"yadderace","rank":{"name":"Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":13918,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/3a2fa3e3-a154-4b71-9cca-78a17e3dd7f1.png","name":"Alirezaebiii","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":13974,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/cff51ac8-7cca-4ad9-833f-b81dbbbc8e8c.png","name":"Monse","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":14156,"avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/96c45377-884c-4ebc-ad4a-3fe3406617b5.png","name":"NazarKO","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}}],"attendeeCount":10,"isLoggedInUserAttendee":false},{"id":35,"title":"Platform Developers Roundtable: Looker Extension Framework","content":"<p><span style=\"background-color:#ffffff;color:#000000;\">You are invited to join our next Looker Platform Developers event, dedicated to the Looker extension framework! This is the perfect opportunity to go deeper on building custom data experiences with Looker.\u00a0<\/span><\/p><p>\u00a0<\/p><p><strong><em>What the event will cover:\u00a0<\/em><\/strong><\/p><ul><li>\t<p><span style=\"background-color:#ffffff;color:#000000;\">Live coding with a Developer expert<\/span><\/p>\t<\/li>\t<li>\t<p><span style=\"background-color:#ffffff;color:#000000;\">Q&amp;A around the extension framework\u00a0<\/span><\/p>\t<\/li>\t<li>\t<p><span style=\"background-color:#ffffff;color:#000000;\">Diving into Looker\u2019s brand new Developers Portal\u00a0<\/span><\/p>\t<\/li>\t<li>\t<p><span style=\"background-color:#ffffff;color:#000000;\">100% free to join<\/span><\/p>\t<\/li><\/ul><p>\u00a0<\/p><p><u><strong><em>How to participate:\u00a0<\/em><\/strong><\/u><\/p><p><strong><em>STEP 1: <\/em><\/strong><a href=\"https:\/\/community.looker.com\/groups\/platform-developers-1023\"><u>Join the Platform Developers Group now<\/u><\/a><span style=\"background-color:#ffffff;color:#000000;\"> to dig for more content around extension frameworks and for access to other events and workshops that we host monthly. You can start adding your questions for the Q&amp;A <\/span><a href=\"https:\/\/community.looker.com\/platform-developers-1023\/july-28th-platform-developers-meetup-on-looker-extension-framework-26957\"><u>here<\/u><\/a><span style=\"background-color:#ffffff;color:#000000;\">!<\/span><br \/><br \/><strong><em>STEP 2: <\/em><\/strong><a href=\"https:\/\/discover.looker.com\/Q3Y21PlatformDevelopersGroupMeetup.html\"><strong>Register Here<\/strong><\/a><span style=\"background-color:#ffffff;color:#000000;\">\u00a0to attend our next Platform Developers virtual Meetup on Wednesday, July 28th.<\/span><span style=\"background-color:transparent;color:#000000;\">\u00a0<\/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":"Virtual Workshop","url":"https:\/\/community.looker.com\/events\/platform-developers-roundtable-looker-extension-framework-35","image":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/attachment\/ce01f463-c574-4e20-918d-37b1b3b76282_thumb.png","location":"","startsAt":1627489800,"endsAt":1627493400,"contentType":"event","attendees":[{"id":9824,"avatar":"","name":"bohonkus","rank":{"name":"Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}},{"id":10228,"avatar":"","name":"merwindmello","rank":{"name":"New Member","isBold":false,"isItalic":false,"isUnderline":false,"color":""}}],"attendeeCount":2,"isLoggedInUserAttendee":false}],"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/20210726121850/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/20210726121850oe_/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/20210726121850/https://community.looker.com/members/michael-7656" rel="noreferrer"><img class="lazy " data-src="https://web.archive.org/web/20210726121850/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">116</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/20210726121850/https://community.looker.com/events/harver-monetizes-data-by-improving-the-customer-experience-34" 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-pill__past 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/20210726121850im_/https://uploads-us-west-2.insided.com/looker-en/attachment/2aae3b6f-7c81-41d1-b797-51a434ed4bf2_thumb.png);"></div></div><div class="event-item-detail-container"><div class="event__date_past event-item__date">Tue, Jul 20, 6:00 PM</div><h3 class="event-item__title"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/events/harver-monetizes-data-by-improving-the-customer-experience-34" class="event-item__title qa-event-title card-widget-title">Harver monetizes data by improving the customer experience</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-image featured-topic "><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/events/july-data-explorers-guild-early-30" 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-pill__past event-item__type pill pill--uppercase pill--article qa-content-type-pill">Meetup</span><div class="event-item__image" style="background-image: url(https://web.archive.org/web/20210726121850im_/https://uploads-us-west-2.insided.com/looker-en/attachment/5d7341e7-0781-402f-a315-aa986978ec87_thumb.png);"></div></div><div class="event-item-detail-container"><div class="event__date_past event-item__date">Wed, Jul 21, 4:00 PM</div><h3 class="event-item__title"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/events/july-data-explorers-guild-early-30" class="event-item__title qa-event-title card-widget-title">July Data Explorers Guild -- Early</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-image featured-topic "><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/events/platform-developers-roundtable-looker-extension-framework-35" 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">Virtual Workshop</span><div class="event-item__image" style="background-image: url(https://web.archive.org/web/20210726121850im_/https://uploads-us-west-2.insided.com/looker-en/attachment/ce01f463-c574-4e20-918d-37b1b3b76282_thumb.png);"></div></div><div class="event-item-detail-container"><div class=" event-item__date">Wed, Jul 28, 4:30 PM</div><h3 class="event-item__title"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/events/platform-developers-roundtable-looker-extension-framework-35" class="event-item__title qa-event-title card-widget-title">Platform Developers Roundtable: Looker Extension Framework</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-7 widget-container--index-7" data-idx="7"> <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/20210726121850/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/20210726121850/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/20210726121850/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":8631,"author":{"id":4791,"url":"\/members\/hlburak-4791","name":"hlburak","avatar":"","userTitle":"","userLevel":0},"content":"The typically slow content validator is cripplingly slow during large-scale refactors. Is it possible to bulk update content references to models\/explores\/views through the API? If not, I\u2019m hoping this is at least possible to do by contacting Support? If not, our content validation is going to take hours.","url":"https:\/\/community.looker.com\/lookml-5\/bulk-content-validation-through-api-8631","creationDate":"2018-08-04T16:20:50+0000","relativeCreationDate":"2 years ago"},"isTopicUnread":true,"privateId":1261,"id":8631,"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\/bulk-content-validation-through-api-8631","title":"Bulk content validation through API","lastPost":{"id":12337,"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\/lookml-5\/bulk-content-validation-through-api-8631?postid=50481#post50481","creationDate":"2021-07-26T10:01:38+0000","relativeCreationDate":"2 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":6,"numberOfLikes":1,"relevantPost":{"id":8631,"author":{"id":4791,"url":"\/members\/hlburak-4791","name":"hlburak","avatar":"","userTitle":"","userLevel":0},"content":"The typically slow content validator is cripplingly slow during large-scale refactors. Is it possible to bulk update content references to models\/explores\/views through the API? If not, I\u2019m hoping this is at least possible to do by contacting Support? If not, our content validation is going to take hours.","url":"https:\/\/community.looker.com\/lookml-5\/bulk-content-validation-through-api-8631","creationDate":"2018-08-04T16:20:50+0000","relativeCreationDate":"2 years ago"},"numberOfViews":299,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"12337"},{"firstPost":{"id":27816,"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":"All you application developers out there, this is for you!\u00a0In case you haven\u2019t heard, we\u2019re hosting our an event on the Looker extension framework next Wednesday, July 28th!We\u2019re going to be answering questions, doing some live coding, and showing you an awesome new resources for application developers: the\u00a0Looker Developer Portal.\u00a0Sign up for the event here!","url":"https:\/\/community.looker.com\/platform-developers-1023\/extension-framework-event-next-week-27816","creationDate":"2021-07-23T18:09:52+0000","relativeCreationDate":"2 days ago"},"isTopicUnread":true,"privateId":2614,"id":27816,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[],"forum":{"id":1023,"isIdeation":false,"url":"\/groups\/platform-developers-1023","title":"Platform Developers","description":"<p>This group is dedicated for those interested in building custom data experiences with Looker. This is the space to go deeper on topics like Looker extensions, APIs, and embedding.\u00a0<\/p><p>\u00a0<\/p><p>We host monthly meetups to come together and ask questions, work through challenges, and learn by doing.<\/p><p>\u00a0<\/p><p>Sign up for this group to join the conversation and be invited to workshops and events!\u00a0<\/p>"},"url":"https:\/\/community.looker.com\/platform-developers-1023\/extension-framework-event-next-week-27816","title":"Extension Framework event next week!","lastPost":{"id":5147,"author":{"id":11455,"url":"\/members\/jamie-friday-11455","name":"Jamie Friday","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/53ec6a21-a3a2-42dd-9530-32f83f57064d.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"","url":"https:\/\/community.looker.com\/platform-developers-1023\/extension-framework-event-next-week-27816?postid=50480#post50480","creationDate":"2021-07-26T08:22:23+0000","relativeCreationDate":"3 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":2,"relevantPost":{"id":27816,"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":"All you application developers out there, this is for you!\u00a0In case you haven\u2019t heard, we\u2019re hosting our an event on the Looker extension framework next Wednesday, July 28th!We\u2019re going to be answering questions, doing some live coding, and showing you an awesome new resources for application developers: the\u00a0Looker Developer Portal.\u00a0Sign up for the event here!","url":"https:\/\/community.looker.com\/platform-developers-1023\/extension-framework-event-next-week-27816","creationDate":"2021-07-23T18:09:52+0000","relativeCreationDate":"2 days ago"},"numberOfViews":27,"contentType":"conversation","featuredImage":"","publicLabel":"","category":{"url":"\/groups","categoryId":0,"title":"Groups","metaRobots":"index, follow","type":4},"lastPostId":"5147"},{"firstPost":{"id":27819,"author":{"id":14710,"url":"\/members\/hp1389-14710","name":"hp1389","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/0e4a04d2-388b-424a-ba6b-ee2e3ca45559.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes the main filters used in the look, and only considers the filters specified in the custom measure? if this is not possible, is there an alternate method to derive this data?","url":"https:\/\/community.looker.com\/lookml-5\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819","creationDate":"2021-07-24T23:50:08+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":4000,"id":27819,"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\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819","title":"Can we create a custom measure which excludes which excludes the main filters in a look?","lastPost":{"id":12336,"author":{"id":5902,"url":"\/members\/dawid-5902","name":"Dawid","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/e46b982b-8c60-497a-8a4c-90d5f0a392ab.png","userTitle":"Good Looker","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Good Looker"},"userLevel":6},"content":"","url":"https:\/\/community.looker.com\/lookml-5\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819?postid=50478#post50478","creationDate":"2021-07-26T06:13:26+0000","relativeCreationDate":"6 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27819,"author":{"id":14710,"url":"\/members\/hp1389-14710","name":"hp1389","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/0e4a04d2-388b-424a-ba6b-ee2e3ca45559.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes the main filters used in the look, and only considers the filters specified in the custom measure? if this is not possible, is there an alternate method to derive this data?","url":"https:\/\/community.looker.com\/lookml-5\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819","creationDate":"2021-07-24T23:50:08+0000","relativeCreationDate":"1 day ago"},"numberOfViews":7,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"12336"},{"firstPost":{"id":20961,"author":{"id":11053,"url":"\/members\/sc0tt-11053","name":"sc0tt","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1f0f0382-9060-435c-a7fe-d1fbed8d76b1.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":2},"content":"Hi,I\u2019m curious if we\u2019re the only ones that find Table-Next to be endlessly frustrating and constantly\u00a0revert back to Table Legacy? My whole team feels the same way and most dashboards still use legacy tables as a result.\u00a0I think the biggest gripe has to do with column sizing and column names. It always does something wacky and never works the way you\u2019d expect. If you spend the time resizing columns it usually reverts or changes shortly after. Table Legacy does a really nice job of fitting everything within the allotted width without awkwardly sized headers or rows. Even after a lot of config options it ends up weirdly displayed.\u00a0\u00a0I like a lot of the options in Table-Next like the ability to resize columns, move columns, add embedded bar charting, but the user experience feels a lot worse for our end-users and we never know how it will render on different monitors\/browsers.\u00a0Am I missing something?!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/anyone-still-frustrated-with-table-next-20961","creationDate":"2021-01-27T15:29:38+0000","relativeCreationDate":"5 months ago"},"isTopicUnread":true,"privateId":2391,"id":20961,"type":"post","hasCurrentUserLiked":false,"isSticky":false,"features":[],"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\/anyone-still-frustrated-with-table-next-20961","title":"Anyone still frustrated with Table-Next?","lastPost":{"id":5145,"author":{"id":9143,"url":"\/members\/daniel-demetri1-9143","name":"Daniel_Demetri1","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/f3a3c3ef6c672be5fac9a88d3a40dfdb07beb5b7_9143.jpg","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"","url":"https:\/\/community.looker.com\/dashboards-looks-7\/anyone-still-frustrated-with-table-next-20961?postid=50477#post50477","creationDate":"2021-07-25T21:34:33+0000","relativeCreationDate":"14 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":17,"numberOfLikes":7,"relevantPost":{"id":20961,"author":{"id":11053,"url":"\/members\/sc0tt-11053","name":"sc0tt","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1f0f0382-9060-435c-a7fe-d1fbed8d76b1.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":2},"content":"Hi,I\u2019m curious if we\u2019re the only ones that find Table-Next to be endlessly frustrating and constantly\u00a0revert back to Table Legacy? My whole team feels the same way and most dashboards still use legacy tables as a result.\u00a0I think the biggest gripe has to do with column sizing and column names. It always does something wacky and never works the way you\u2019d expect. If you spend the time resizing columns it usually reverts or changes shortly after. Table Legacy does a really nice job of fitting everything within the allotted width without awkwardly sized headers or rows. Even after a lot of config options it ends up weirdly displayed.\u00a0\u00a0I like a lot of the options in Table-Next like the ability to resize columns, move columns, add embedded bar charting, but the user experience feels a lot worse for our end-users and we never know how it will render on different monitors\/browsers.\u00a0Am I missing something?!","url":"https:\/\/community.looker.com\/dashboards-looks-7\/anyone-still-frustrated-with-table-next-20961","creationDate":"2021-01-27T15:29:38+0000","relativeCreationDate":"5 months ago"},"numberOfViews":679,"contentType":"conversation","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"5145"},{"firstPost":{"id":27820,"author":{"id":11184,"url":"\/members\/mori-11184","name":"mori","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1cda86b9-7b7a-4fe0-b6e5-1161a935b974.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"15 marketers and 1 LookML developer\u00a0use Looker at our digital ads agency in Japan. Each marketer gives\u00a0his\/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field\u00a0so far, but it\u2019s getting harder to deal with requests from marketers since they need a lot of custom measures &amp;\u00a0dimensions\u00a0promptly to meet clients\u2019 demand, so we think on 4\u00a0options.We hire another LookML developer\tMarketers gain LookML skills to add\u00a0measures &amp; dimensions\tWe outsource LookML development to a development center in Vietnam\tWe make apps which enable marketers add measures &amp; dimensions on the apps UII believe option No. 1\u00a0is the most straightforward approach. Shouldn\u2019t we adopt option No. 2 to maintain data governance? I now startup the development center in Vietnam, so I\u2019d like to consider option No. 3 &amp; 4 as well.Does anyone face a similar situation and have knowledge for a better project structure? Sharing your success\/failure story is also appreciated.Thank you!","url":"https:\/\/community.looker.com\/lookml-5\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","creationDate":"2021-07-25T09:28:13+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":4001,"id":27820,"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\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","title":"Seeking for the best LookML development system in our ads agency","lastPost":{"id":27820,"author":{"id":11184,"url":"\/members\/mori-11184","name":"mori","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1cda86b9-7b7a-4fe0-b6e5-1161a935b974.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"15 marketers and 1 LookML developer\u00a0use Looker at our digital ads agency in Japan. Each marketer gives\u00a0his\/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field\u00a0so far, but it\u2019s getting harder to deal with requests from marketers since they need a lot of custom measures &amp;\u00a0dimensions\u00a0promptly to meet clients\u2019 demand, so we think on 4\u00a0options.We hire another LookML developer\tMarketers gain LookML skills to add\u00a0measures &amp; dimensions\tWe outsource LookML development to a development center in Vietnam\tWe make apps which enable marketers add measures &amp; dimensions on the apps UII believe option No. 1\u00a0is the most straightforward approach. Shouldn\u2019t we adopt option No. 2 to maintain data governance? I now startup the development center in Vietnam, so I\u2019d like to consider option No. 3 &amp; 4 as well.Does anyone face a similar situation and have knowledge for a better project structure? Sharing your success\/failure story is also appreciated.Thank you!","url":"https:\/\/community.looker.com\/lookml-5\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","creationDate":"2021-07-25T09:28:13+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27820,"author":{"id":11184,"url":"\/members\/mori-11184","name":"mori","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1cda86b9-7b7a-4fe0-b6e5-1161a935b974.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"15 marketers and 1 LookML developer\u00a0use Looker at our digital ads agency in Japan. Each marketer gives\u00a0his\/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field\u00a0so far, but it\u2019s getting harder to deal with requests from marketers since they need a lot of custom measures &amp;\u00a0dimensions\u00a0promptly to meet clients\u2019 demand, so we think on 4\u00a0options.We hire another LookML developer\tMarketers gain LookML skills to add\u00a0measures &amp; dimensions\tWe outsource LookML development to a development center in Vietnam\tWe make apps which enable marketers add measures &amp; dimensions on the apps UII believe option No. 1\u00a0is the most straightforward approach. Shouldn\u2019t we adopt option No. 2 to maintain data governance? I now startup the development center in Vietnam, so I\u2019d like to consider option No. 3 &amp; 4 as well.Does anyone face a similar situation and have knowledge for a better project structure? Sharing your success\/failure story is also appreciated.Thank you!","url":"https:\/\/community.looker.com\/lookml-5\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","creationDate":"2021-07-25T09:28:13+0000","relativeCreationDate":"1 day ago"},"numberOfViews":20,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27811,"author":{"id":14307,"url":"\/members\/jack-p-14307","name":"Jack P","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Is it possible to enable navigation to another dashboard in an already embedded dashboard?We currently have a dashboard embedded in an iframe on our internal home page. We embed the iframe using an encypted url developed on the \/sso_url endpoint. Within that dashboard, one of our fields has an html link to another dashboard. Is it possilbe to leverage the sso in the current dashboard to navigate to the new link?","url":"https:\/\/community.looker.com\/dashboards-looks-7\/embedded-dashboard-navigation-27811","creationDate":"2021-07-22T21:55:39+0000","relativeCreationDate":"3 days ago"},"isTopicUnread":true,"privateId":3994,"id":27811,"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\/embedded-dashboard-navigation-27811","title":"Embedded Dashboard Navigation","lastPost":{"id":12335,"author":{"id":14307,"url":"\/members\/jack-p-14307","name":"Jack P","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/dashboards-looks-7\/embedded-dashboard-navigation-27811?postid=50473#post50473","creationDate":"2021-07-24T21:30:43+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":2,"numberOfLikes":0,"relevantPost":{"id":27811,"author":{"id":14307,"url":"\/members\/jack-p-14307","name":"Jack P","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Is it possible to enable navigation to another dashboard in an already embedded dashboard?We currently have a dashboard embedded in an iframe on our internal home page. We embed the iframe using an encypted url developed on the \/sso_url endpoint. Within that dashboard, one of our fields has an html link to another dashboard. Is it possilbe to leverage the sso in the current dashboard to navigate to the new link?","url":"https:\/\/community.looker.com\/dashboards-looks-7\/embedded-dashboard-navigation-27811","creationDate":"2021-07-22T21:55:39+0000","relativeCreationDate":"3 days ago"},"numberOfViews":13,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12335"},{"firstPost":{"id":14114,"author":{"id":4510,"url":"\/members\/alex-gray-4510","name":"Alex_Gray","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/64db5d1fe59de3ca13e4c4236199df83ee97d7d7_4510.jpg","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"According to this doc we need AWS Access Keys and Secret Keys:\n\n\n \n Looker Documentation\n \n \n \n\nSending Data to an Amazon S3 Bucket\n\nImmediately send data to an Amazon S3 bucket.\n\n\n \n \n \n \n \n \n\n\nAll of our infrastructure in AWS uses IAM Roles.\n\nWe don\u2019t have any Access Keys or Secret keys anywhere (for security purposes, mostly)\n\nIs there a way to use IAM Roles to send data to s3?","url":"https:\/\/community.looker.com\/general-looker-administration-35\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114","creationDate":"2019-09-23T15:04:18+0000","relativeCreationDate":"1 year ago"},"isTopicUnread":true,"privateId":1990,"id":14114,"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\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114","title":"Sending data to s3 required hard coded access keys. Why not IAM ROLES?","lastPost":{"id":12334,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/general-looker-administration-35\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114?postid=50472#post50472","creationDate":"2021-07-24T20:08:46+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":3,"numberOfLikes":0,"relevantPost":{"id":14114,"author":{"id":4510,"url":"\/members\/alex-gray-4510","name":"Alex_Gray","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/64db5d1fe59de3ca13e4c4236199df83ee97d7d7_4510.jpg","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"According to this doc we need AWS Access Keys and Secret Keys:\n\n\n \n Looker Documentation\n \n \n \n\nSending Data to an Amazon S3 Bucket\n\nImmediately send data to an Amazon S3 bucket.\n\n\n \n \n \n \n \n \n\n\nAll of our infrastructure in AWS uses IAM Roles.\n\nWe don\u2019t have any Access Keys or Secret keys anywhere (for security purposes, mostly)\n\nIs there a way to use IAM Roles to send data to s3?","url":"https:\/\/community.looker.com\/general-looker-administration-35\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114","creationDate":"2019-09-23T15:04:18+0000","relativeCreationDate":"1 year ago"},"numberOfViews":254,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/administration-154","categoryId":154,"title":"Administration","metaRobots":"index, follow","type":0},"lastPostId":"12334"},{"firstPost":{"id":27818,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We\u2019re a Looker SaaS customer in AWS.\u00a0 We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service\u2019s VPC in their respective AWS accounts in the same region.\u00a0 Has anyone been able to get Looker to ensure that all traffic to customer AWS resource remains on the AWS network and specifically does not traverse the public internet between the VPCs?The AWS solution for this is for VPC on the connection initiating end (Looker in both cases) to create one the available VPC endpoints in their AWS VPC and then use the route tables to ensure traffic is routed over the VPC endpoint instead of exiting their VPC via an Internet Gateway (IGW).\u00a0 However, I can find not documentation or other evidence of Looker supporting VPC endpoints at all.\u00a0Thanks!","url":"https:\/\/community.looker.com\/general-looker-administration-35\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","creationDate":"2021-07-24T19:57:09+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":3999,"id":27818,"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\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","title":"Keep Looker SaaS network traffic inside of AWS network?","lastPost":{"id":27818,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We\u2019re a Looker SaaS customer in AWS.\u00a0 We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service\u2019s VPC in their respective AWS accounts in the same region.\u00a0 Has anyone been able to get Looker to ensure that all traffic to customer AWS resource remains on the AWS network and specifically does not traverse the public internet between the VPCs?The AWS solution for this is for VPC on the connection initiating end (Looker in both cases) to create one the available VPC endpoints in their AWS VPC and then use the route tables to ensure traffic is routed over the VPC endpoint instead of exiting their VPC via an Internet Gateway (IGW).\u00a0 However, I can find not documentation or other evidence of Looker supporting VPC endpoints at all.\u00a0Thanks!","url":"https:\/\/community.looker.com\/general-looker-administration-35\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","creationDate":"2021-07-24T19:57:09+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27818,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We\u2019re a Looker SaaS customer in AWS.\u00a0 We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service\u2019s VPC in their respective AWS accounts in the same region.\u00a0 Has anyone been able to get Looker to ensure that all traffic to customer AWS resource remains on the AWS network and specifically does not traverse the public internet between the VPCs?The AWS solution for this is for VPC on the connection initiating end (Looker in both cases) to create one the available VPC endpoints in their AWS VPC and then use the route tables to ensure traffic is routed over the VPC endpoint instead of exiting their VPC via an Internet Gateway (IGW).\u00a0 However, I can find not documentation or other evidence of Looker supporting VPC endpoints at all.\u00a0Thanks!","url":"https:\/\/community.looker.com\/general-looker-administration-35\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","creationDate":"2021-07-24T19:57:09+0000","relativeCreationDate":"1 day ago"},"numberOfViews":2,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/administration-154","categoryId":154,"title":"Administration","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27817,"author":{"id":12382,"url":"\/members\/department-of-customer-love-12382","name":"Department of Customer Love","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/438403e8-239d-47ff-a8cf-086a719f5042.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":3},"content":"Overarching themes\/questions:\u00a0Here is a list of common questions our users often need support with, along with troubleshooting steps to try out:\u00a01. Why is my SQL query slow even when there are no queries queued on Looker?\tRun against database (or SQL Runner): check if that runs fast to see if it is a database problem or looker problem\t\t\tIf the query runs slow in both SQL Runner and database, that means that the query itself is slow and that it is not specifically a Looker issue, but instead a database issue or query complexity issue\t\t\t\t\tExplain in SQL can help to optimize the query\t\t\tCheck join logic, so we can make sure to avoid fanouts\t\t\tOpen up the generated SQL in SQL Runner to test your query\t2. I have a part of a query, and I see there\u2019s an error from this query. How can I find out which field is causing the error?\tStart by making the query less complex:\t\t\tRemove all filters and extra fields to isolate the field causing the error\u00a0\t\t\t\t\t\tIf the query is pivoted, unpivot the field and then take a look at the generated SQL\t\t\t\t\tOpen up the generated SQL in SQL Runner to test your query\/see a more detailed error message\t\t\tSearch the SQL database dialect docs for the functions we are using to ensure that we are using correct syntax\t\t\tCheck to see if the database name is included in the error surfaced on the explore.\t\t\tIf it is, we are looking at a SQL error and need to check our SQL\t\t\t\t\t\tIf it is not, we are looking at a LookML issue and need to check our LookML\t\t\t\t\tAre we able to run the query in the database without error?\t3. Why is Looker\u2019s generated SQL different from the one I usually write?\tSymmetric aggregates: They help to prevent miscalculating aggregates, but also add in a lot of complex looking code in the generated SQL\t\t\tValue format\t4. What does a particular SQL error mean? (function missing, data type mismatch, etc)\tIs there a data type mismatch between what we have written versus the data types that are required for the function, per the database dialect documentation?\t\t\tAre we using the correct function for the database dialect?\t\t\tGoogle the error: there are lots of online forums that can provide context\t\t\tOpen up the generated SQL in SQL Runner to test your query\t\u00a0Specific\/Common Errors:\u00a0So we just went over the overarching themes that we can run into when working with complex SQL. However, there are times when we might run into errors that are very specific to the query we are working with. Here are the top few errors we may run into, we use MySQL here as an example, the error messages from other SQL dialects can be very similar:Error 1:\u00a0SQL Syntax Error: The MySQL database encountered an error while running this query.(conn=95374054) Unknown column 'users.city' in 'field list'So what does this error mean?\u00a0The database is throwing an error stating that the column we\u2019re referencing in the `sql` parameter of a field isn\u2019t being found. Therefore, there are a few things we can check for here:Steps to troubleshoot:\tNarrow down the field(s) the error is coming from and identify the table in the database that the error is coming from\t\t\tRun a `SELECT\u00a0 * FROM [TABLE_NAME] LIMIT 5;` to view a list of columns in the table. Check if the column in question exists in your table.\tFrequent causes of this error:\tTypos: When manually typing table names into the `sql` parameter, we may make a typo\t\t\tData changed in the database: If column names change in a table in the database, that won\u2019t automatically update the Looker view file that\u2019s based on that table. We\u2019ll need to manually change that in the Looker view file or generate a new view file with \u201ccreate view from table\u201d\t\t\tResource for if your data is changing frequently: https:\/\/community.looker.com\/lookml-5\/automatically-refresh-of-view-definition-based-on-updated-data-source-table-11011\t\u00a0Error 2:SQL Syntax Error: (conn=95369153) FUNCTION demo_db.getdate does not existExplanation: This error is due to using the wrong function. As we can see in the SQL here - the `getdate()` function is not a recognized function in the MySQL database. The correct function to use in this case would be curdate()`sql: curdate() ;;`Because there are nuances in which SQL dialect is based on your database - it is a good idea to double check the functions and their properties when writing custom SQL!\u00a0\u00a0Error 3:SQL Error: \"X is not a valid group by expression\"Explanation: What does error mean? It is likely that the fields we are added to our query is not aggregating (measure) across a group (dimension)We would want to create a measure for the field that we are using:Rather than doing the sum function in the SQL of the dimension - we would want to create a type sum measure insteadError 4:invalidQuery: No matching signature for operator &gt;= for argument types: TIMESTAMP, DATE. Supported signature: ANY &gt;= ANY at [34:11]\tHere we want to make sure that the two date functions that we are comparing are the same DATATYPE (timestamp &gt;= timestamp or date &gt;= date or datetime &gt;= datetime)\u00a0\t\t\tOftentimes we can use the cast()\u00a0 to cast one of the fields to match the other fields data type\t\t\tIt is often helpful to take a look at the query to see which fields are type date or time field from which the error could be occurring and working up from there\t\t\tA similar error can happen when we write \u201ccase when .. then\u201d statement if the data type for all the \u201cthen\u201d statements are not consistent\u00a0\t\u00a0More common SQL errors troubleshooting tips:\u00a0How to avoid dividing by zeroDealing with Non-Unique Primary KeysError: Column &lt;name&gt; must appear in the GROUP BY clause or be used in an aggregate functionSQL Error: \"Syntax error at or near:\"SQL Error: relation \"schema.table\" does not exist\"SQL Error: \"X is not a valid group by expression\"No Matching Signature for operator &gt;= for argument types: TYPE, OTHER TYPE","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-sql-error-troubleshooting-tips-in-looker-27817","creationDate":"2021-07-23T19:38:41+0000","relativeCreationDate":"2 days ago"},"isTopicUnread":true,"privateId":2915,"id":27817,"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\/common-sql-error-troubleshooting-tips-in-looker-27817","title":"Common SQL error troubleshooting tips in Looker","lastPost":{"id":509,"author":{"id":10348,"url":"\/members\/ismail-a-10348","name":"Ismail_A","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/b67e6afd8879a1c5eb1bc288c2a3481087748295_10348.jpg","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-sql-error-troubleshooting-tips-in-looker-27817?postid=50468#post50468","creationDate":"2021-07-23T22:51:41+0000","relativeCreationDate":"2 days ago"},"numberOfUnreadReplies":0,"numberOfReplies":3,"numberOfLikes":5,"relevantPost":{"id":27817,"author":{"id":12382,"url":"\/members\/department-of-customer-love-12382","name":"Department of Customer Love","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/438403e8-239d-47ff-a8cf-086a719f5042.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":3},"content":"Overarching themes\/questions:\u00a0Here is a list of common questions our users often need support with, along with troubleshooting steps to try out:\u00a01. Why is my SQL query slow even when there are no queries queued on Looker?\tRun against database (or SQL Runner): check if that runs fast to see if it is a database problem or looker problem\t\t\tIf the query runs slow in both SQL Runner and database, that means that the query itself is slow and that it is not specifically a Looker issue, but instead a database issue or query complexity issue\t\t\t\t\tExplain in SQL can help to optimize the query\t\t\tCheck join logic, so we can make sure to avoid fanouts\t\t\tOpen up the generated SQL in SQL Runner to test your query\t2. I have a part of a query, and I see there\u2019s an error from this query. How can I find out which field is causing the error?\tStart by making the query less complex:\t\t\tRemove all filters and extra fields to isolate the field causing the error\u00a0\t\t\t\t\t\tIf the query is pivoted, unpivot the field and then take a look at the generated SQL\t\t\t\t\tOpen up the generated SQL in SQL Runner to test your query\/see a more detailed error message\t\t\tSearch the SQL database dialect docs for the functions we are using to ensure that we are using correct syntax\t\t\tCheck to see if the database name is included in the error surfaced on the explore.\t\t\tIf it is, we are looking at a SQL error and need to check our SQL\t\t\t\t\t\tIf it is not, we are looking at a LookML issue and need to check our LookML\t\t\t\t\tAre we able to run the query in the database without error?\t3. Why is Looker\u2019s generated SQL different from the one I usually write?\tSymmetric aggregates: They help to prevent miscalculating aggregates, but also add in a lot of complex looking code in the generated SQL\t\t\tValue format\t4. What does a particular SQL error mean? (function missing, data type mismatch, etc)\tIs there a data type mismatch between what we have written versus the data types that are required for the function, per the database dialect documentation?\t\t\tAre we using the correct function for the database dialect?\t\t\tGoogle the error: there are lots of online forums that can provide context\t\t\tOpen up the generated SQL in SQL Runner to test your query\t\u00a0Specific\/Common Errors:\u00a0So we just went over the overarching themes that we can run into when working with complex SQL. However, there are times when we might run into errors that are very specific to the query we are working with. Here are the top few errors we may run into, we use MySQL here as an example, the error messages from other SQL dialects can be very similar:Error 1:\u00a0SQL Syntax Error: The MySQL database encountered an error while running this query.(conn=95374054) Unknown column 'users.city' in 'field list'So what does this error mean?\u00a0The database is throwing an error stating that the column we\u2019re referencing in the `sql` parameter of a field isn\u2019t being found. Therefore, there are a few things we can check for here:Steps to troubleshoot:\tNarrow down the field(s) the error is coming from and identify the table in the database that the error is coming from\t\t\tRun a `SELECT\u00a0 * FROM [TABLE_NAME] LIMIT 5;` to view a list of columns in the table. Check if the column in question exists in your table.\tFrequent causes of this error:\tTypos: When manually typing table names into the `sql` parameter, we may make a typo\t\t\tData changed in the database: If column names change in a table in the database, that won\u2019t automatically update the Looker view file that\u2019s based on that table. We\u2019ll need to manually change that in the Looker view file or generate a new view file with \u201ccreate view from table\u201d\t\t\tResource for if your data is changing frequently: https:\/\/community.looker.com\/lookml-5\/automatically-refresh-of-view-definition-based-on-updated-data-source-table-11011\t\u00a0Error 2:SQL Syntax Error: (conn=95369153) FUNCTION demo_db.getdate does not existExplanation: This error is due to using the wrong function. As we can see in the SQL here - the `getdate()` function is not a recognized function in the MySQL database. The correct function to use in this case would be curdate()`sql: curdate() ;;`Because there are nuances in which SQL dialect is based on your database - it is a good idea to double check the functions and their properties when writing custom SQL!\u00a0\u00a0Error 3:SQL Error: \"X is not a valid group by expression\"Explanation: What does error mean? It is likely that the fields we are added to our query is not aggregating (measure) across a group (dimension)We would want to create a measure for the field that we are using:Rather than doing the sum function in the SQL of the dimension - we would want to create a type sum measure insteadError 4:invalidQuery: No matching signature for operator &gt;= for argument types: TIMESTAMP, DATE. Supported signature: ANY &gt;= ANY at [34:11]\tHere we want to make sure that the two date functions that we are comparing are the same DATATYPE (timestamp &gt;= timestamp or date &gt;= date or datetime &gt;= datetime)\u00a0\t\t\tOftentimes we can use the cast()\u00a0 to cast one of the fields to match the other fields data type\t\t\tIt is often helpful to take a look at the query to see which fields are type date or time field from which the error could be occurring and working up from there\t\t\tA similar error can happen when we write \u201ccase when .. then\u201d statement if the data type for all the \u201cthen\u201d statements are not consistent\u00a0\t\u00a0More common SQL errors troubleshooting tips:\u00a0How to avoid dividing by zeroDealing with Non-Unique Primary KeysError: Column &lt;name&gt; must appear in the GROUP BY clause or be used in an aggregate functionSQL Error: \"Syntax error at or near:\"SQL Error: relation \"schema.table\" does not exist\"SQL Error: \"X is not a valid group by expression\"No Matching Signature for operator &gt;= for argument types: TYPE, OTHER TYPE","url":"https:\/\/community.looker.com\/technical-tips-tricks-1021\/common-sql-error-troubleshooting-tips-in-looker-27817","creationDate":"2021-07-23T19:38:41+0000","relativeCreationDate":"2 days ago"},"numberOfViews":57,"contentType":"article","featuredImage":"","publicLabel":"","category":{"url":"\/the-kitchen-table-1020","categoryId":1020,"title":"The Kitchen Table","metaRobots":"index, follow","type":0},"lastPostId":"509"},{"firstPost":{"id":4220,"author":{"id":2000,"url":"\/members\/hans-t-2000","name":"hans-t","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"I have looks in a dashboard. I want to edit a look, so what I do is to view the original look, made changes and save it.\nEverything looks fine in the look page, until I refresh the dashboard page, and realise that the look does not reflect the changes I have made. So, I view the original look again, and the changes are not there at all.\nIt\u2019s annoying because this happens often but not always. Sometimes I have to redo the edits, like 3 times, before the changes persist.","url":"https:\/\/community.looker.com\/dashboards-looks-7\/look-edited-and-saved-but-does-not-persist-4220","creationDate":"2017-02-02T04:34:53+0000","relativeCreationDate":"4 years ago"},"isTopicUnread":true,"privateId":564,"id":4220,"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\/look-edited-and-saved-but-does-not-persist-4220","title":"Look edited and saved but does not persist","lastPost":{"id":12331,"author":{"id":14691,"url":"\/members\/alex-turney-14691","name":"Alex Turney","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/cb3d4974-50a1-426c-b377-46472f73e981.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/dashboards-looks-7\/look-edited-and-saved-but-does-not-persist-4220?postid=50466#post50466","creationDate":"2021-07-23T19:54:20+0000","relativeCreationDate":"2 days ago"},"numberOfUnreadReplies":0,"numberOfReplies":6,"numberOfLikes":0,"relevantPost":{"id":4220,"author":{"id":2000,"url":"\/members\/hans-t-2000","name":"hans-t","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"I have looks in a dashboard. I want to edit a look, so what I do is to view the original look, made changes and save it.\nEverything looks fine in the look page, until I refresh the dashboard page, and realise that the look does not reflect the changes I have made. So, I view the original look again, and the changes are not there at all.\nIt\u2019s annoying because this happens often but not always. Sometimes I have to redo the edits, like 3 times, before the changes persist.","url":"https:\/\/community.looker.com\/dashboards-looks-7\/look-edited-and-saved-but-does-not-persist-4220","creationDate":"2017-02-02T04:34:53+0000","relativeCreationDate":"4 years ago"},"numberOfViews":495,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12331"}]}"><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/20210726121850/https://community.looker.com/lookml-5/bulk-content-validation-through-api-8631" class="qa-topic-title thread-list-block__title-link"> Bulk content validation through API </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/lookml-5/bulk-content-validation-through-api-8631"> The typically slow content validator is cripplingly slow during large-scale refactors. Is it possible to bulk update content references to models/explores/views through the API? If not, I’m hoping this is at least possible to do by contacting Support? If not, our content validation is going to tak... </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/20210726121850/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--conversation pill pill--uppercase pill--conversation pill--align-top"> content_type.label.conversation </span><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/platform-developers-1023/extension-framework-event-next-week-27816" class="qa-topic-title thread-list-block__title-link"> Extension Framework event next week! </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/platform-developers-1023/extension-framework-event-next-week-27816"> All you application developers out there, this is for you! In case you haven’t heard, we’re hosting our an event on the Looker extension framework next Wednesday, July 28th!We’re going to be answering questions, doing some live coding, and showing you an awesome new resources for application develop... </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/20210726121850/https://community.looker.com/groups/platform-developers-1023" class="thread-list-block__category-link"> Platform Developers </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/20210726121850/https://community.looker.com/lookml-5/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819" class="qa-topic-title thread-list-block__title-link"> Can we create a custom measure which excludes which excludes the main filters in a look? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/lookml-5/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819"> A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes the main filters used in the look, and only considers the filters specified in the custom measure? if this is not possible, is there an alternate method to derive this data? </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/20210726121850/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--conversation pill pill--uppercase pill--conversation pill--align-top"> content_type.label.conversation </span><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/anyone-still-frustrated-with-table-next-20961" class="qa-topic-title thread-list-block__title-link"> Anyone still frustrated with Table-Next? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/anyone-still-frustrated-with-table-next-20961"> Hi,I’m curious if we’re the only ones that find Table-Next to be endlessly frustrating and constantly revert back to Table Legacy? My whole team feels the same way and most dashboards still use legacy tables as a result. I think the biggest gripe has to do with column sizing and column names. It alw... </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/20210726121850/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/20210726121850/https://community.looker.com/lookml-5/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820" class="qa-topic-title thread-list-block__title-link"> Seeking for the best LookML development system in our ads agency </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/lookml-5/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820"> 15 marketers and 1 LookML developer use Looker at our digital ads agency in Japan. Each marketer gives his/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field so far, but it’s 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/20210726121850/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/20210726121850/https://community.looker.com/dashboards-looks-7/embedded-dashboard-navigation-27811" class="qa-topic-title thread-list-block__title-link"> Embedded Dashboard Navigation </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/embedded-dashboard-navigation-27811"> Is it possible to enable navigation to another dashboard in an already embedded dashboard?We currently have a dashboard embedded in an iframe on our internal home page. We embed the iframe using an encypted url developed on the /sso_url endpoint. Within that dashboard, one of our fields has an html... </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/20210726121850/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/20210726121850/https://community.looker.com/general-looker-administration-35/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114" class="qa-topic-title thread-list-block__title-link"> Sending data to s3 required hard coded access keys. Why not IAM ROLES? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/general-looker-administration-35/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114"> According to this doc we need AWS Access Keys and Secret Keys: Looker Documentation Sending Data to an Amazon S3 Bucket Immediately send data to an Amazon S3 bucket. All of our infrastructure in AWS uses IAM Roles. We don’t have any Access Keys or S... </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/20210726121850/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/20210726121850/https://community.looker.com/general-looker-administration-35/keep-looker-saas-network-traffic-inside-of-aws-network-27818" class="qa-topic-title thread-list-block__title-link"> Keep Looker SaaS network traffic inside of AWS network? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/general-looker-administration-35/keep-looker-saas-network-traffic-inside-of-aws-network-27818"> We’re a Looker SaaS customer in AWS. We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service’s VPC in their respective AWS accounts in the same region. Has anyone been able to get Looker to ensure th... </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/20210726121850/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"><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/20210726121850/https://community.looker.com/technical-tips-tricks-1021/common-sql-error-troubleshooting-tips-in-looker-27817" class="qa-topic-title thread-list-block__title-link"> Common SQL error troubleshooting tips in Looker </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/technical-tips-tricks-1021/common-sql-error-troubleshooting-tips-in-looker-27817"> Overarching themes/questions: Here is a list of common questions our users often need support with, along with troubleshooting steps to try out: 1. Why is my SQL query slow even when there are no queries queued on Looker? Run against database (or SQL Runner): check if that runs fast to see if it is... </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/20210726121850/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/20210726121850/https://community.looker.com/dashboards-looks-7/look-edited-and-saved-but-does-not-persist-4220" class="qa-topic-title thread-list-block__title-link"> Look edited and saved but does not persist </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/look-edited-and-saved-but-does-not-persist-4220"> I have looks in a dashboard. I want to edit a look, so what I do is to view the original look, made changes and save it. Everything looks fine in the look page, until I refresh the dashboard page, and realise that the look does not reflect the changes I have made. So, I view the original look again,... </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/20210726121850/https://community.looker.com/dashboards-looks-7" class="thread-list-block__category-link"> Dashboards & looks </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/20210726121850/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/20210726121850/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">61 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">161 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/20210726121850/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">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">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/20210726121850/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">376 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">27 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/20210726121850/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/20210726121850/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">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">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/20210726121850/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">8 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">9 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/20210726121850/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/20210726121850/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">1307 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">3745 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/20210726121850/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">252 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/20210726121850/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/20210726121850/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">421 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">1274 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/20210726121850/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">1139 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">3324 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/20210726121850/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/20210726121850/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">99 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">267 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/20210726121850/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">140 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/20210726121850/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">281 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">1042 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/20210726121850/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/20210726121850/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">19 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/20210726121850/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">372 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">1083 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/20210726121850/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/20210726121850/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">59 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/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/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/20210726121850/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">1647 topics <span class="js-topic-new is-hidden qa-forum-overview-new-topics"> ({n} new) </span></li><li class="qa-forum-overview-post-counter">45 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/20210726121850/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">15 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/20210726121850/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/20210726121850/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":8631,"author":{"id":4791,"url":"\/members\/hlburak-4791","name":"hlburak","avatar":"","userTitle":"","userLevel":0},"content":"The typically slow content validator is cripplingly slow during large-scale refactors. Is it possible to bulk update content references to models\/explores\/views through the API? If not, I\u2019m hoping this is at least possible to do by contacting Support? If not, our content validation is going to take hours.","url":"https:\/\/community.looker.com\/lookml-5\/bulk-content-validation-through-api-8631","creationDate":"2018-08-04T16:20:50+0000","relativeCreationDate":"2 years ago"},"isTopicUnread":true,"privateId":1261,"id":8631,"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\/bulk-content-validation-through-api-8631","title":"Bulk content validation through API","lastPost":{"id":12337,"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\/lookml-5\/bulk-content-validation-through-api-8631?postid=50481#post50481","creationDate":"2021-07-26T10:01:38+0000","relativeCreationDate":"2 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":6,"numberOfLikes":1,"relevantPost":{"id":8631,"author":{"id":4791,"url":"\/members\/hlburak-4791","name":"hlburak","avatar":"","userTitle":"","userLevel":0},"content":"The typically slow content validator is cripplingly slow during large-scale refactors. Is it possible to bulk update content references to models\/explores\/views through the API? If not, I\u2019m hoping this is at least possible to do by contacting Support? If not, our content validation is going to take hours.","url":"https:\/\/community.looker.com\/lookml-5\/bulk-content-validation-through-api-8631","creationDate":"2018-08-04T16:20:50+0000","relativeCreationDate":"2 years ago"},"numberOfViews":299,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"12337"},{"firstPost":{"id":27819,"author":{"id":14710,"url":"\/members\/hp1389-14710","name":"hp1389","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/0e4a04d2-388b-424a-ba6b-ee2e3ca45559.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes the main filters used in the look, and only considers the filters specified in the custom measure? if this is not possible, is there an alternate method to derive this data?","url":"https:\/\/community.looker.com\/lookml-5\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819","creationDate":"2021-07-24T23:50:08+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":4000,"id":27819,"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\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819","title":"Can we create a custom measure which excludes which excludes the main filters in a look?","lastPost":{"id":12336,"author":{"id":5902,"url":"\/members\/dawid-5902","name":"Dawid","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/e46b982b-8c60-497a-8a4c-90d5f0a392ab.png","userTitle":"Good Looker","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Good Looker"},"userLevel":6},"content":"","url":"https:\/\/community.looker.com\/lookml-5\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819?postid=50478#post50478","creationDate":"2021-07-26T06:13:26+0000","relativeCreationDate":"6 hours ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27819,"author":{"id":14710,"url":"\/members\/hp1389-14710","name":"hp1389","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/0e4a04d2-388b-424a-ba6b-ee2e3ca45559.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes the main filters used in the look, and only considers the filters specified in the custom measure? if this is not possible, is there an alternate method to derive this data?","url":"https:\/\/community.looker.com\/lookml-5\/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819","creationDate":"2021-07-24T23:50:08+0000","relativeCreationDate":"1 day ago"},"numberOfViews":7,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"12336"},{"firstPost":{"id":27820,"author":{"id":11184,"url":"\/members\/mori-11184","name":"mori","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1cda86b9-7b7a-4fe0-b6e5-1161a935b974.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"15 marketers and 1 LookML developer\u00a0use Looker at our digital ads agency in Japan. Each marketer gives\u00a0his\/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field\u00a0so far, but it\u2019s getting harder to deal with requests from marketers since they need a lot of custom measures &amp;\u00a0dimensions\u00a0promptly to meet clients\u2019 demand, so we think on 4\u00a0options.We hire another LookML developer\tMarketers gain LookML skills to add\u00a0measures &amp; dimensions\tWe outsource LookML development to a development center in Vietnam\tWe make apps which enable marketers add measures &amp; dimensions on the apps UII believe option No. 1\u00a0is the most straightforward approach. Shouldn\u2019t we adopt option No. 2 to maintain data governance? I now startup the development center in Vietnam, so I\u2019d like to consider option No. 3 &amp; 4 as well.Does anyone face a similar situation and have knowledge for a better project structure? Sharing your success\/failure story is also appreciated.Thank you!","url":"https:\/\/community.looker.com\/lookml-5\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","creationDate":"2021-07-25T09:28:13+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":4001,"id":27820,"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\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","title":"Seeking for the best LookML development system in our ads agency","lastPost":{"id":27820,"author":{"id":11184,"url":"\/members\/mori-11184","name":"mori","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1cda86b9-7b7a-4fe0-b6e5-1161a935b974.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"15 marketers and 1 LookML developer\u00a0use Looker at our digital ads agency in Japan. Each marketer gives\u00a0his\/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field\u00a0so far, but it\u2019s getting harder to deal with requests from marketers since they need a lot of custom measures &amp;\u00a0dimensions\u00a0promptly to meet clients\u2019 demand, so we think on 4\u00a0options.We hire another LookML developer\tMarketers gain LookML skills to add\u00a0measures &amp; dimensions\tWe outsource LookML development to a development center in Vietnam\tWe make apps which enable marketers add measures &amp; dimensions on the apps UII believe option No. 1\u00a0is the most straightforward approach. Shouldn\u2019t we adopt option No. 2 to maintain data governance? I now startup the development center in Vietnam, so I\u2019d like to consider option No. 3 &amp; 4 as well.Does anyone face a similar situation and have knowledge for a better project structure? Sharing your success\/failure story is also appreciated.Thank you!","url":"https:\/\/community.looker.com\/lookml-5\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","creationDate":"2021-07-25T09:28:13+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27820,"author":{"id":11184,"url":"\/members\/mori-11184","name":"mori","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/1cda86b9-7b7a-4fe0-b6e5-1161a935b974.png","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"15 marketers and 1 LookML developer\u00a0use Looker at our digital ads agency in Japan. Each marketer gives\u00a0his\/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field\u00a0so far, but it\u2019s getting harder to deal with requests from marketers since they need a lot of custom measures &amp;\u00a0dimensions\u00a0promptly to meet clients\u2019 demand, so we think on 4\u00a0options.We hire another LookML developer\tMarketers gain LookML skills to add\u00a0measures &amp; dimensions\tWe outsource LookML development to a development center in Vietnam\tWe make apps which enable marketers add measures &amp; dimensions on the apps UII believe option No. 1\u00a0is the most straightforward approach. Shouldn\u2019t we adopt option No. 2 to maintain data governance? I now startup the development center in Vietnam, so I\u2019d like to consider option No. 3 &amp; 4 as well.Does anyone face a similar situation and have knowledge for a better project structure? Sharing your success\/failure story is also appreciated.Thank you!","url":"https:\/\/community.looker.com\/lookml-5\/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820","creationDate":"2021-07-25T09:28:13+0000","relativeCreationDate":"1 day ago"},"numberOfViews":20,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/looker-development-1001","categoryId":1001,"title":"Looker development","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":27811,"author":{"id":14307,"url":"\/members\/jack-p-14307","name":"Jack P","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Is it possible to enable navigation to another dashboard in an already embedded dashboard?We currently have a dashboard embedded in an iframe on our internal home page. We embed the iframe using an encypted url developed on the \/sso_url endpoint. Within that dashboard, one of our fields has an html link to another dashboard. Is it possilbe to leverage the sso in the current dashboard to navigate to the new link?","url":"https:\/\/community.looker.com\/dashboards-looks-7\/embedded-dashboard-navigation-27811","creationDate":"2021-07-22T21:55:39+0000","relativeCreationDate":"3 days ago"},"isTopicUnread":true,"privateId":3994,"id":27811,"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\/embedded-dashboard-navigation-27811","title":"Embedded Dashboard Navigation","lastPost":{"id":12335,"author":{"id":14307,"url":"\/members\/jack-p-14307","name":"Jack P","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/dashboards-looks-7\/embedded-dashboard-navigation-27811?postid=50473#post50473","creationDate":"2021-07-24T21:30:43+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":2,"numberOfLikes":0,"relevantPost":{"id":27811,"author":{"id":14307,"url":"\/members\/jack-p-14307","name":"Jack P","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Is it possible to enable navigation to another dashboard in an already embedded dashboard?We currently have a dashboard embedded in an iframe on our internal home page. We embed the iframe using an encypted url developed on the \/sso_url endpoint. Within that dashboard, one of our fields has an html link to another dashboard. Is it possilbe to leverage the sso in the current dashboard to navigate to the new link?","url":"https:\/\/community.looker.com\/dashboards-looks-7\/embedded-dashboard-navigation-27811","creationDate":"2021-07-22T21:55:39+0000","relativeCreationDate":"3 days ago"},"numberOfViews":13,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12335"},{"firstPost":{"id":14114,"author":{"id":4510,"url":"\/members\/alex-gray-4510","name":"Alex_Gray","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/64db5d1fe59de3ca13e4c4236199df83ee97d7d7_4510.jpg","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"According to this doc we need AWS Access Keys and Secret Keys:\n\n\n \n Looker Documentation\n \n \n \n\nSending Data to an Amazon S3 Bucket\n\nImmediately send data to an Amazon S3 bucket.\n\n\n \n \n \n \n \n \n\n\nAll of our infrastructure in AWS uses IAM Roles.\n\nWe don\u2019t have any Access Keys or Secret keys anywhere (for security purposes, mostly)\n\nIs there a way to use IAM Roles to send data to s3?","url":"https:\/\/community.looker.com\/general-looker-administration-35\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114","creationDate":"2019-09-23T15:04:18+0000","relativeCreationDate":"1 year ago"},"isTopicUnread":true,"privateId":1990,"id":14114,"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\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114","title":"Sending data to s3 required hard coded access keys. Why not IAM ROLES?","lastPost":{"id":12334,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/general-looker-administration-35\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114?postid=50472#post50472","creationDate":"2021-07-24T20:08:46+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":3,"numberOfLikes":0,"relevantPost":{"id":14114,"author":{"id":4510,"url":"\/members\/alex-gray-4510","name":"Alex_Gray","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/64db5d1fe59de3ca13e4c4236199df83ee97d7d7_4510.jpg","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":1},"content":"According to this doc we need AWS Access Keys and Secret Keys:\n\n\n \n Looker Documentation\n \n \n \n\nSending Data to an Amazon S3 Bucket\n\nImmediately send data to an Amazon S3 bucket.\n\n\n \n \n \n \n \n \n\n\nAll of our infrastructure in AWS uses IAM Roles.\n\nWe don\u2019t have any Access Keys or Secret keys anywhere (for security purposes, mostly)\n\nIs there a way to use IAM Roles to send data to s3?","url":"https:\/\/community.looker.com\/general-looker-administration-35\/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114","creationDate":"2019-09-23T15:04:18+0000","relativeCreationDate":"1 year ago"},"numberOfViews":254,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/administration-154","categoryId":154,"title":"Administration","metaRobots":"index, follow","type":0},"lastPostId":"12334"},{"firstPost":{"id":27818,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We\u2019re a Looker SaaS customer in AWS.\u00a0 We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service\u2019s VPC in their respective AWS accounts in the same region.\u00a0 Has anyone been able to get Looker to ensure that all traffic to customer AWS resource remains on the AWS network and specifically does not traverse the public internet between the VPCs?The AWS solution for this is for VPC on the connection initiating end (Looker in both cases) to create one the available VPC endpoints in their AWS VPC and then use the route tables to ensure traffic is routed over the VPC endpoint instead of exiting their VPC via an Internet Gateway (IGW).\u00a0 However, I can find not documentation or other evidence of Looker supporting VPC endpoints at all.\u00a0Thanks!","url":"https:\/\/community.looker.com\/general-looker-administration-35\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","creationDate":"2021-07-24T19:57:09+0000","relativeCreationDate":"1 day ago"},"isTopicUnread":true,"privateId":3999,"id":27818,"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\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","title":"Keep Looker SaaS network traffic inside of AWS network?","lastPost":{"id":27818,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We\u2019re a Looker SaaS customer in AWS.\u00a0 We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service\u2019s VPC in their respective AWS accounts in the same region.\u00a0 Has anyone been able to get Looker to ensure that all traffic to customer AWS resource remains on the AWS network and specifically does not traverse the public internet between the VPCs?The AWS solution for this is for VPC on the connection initiating end (Looker in both cases) to create one the available VPC endpoints in their AWS VPC and then use the route tables to ensure traffic is routed over the VPC endpoint instead of exiting their VPC via an Internet Gateway (IGW).\u00a0 However, I can find not documentation or other evidence of Looker supporting VPC endpoints at all.\u00a0Thanks!","url":"https:\/\/community.looker.com\/general-looker-administration-35\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","creationDate":"2021-07-24T19:57:09+0000","relativeCreationDate":"1 day ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27818,"author":{"id":7270,"url":"\/members\/klarson-7270","name":"klarson","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"We\u2019re a Looker SaaS customer in AWS.\u00a0 We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service\u2019s VPC in their respective AWS accounts in the same region.\u00a0 Has anyone been able to get Looker to ensure that all traffic to customer AWS resource remains on the AWS network and specifically does not traverse the public internet between the VPCs?The AWS solution for this is for VPC on the connection initiating end (Looker in both cases) to create one the available VPC endpoints in their AWS VPC and then use the route tables to ensure traffic is routed over the VPC endpoint instead of exiting their VPC via an Internet Gateway (IGW).\u00a0 However, I can find not documentation or other evidence of Looker supporting VPC endpoints at all.\u00a0Thanks!","url":"https:\/\/community.looker.com\/general-looker-administration-35\/keep-looker-saas-network-traffic-inside-of-aws-network-27818","creationDate":"2021-07-24T19:57:09+0000","relativeCreationDate":"1 day ago"},"numberOfViews":2,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/administration-154","categoryId":154,"title":"Administration","metaRobots":"index, follow","type":0},"lastPostId":"0"},{"firstPost":{"id":4220,"author":{"id":2000,"url":"\/members\/hans-t-2000","name":"hans-t","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"I have looks in a dashboard. I want to edit a look, so what I do is to view the original look, made changes and save it.\nEverything looks fine in the look page, until I refresh the dashboard page, and realise that the look does not reflect the changes I have made. So, I view the original look again, and the changes are not there at all.\nIt\u2019s annoying because this happens often but not always. Sometimes I have to redo the edits, like 3 times, before the changes persist.","url":"https:\/\/community.looker.com\/dashboards-looks-7\/look-edited-and-saved-but-does-not-persist-4220","creationDate":"2017-02-02T04:34:53+0000","relativeCreationDate":"4 years ago"},"isTopicUnread":true,"privateId":564,"id":4220,"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\/look-edited-and-saved-but-does-not-persist-4220","title":"Look edited and saved but does not persist","lastPost":{"id":12331,"author":{"id":14691,"url":"\/members\/alex-turney-14691","name":"Alex Turney","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/cb3d4974-50a1-426c-b377-46472f73e981.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/dashboards-looks-7\/look-edited-and-saved-but-does-not-persist-4220?postid=50466#post50466","creationDate":"2021-07-23T19:54:20+0000","relativeCreationDate":"2 days ago"},"numberOfUnreadReplies":0,"numberOfReplies":6,"numberOfLikes":0,"relevantPost":{"id":4220,"author":{"id":2000,"url":"\/members\/hans-t-2000","name":"hans-t","avatar":"","userTitle":"Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"Member"},"userLevel":0},"content":"I have looks in a dashboard. I want to edit a look, so what I do is to view the original look, made changes and save it.\nEverything looks fine in the look page, until I refresh the dashboard page, and realise that the look does not reflect the changes I have made. So, I view the original look again, and the changes are not there at all.\nIt\u2019s annoying because this happens often but not always. Sometimes I have to redo the edits, like 3 times, before the changes persist.","url":"https:\/\/community.looker.com\/dashboards-looks-7\/look-edited-and-saved-but-does-not-persist-4220","creationDate":"2017-02-02T04:34:53+0000","relativeCreationDate":"4 years ago"},"numberOfViews":495,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12331"},{"firstPost":{"id":27768,"author":{"id":14346,"url":"\/members\/svpaylink-14346","name":"svpaylink","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/486ef5a6-09a5-416f-9718-c86c606793a6.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have a Dimension that outputs YYYY-MM-DD HH:MM. Is there a table calc to extract the HH:MM? I can extract the hours separately and the minutes separately, but not as one.\u00a0","url":"https:\/\/community.looker.com\/explores-36\/extract-time-from-datetime-27768","creationDate":"2021-07-14T20:27:53+0000","relativeCreationDate":"11 days ago"},"isTopicUnread":true,"privateId":3963,"id":27768,"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\/extract-time-from-datetime-27768","title":"Extract Time from DateTime","lastPost":{"id":12330,"author":{"id":14672,"url":"\/members\/rafi-14672","name":"rafi","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/13d5603b-946c-442e-951f-d5024d7db2e3.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"","url":"https:\/\/community.looker.com\/explores-36\/extract-time-from-datetime-27768?postid=50460#post50460","creationDate":"2021-07-23T16:02:26+0000","relativeCreationDate":"2 days ago"},"numberOfUnreadReplies":0,"numberOfReplies":1,"numberOfLikes":0,"relevantPost":{"id":27768,"author":{"id":14346,"url":"\/members\/svpaylink-14346","name":"svpaylink","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/200x200\/486ef5a6-09a5-416f-9718-c86c606793a6.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"I have a Dimension that outputs YYYY-MM-DD HH:MM. Is there a table calc to extract the HH:MM? I can extract the hours separately and the minutes separately, but not as one.\u00a0","url":"https:\/\/community.looker.com\/explores-36\/extract-time-from-datetime-27768","creationDate":"2021-07-14T20:27:53+0000","relativeCreationDate":"11 days ago"},"numberOfViews":20,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"12330"},{"firstPost":{"id":27815,"author":{"id":13263,"url":"\/members\/sureshballem-13263","name":"SureshBallem","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,How to sorting filters \u00a0ASC\/DSC order in Dashboard level?Example : Date \/month \u2026\u2026...filters... Asc\/Dsc order\u00a0? how to do in Dashboard level?\u00a0\u00a0Regards,SureshBallem","url":"https:\/\/community.looker.com\/dashboards-looks-7\/how-to-sorting-filters-asc-dsc-order-in-dashboard-level-27815","creationDate":"2021-07-23T12:42:43+0000","relativeCreationDate":"2 days ago"},"isTopicUnread":true,"privateId":3998,"id":27815,"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\/how-to-sorting-filters-asc-dsc-order-in-dashboard-level-27815","title":"How to sorting filters ASC\/DSC order in Dashboard level?","lastPost":{"id":27815,"author":{"id":13263,"url":"\/members\/sureshballem-13263","name":"SureshBallem","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,How to sorting filters \u00a0ASC\/DSC order in Dashboard level?Example : Date \/month \u2026\u2026...filters... Asc\/Dsc order\u00a0? how to do in Dashboard level?\u00a0\u00a0Regards,SureshBallem","url":"https:\/\/community.looker.com\/dashboards-looks-7\/how-to-sorting-filters-asc-dsc-order-in-dashboard-level-27815","creationDate":"2021-07-23T12:42:43+0000","relativeCreationDate":"2 days ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27815,"author":{"id":13263,"url":"\/members\/sureshballem-13263","name":"SureshBallem","avatar":"","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi All,How to sorting filters \u00a0ASC\/DSC order in Dashboard level?Example : Date \/month \u2026\u2026...filters... Asc\/Dsc order\u00a0? how to do in Dashboard level?\u00a0\u00a0Regards,SureshBallem","url":"https:\/\/community.looker.com\/dashboards-looks-7\/how-to-sorting-filters-asc-dsc-order-in-dashboard-level-27815","creationDate":"2021-07-23T12:42:43+0000","relativeCreationDate":"2 days 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":27814,"author":{"id":7027,"url":"\/members\/eugen-bondarchik-7027","name":"Eugen_Bondarchik","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0cc23f0a4909716e8a2a876841bb09597ab0d7ba_7027.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi,could you please asist with definition of Action dimension in system__activity\/pdt_event_logWhat do they mean ?Thanks,Eugen.\u200b\u200b\u200b\u200b\u200b\u200b\u200b","url":"https:\/\/community.looker.com\/dashboards-looks-7\/incremental-pdt-even-log-action-27814","creationDate":"2021-07-23T09:26:07+0000","relativeCreationDate":"3 days ago"},"isTopicUnread":true,"privateId":3997,"id":27814,"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\/incremental-pdt-even-log-action-27814","title":"Incremental PDT Even Log Action","lastPost":{"id":27814,"author":{"id":7027,"url":"\/members\/eugen-bondarchik-7027","name":"Eugen_Bondarchik","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0cc23f0a4909716e8a2a876841bb09597ab0d7ba_7027.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi,could you please asist with definition of Action dimension in system__activity\/pdt_event_logWhat do they mean ?Thanks,Eugen.\u200b\u200b\u200b\u200b\u200b\u200b\u200b","url":"https:\/\/community.looker.com\/dashboards-looks-7\/incremental-pdt-even-log-action-27814","creationDate":"2021-07-23T09:26:07+0000","relativeCreationDate":"3 days ago"},"numberOfUnreadReplies":0,"numberOfReplies":0,"numberOfLikes":0,"relevantPost":{"id":27814,"author":{"id":7027,"url":"\/members\/eugen-bondarchik-7027","name":"Eugen_Bondarchik","avatar":"https:\/\/uploads-us-west-2.insided.com\/looker-en\/icon\/80x80\/0cc23f0a4909716e8a2a876841bb09597ab0d7ba_7027.png","userTitle":"New Member","rank":{"isBold":false,"isItalic":false,"isUnderline":false,"name":"New Member"},"userLevel":0},"content":"Hi,could you please asist with definition of Action dimension in system__activity\/pdt_event_logWhat do they mean ?Thanks,Eugen.\u200b\u200b\u200b\u200b\u200b\u200b\u200b","url":"https:\/\/community.looker.com\/dashboards-looks-7\/incremental-pdt-even-log-action-27814","creationDate":"2021-07-23T09:26:07+0000","relativeCreationDate":"3 days ago"},"numberOfViews":0,"contentType":"question","featuredImage":"","publicLabel":"","category":{"url":"\/exploring-curating-data-1002","categoryId":1002,"title":"Exploring & curating data","metaRobots":"index, follow","type":0},"lastPostId":"0"}]}"><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/20210726121850/https://community.looker.com/lookml-5/bulk-content-validation-through-api-8631" class="qa-topic-title thread-list-block__title-link"> Bulk content validation through API </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/lookml-5/bulk-content-validation-through-api-8631"> The typically slow content validator is cripplingly slow during large-scale refactors. Is it possible to bulk update content references to models/explores/views through the API? If not, I’m hoping this is at least possible to do by contacting Support? If not, our content validation is going to tak... </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/20210726121850/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/20210726121850/https://community.looker.com/lookml-5/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819" class="qa-topic-title thread-list-block__title-link"> Can we create a custom measure which excludes which excludes the main filters in a look? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/lookml-5/can-we-create-a-custom-measure-which-excludes-which-excludes-the-main-filters-in-a-look-27819"> A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes the main filters used in the look, and only considers the filters specified in the custom measure? if this is not possible, is there an alternate method to derive this data? </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/20210726121850/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/20210726121850/https://community.looker.com/lookml-5/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820" class="qa-topic-title thread-list-block__title-link"> Seeking for the best LookML development system in our ads agency </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/lookml-5/seeking-for-the-best-lookml-development-system-in-our-ads-agency-27820"> 15 marketers and 1 LookML developer use Looker at our digital ads agency in Japan. Each marketer gives his/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.The LookML developer has defined every field so far, but it’s 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/20210726121850/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/20210726121850/https://community.looker.com/dashboards-looks-7/embedded-dashboard-navigation-27811" class="qa-topic-title thread-list-block__title-link"> Embedded Dashboard Navigation </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/embedded-dashboard-navigation-27811"> Is it possible to enable navigation to another dashboard in an already embedded dashboard?We currently have a dashboard embedded in an iframe on our internal home page. We embed the iframe using an encypted url developed on the /sso_url endpoint. Within that dashboard, one of our fields has an html... </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/20210726121850/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/20210726121850/https://community.looker.com/general-looker-administration-35/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114" class="qa-topic-title thread-list-block__title-link"> Sending data to s3 required hard coded access keys. Why not IAM ROLES? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/general-looker-administration-35/sending-data-to-s3-required-hard-coded-access-keys-why-not-iam-roles-14114"> According to this doc we need AWS Access Keys and Secret Keys: Looker Documentation Sending Data to an Amazon S3 Bucket Immediately send data to an Amazon S3 bucket. All of our infrastructure in AWS uses IAM Roles. We don’t have any Access Keys or S... </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/20210726121850/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/20210726121850/https://community.looker.com/general-looker-administration-35/keep-looker-saas-network-traffic-inside-of-aws-network-27818" class="qa-topic-title thread-list-block__title-link"> Keep Looker SaaS network traffic inside of AWS network? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/general-looker-administration-35/keep-looker-saas-network-traffic-inside-of-aws-network-27818"> We’re a Looker SaaS customer in AWS. We have a need to keep all traffic secure between Looker running in their AWS VPC and AWS Redshift cluster in our VPC and our S3 buckets in the S3 service’s VPC in their respective AWS accounts in the same region. Has anyone been able to get Looker to ensure th... </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/20210726121850/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/20210726121850/https://community.looker.com/dashboards-looks-7/look-edited-and-saved-but-does-not-persist-4220" class="qa-topic-title thread-list-block__title-link"> Look edited and saved but does not persist </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/look-edited-and-saved-but-does-not-persist-4220"> I have looks in a dashboard. I want to edit a look, so what I do is to view the original look, made changes and save it. Everything looks fine in the look page, until I refresh the dashboard page, and realise that the look does not reflect the changes I have made. So, I view the original look again,... </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/20210726121850/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/20210726121850/https://community.looker.com/explores-36/extract-time-from-datetime-27768" class="qa-topic-title thread-list-block__title-link"> Extract Time from DateTime </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/explores-36/extract-time-from-datetime-27768"> I have a Dimension that outputs YYYY-MM-DD HH:MM. Is there a table calc to extract the HH:MM? I can extract the hours separately and the minutes separately, but not as one. </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/20210726121850/https://community.looker.com/explores-36" class="thread-list-block__category-link"> Explores </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/20210726121850/https://community.looker.com/dashboards-looks-7/how-to-sorting-filters-asc-dsc-order-in-dashboard-level-27815" class="qa-topic-title thread-list-block__title-link"> How to sorting filters ASC/DSC order in Dashboard level? </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/how-to-sorting-filters-asc-dsc-order-in-dashboard-level-27815"> Hi All,How to sorting filters ASC/DSC order in Dashboard level?Example : Date /month ……...filters... Asc/Dsc order ? how to do in Dashboard level? Regards,SureshBallem </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/20210726121850/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/20210726121850/https://community.looker.com/dashboards-looks-7/incremental-pdt-even-log-action-27814" class="qa-topic-title thread-list-block__title-link"> Incremental PDT Even Log Action </a></h4><p class="thread-list-block__content qa-topic-content"><a href="https://web.archive.org/web/20210726121850/https://community.looker.com/dashboards-looks-7/incremental-pdt-even-log-action-27814"> Hi,could you please asist with definition of Action dimension in system__activity/pdt_event_logWhat do they mean ?Thanks,Eugen. </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/20210726121850/https://community.looker.com/dashboards-looks-7" class="thread-list-block__category-link"> Dashboards & looks </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/20210726121850/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-8 widget-container--index-8" data-idx="8"> <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/20210726121850/https://looker.com/privacy">Privacy</a> | <a href="https://web.archive.org/web/20210726121850/https://looker.com/terms">Terms</a> | <a href="https://web.archive.org/web/20210726121850/https://looker.com/trust-center/privacy/cookies">Cookies</a> | <a href="https://web.archive.org/web/20210726121850/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/20210726121850/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/20210726121850/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="x5NwUSnwhRBHukNQRkJmHmBDNsL2H_hrXXL1M7BFOVA"/> </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/20210726121850/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="dRYeANPaLHamoDXc6NtekAhWJqz-X-CU_ktWDxO-tNc"/> </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/20210726121850/https://community.looker.com/member/forgotPassword" class="form js-ajax-form--forgot" id="form--forgot__2054097594"> <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="fA5L6Fi4Ak1jFjMEHMD4Uk3RftBcQj3NoxOYYRu47z0"/> </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="8dba525daa60cd6b722d24c0e08c546a6fad0191"/> <script crossorigin="anonymous" src="https://web.archive.org/web/20210726121850js_/https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/dist/js/preact-app.js" id="insided-preact-app" data-basepath="https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/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"]" data-csslink="https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/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/20210726121850js_/https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/dist/js/app.js" id="insided-app" data-basepath="https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/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"]" data-csslink="https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/dist/css/forum.css" data-defaultcdn="https://dowpznhhyvkm4.cloudfront.net/2021-07-23-51938369/control/assets" data-fb-app-id="" data-language="en"></script><script>app.init([{"model":"csrf","data":{"name":"yip_csrf_token","token":null}},{"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__2054097594","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