Rules, announcements, and important information
We are looking for a Looker Contractor to join Sendbird.WHAT YOU WILL DO Partner with teams and leadership (e.g., CEO, CFO, Sales, and Marketing Operations, Product Managers) to understand their needs in data-driven analytics and define and build key metrics, dashboards, and reports that allow them to execute their business goals more effectively Build, maintain and scale Looker as our BI tools and ensure effective use of Looker within every team at SendBird Performing ad hoc queries and data analysis requests on an as-needed basis. i.e. help with one-time data pulls, data cleansing, and QA in Looker Provide recommendations to stakeholders at all levels on Looker and data-driven best practices WHO YOU ARE (Aligned with 7 Core Values of Sendbird) Endless-tenacity-for-customers: A proven track record of collaboration with a variety of internal decision-makers to address their business needs and potential impacts while becoming a strong active listener with solid written and verba
Disclaimer: The chatbot is only accessible to users who are permitted to use chats; there’s no change in our chat access policy. Users will still be able to engage with a support analyst by clicking “Get in Touch” in the chat window. We are starting the launch from March 14th to March 24th as part of the 22.4 deployment, at which time it will be by default switched on for customer instances on 22.4 and above unless you request to switch it off by filing a support request. If you want to switch the chatbot off, please make sure the instance is on one of our supported releases. The chatbot can be toggled for the whole instance on request. We cannot selectively switch off the chatbot for a particular user. Q&A:How do I start a live chat support once the chatbot is enabled?When the chat widget pops up, you will be prompted to ask a question first, after posting the question, the “Get in touch” button will appear in 3-5 seconds. What’s the best w
I see that at the end of March, the LookML Developer certification exam is being retired, leaving the Looker community with no possible certification to achieve. Is there a reason for this exam (and the analyst one) being retired? Is there going to be a new exam to replace the LookML Developer? If so, when?
Hey Data Explorers! ️♀️ Not sure if you’ve noticed, but we’re kicking these awesome virtual meetups back off this month starting next week - Wednesday, April 7th! Make sure to RSVP to either the late or early session here. As for this months Data Viz Challenge, this is our monthly dataset that contains some film data for you to explore. Remember to try and spend a little time before the meetup checking out this dataset and post anything interesting in this thread! As usual, we’ll also be giving a bit of time during the event to explore this as well. Explore as you will, but here are some basic questions for you to consider during your digging: Which country and/or director makes the most cost effective movies? What are the most under-appreciated films? (prove it with the data) Which movie star is most likely to make a bad movie? Pick a director, are their movies getting better over their career? Admittedly this might not be the most epic dataset of all time, BUT I’m con
Hey Good Lookers, It’s been an absolutely delightful run serving as your community manager. Over the past few years, I’ve had the great privilege of meeting many of you in person, and even more of you virtually— I feel so lucky. I can’t think of a better way to keep abreast of the latest Looker functionality and news than to embed into the Community (the exact same benefit y’all get from being here). So it’s with somewhat heavy heart that I formally announce a changing of the guard. For a few months now actually, I’ve been working on our engineering team building out a Developer Relations function for those using our API and other “Powered By Looker” features.@Michael will be taking the reigns of the Looker Community team and bringing awesome new energy and ideas with him. I’ll let him introduce himself in his own words below, but rest assured that I’m really excited about what he’s going to do with the place. I’ll still be hanging around and making sure to answer all your API and embe
Anticipated Deployment Dates Release Rollout Begins: September 23, 2018 Release Final & Download Available: October 4, 2018 All Release Notes Legacy Features End-of-life Schedule Release Highlights In addition to general tweaks and enhancements, this release comes with new and improved features in the following categories. Read on for more detail. Download Merged Results as CSVs New API endpoints for git management Preparing for Release Please take notice of items marked with a ⚡ as they indicate changes to existing functionality and may require your attention. For more information see the Legacy Feature Updates and Features by Section below. Updated the Amazon Athena driver version ⚗ Enhanced Visualizations now automatically determine series sort order Made some small changes to Action Hub UI Notable Features Download Merged Results as CSV Save, download, and share merged content with ease. Merged Results queries that have been saved to dashboards can now b
Currently Scheduled Deployment Dates Release Rollout Begins: May 14, 2017 Release Final & Download Available: May 25, 2017 All Release Notes Legacy Features End-of-life Schedule Release Highlights In addition to general tweaks and enhancements, this release comes with new and improved features in the following categories. Read on for more detail. Dashboards, Visualizations, and Explore Looker Platform and Administration LookML and Development Environment Dialects Preparing for Release Please take notice of items marked with a ⚡ as they indicate changes to existing functionality and may require your attention. For more information see the Legacy Feature Updates and Features by Section below. Content Access is now entirely governed by Space Access Controls. Introduced the “Allow unlimited downloads that might crash Looker” Legacy Feature. Replaced the individual Create Model, Create Dashboard, Create Document, etc. options with a single Add Files menu in the LookML
It was just a matter of time for the nice purple colours to go away in favour of the boring white and blue. Does it mean that the UI of Looker itself will also change? Right now the colours are great and balanced, I don’t even want to imagine when, all of the sudden, Looker UI is basically white. Can you guys confirm what’s going to happen?
Hello! Let's suppose that I have a table with 2 columns: date and sales. Then, I created a graph, where the X axis is date and Y is the sales. Is there a way to control how date is grouped just like a drill down in Datastudio? Example: if a click in a button, the date will be organized by week, or month, or quarter, or year.
Anticipated Deployment Dates Release Rollout Begins: May 12, 2019 Release Final & Download Available: May 23, 2019 All Release Notes Legacy Features End-of-life Schedule Release Highlights In addition to general tweaks and enhancements, this release comes with new and improved features in the following categories. Read on for more detail. Visualization improvements Introduced support for Actian Avalanche and BlinkDB New LookML Constants parameter Preparing for Release Please take notice of items marked with a ⚡ as they indicate changes to existing functionality and may require your attention. For more information see the Legacy Feature Updates and Features by Section below. Completely removed the “Show Full Field Name” Legacy Feature MSSQL 2005 is no longer an option for new connections Self-managed instances need to install their own Google Cloud Spanner driver Upgraded Snowflake driver (v3.7.2) Refactored the pie visualization Features by Section Dashboards, V
#3.18 Release Notes ##Explore Labs Feature: Redesigned Field Picker: The field picker now collapses fields by their view and date group, removes uppercase view names from fields, and changes the color of measures. Full functionality can be turned on in the Labs panel (/admin/labs). Learn more. Labs Feature: Table Calculations: Ability to define calculations on the results of a query from the Explore page. Must be enabled by an admin from the Labs panel. Learn more. Explore descriptions: Must be defined in the Model file using the description: parameter. Will appear on hover over the ? icon next to the Explore’s name in the field picker. See documentation. Filtering by ‘OR’ in Date Fields: Press the “+” button next to an existing Date filter to add an additional filter on that field or use commas between dates when using Matches (Advanced). Learn more. The relative time a query ran now appears next to the run button (e.g. 3 minutes ago) When no sort is specified on a query with
Release Rollout Begins: March 10, 2019 Release Final & Download Available: March 20, 2019 All Release Notes Legacy Features End-of-life Schedule Release Highlights In addition to general tweaks and enhancements, this release comes with new and improved features in the following categories. Read on for more detail. Dashboards and visualizations in French, German, and Japanese. Import for private LookML repositories Preparing for Release Please take notice of items marked with a ⚡ as they indicate changes to existing functionality and may require your attention. For more information see the Legacy Feature Updates and Features by Section below. Field references to list measures are no longer supported API 3.1 no longer includes soft-deleted Looks in all_looks() calls. Experimental and Beta Features The following new and improved experimental and beta features are marked with a ⚗: Experimental project import now supports references to private repositories API 3
I love Pandora. Type in an artist’s name and it starts playing similar stuff. Pandora’s recommendation engine feels like magic. BigQuery provides a sample data set of some playlist data (Google’s @felipehoffa says the original data set was created by @apassant, awesome data!). The data is very simple: a single row for each track in the playlist. Track data contains playlist_id, artist (id and name), album (id and title) and track (id and title). Using this simple data, we built a recommendation engine in LookML that takes an artist, finds the most related artists and then recommends a playlist, all in about 300 lines of LookML. View the code on Github First, Go Ahead, Play With It Change the filter to your favorite artist and based on this data, we’ll recommend some songs. Click on the artist or song title to play music. Step 1: Build Out a Simple LookML Model The table that we’re working with is structured like this: Table: Playlists To build our LookML views and model, we need t
How do I average a daily count over week or month in looker where I need to join the data with other tables
I am new to Looker.I have a table with a count of distinct values grouped by day.I’ve imported into Looker as a view and I want to average the daily count over a month, but all I’ve come up with so far is the total count over a month. SELECT Date(checkinTime), count(DISTINCT id) AS distinct_ids_count Group by Date(checkinTime)I can’t use this because if I add the id then I have to group by it, at which point the count is 1, repeated over and over. But without the id column itself, I can’t join to the other tables where it’s a foreign key, so then the data becomes useless.Is there a looker solution to a daily value averaged over longer periods of time?
We are looking for a Senior Data Analyst to help us build out our data systems and pave the way in making data-driven product decisions. You will be the first full-time data hire. Your role will be to establish the best practices for the company, implement it, and (over time) help us to build out the data team. This role will be a mixture of running experiment-based data analyses, building out executive level dashboards, and building out key data models. How you’ll add value at Contra Own all North Star metrics and dashboards (include methodology, underlying models + visualizations) Build centralized data tooling to support data-driven decision making across the organization Establish best practices for data analyses & experiments Develop models to scale key product areas (like matching our independents to job opportunities) You’ll be successful here if You have formal education or bootcamp in data analytics - including data visualization, data cleaning, basis statistics underst
Release Rollout Begins: August 28, 2016 Release Final & Download Available: September 14, 2016 All Release Notes Legacy Features End-of-life Schedule Preparing for Release Please take notice of items marked with a as they indicate changes to existing functionality and may require your attention. Notable Features Space Access Controls Access to Spaces is now governed Space-by-Space; users and groups can be authorized to simply view a space and its contents, fully manage both, or be restricted from viewing a space entirely. By default, a Space will inherit its parent’s access settings. Groups for User and Content Management Groups can be used to manage access to Spaces and to help manage user Roles, allowing you to assign access to buckets of users. Groups can be set up automatically through existing systems like LDAP and SAML. Redesigned Mobile Dashboards Dashboards sport a new design when accessed from mobile devices. Dashboard tiles and filters now stack vertically and zoo
Apply Here: https://apply.workable.com/plentific/j/5B73FFFDD7/ The RoleWe currently have a number of remote team members based in the UK, Germany, Turkey, Poland, Ukraine, Italy, Slovakia, Spain, Portugal and Romania.We’re looking for a motivated data analyst to join our growing business. You will be reporting to the Data Engineering Tech Lead and support and work with the rest of the Data Engineering team and other company functions.We are growing fast and there is ample space for career development for motivated people. You’ll be working alongside very technical and motivated teams. Working with a variety of internal teams, you’ll have the freedom to analyse all aspects of our business in order to help various teams ensure we support our ever-growing user base. For people with the right mindset, this frame of mind provides an intellectually stimulating environment.ResponsibilitiesDevelop Looker reports for the various Plentific teams. You'll work both in the LookML code base as well
3.16 Release Date: March 2, 2015 Dashboards & Visualizations Dashboards Adjustable Row Height - Ability to change the height of rows of elements in User Defined Dashboards. Hover between rows to see an up/down arrow. Drag down to increase the height of the row above your mouse. (see documentation) Notes - Each element on a Dashboard can now have an accompanying text note used to convey information specific to that element. Add and edit the note from the gear dropdown in each element. The note can be displayed at the top of the element, bottom of the element, or on hover. (see documentation) Collapsible Dashboard Listeners - Filters that each element is listening to now collapse if they are longer than 1 line - click them to expand Improved Dashboard PDF Formatting - Includes link to dashboard, footer with time it was downloaded, and Notes Filter Modal Changes The “Apply to Field” in the Listener section of the Dashboard filter creation modal defaults to the field that matches
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.