What’s New for Browsing and Exploring

On this Page
Docs Menu

We roll out new cool features every month. Come to this page to see the list of changes for the Browse and Explore sections of Looker.

Looker administrators and developers should also view our official release notes page.

Looker 4.18

Features by Section

Scheduling and Downloading

  • The “Edit Schedule” gear menu option now says Add Schedule if no schedule exists.
  • Users can now download data from the Drill modal.
  • The Scheduled Plan Dialog now closes with the ESC key

Dashboards and Visualizations

  • The vertical order of series in legends now matches their order in stacked Column visualizations.

Spaces and Content Management

  • When LookML Dashboards are imported into a Space, the banner notifications now link to the Dashboard and Spaces to which it was moved.

Looker 4.16

Notable Features

Download from Table Visualizations

Ever wanted to rename field headers before exporting data from Looker? How about hide columns that were included to help you build a table calculation? You can now download from a table visualization rather than from the results table. This will let you apply most of your table’s configurations to downloads, schedules, and public Looks. Conditional formatting and custom colors are currently not applied.

Smarter Query Caching

Using datagroups you can tie query caching closer to your ETL timing. No need to estimate when your data load will finish and set a cache length that will hopefully not result in yesterday’s data. A datagroup will let you say “just don’t use a query’s result if it’s old data.” Simply define a persist_with scheme—some trigger that will change when your data load process is complete and an optional maximum life—rather than some period you’d like a query to persist_for.

Features by Section

Scheduling and Downloading

  • Apply table visualization configurations to scheduled and exported content. Table visualization options including renamed series, hidden columns, and totals are now available in downloads, schedules, and public Looks. You can still download from the visualization if you’d prefer. Conditional formatting and custom colors are currently not applied.
  • Scheduled Look and dashboard delivery format choices were reorganized for better clarity.
  • Added the option to select TLS and SSL versions if enabled on the SMTP admin panel.

Dashboards

  • Introduced an on-element toolbar for editing individual dashboard elements.
  • Dashboard element rendering order now prioritizes elements in the current viewport.

Explore

  • Instant Explore. Introduced the ability to explore directly from the SQL Runner.
  • Added a search bar to the Explore menu.
  • Added the ability to drill on null values.

Content Management and Discoverability

  • Reintroduced pagination for Spaces. Looks and dashboards are now capped at 30 per page, with the option to page forward to see additional content. This does not apply to the LookML dashboards spaces.
  • The model name associated with Looks and dashboards is now only displayed if there is more than one model used in that Space.
  • Renamed the Edit Look Settings gear menu option to Edit Settings.

General Tweaks

  • Table calculations and custom filters now autocorrect case sensitivity issues and provide better warnings in the event of improper constant usage (Yes vs. yes, for example).

Looker 4.14

Notable Features

Single-Value Dashboard Filters

Sometimes it doesn’t make sense to filter on multiple values; your city lookup Dashboard will look pretty crazy if you filter on New York and Santa Cruz. With Dashboard filter customizations you can set a filter to allow just one value, forcing a match to a user-entered value or a User Attribute.

A Simplified System for Content Access

Introducing a streamlined set of content access rules, designed to make it easier to manage users’ experiences and exposure to Looks and Dashboards. No need to sort through a web of model access, user permissions, and Space controls to determine what your users can see; simply use Space Access Controls to govern what folks can see.

Timeline Visualizations

Wondering when your users were active? How about what hours you’ve got support covered or when your warehouse staff is scheduled? The new Timeline visualization might be the choice for you!

Features by Section

Dashboards, Visualizations, and Explore

  • Introduced the Timeline visualization.
  • A field’s description will now appear in a tooltip when hovering over the column header on Dashboards, Looks, or in Explore.
  • Dashboard filters can now be configured to accept just a single filter value.
  • Added an option to the vector_tile_region map layer to enable the outlining of regions without data.

Looker Platform and Administration

  • Content Access is now entirely governed by Space Access Controls. Learn more
  • Added the ability for Looker admins to block downloading “all results” in some cases.

General Tweaks

  • Tweaked Look and Dashboard pages to improve header text alignment.

Looker 4.12

Notable Features

Dashboard Creation and Editing Improvements

Looker 4.12 brings a host of tweaks to make creating, editing, and managing Dashboards easier. Create a Dashboard right from Spaces and add Looks or Text elements using the slick new edit toolbar; no more fishing through the gear menu. Those Text tiles you added now accept Markdown for formatted text and links. You can also grab the Dashboard LookML associated with a Look-based Dashboard for extra portability.

Percentiles and Medians

Take on meatier analysis with built-in median measures! Rather than hoping your SQL dialect has a median function or settling for averages, you can now use the new median and percentile measure types (in both standard and distinct varieties).

Features by Section

Dashboards and Visualizations

  • Improved Dashboard creation and editing workflow:
    • You can now create a blank Dashboard from the Spaces page.
    • You can now edit Dashboard titles directly from the Dashboard page.
    • You can now delete Dashboards directly from the Dashboard page.
    • Edit Mode for Dashboards now displays the options to add Looks, add text elements, configure settings, and configure filters in a toolbar rather than in the gear menu.
  • Updated Dashboard text elements: Dashboards text elements now accept certain Markdown tags for formatting and rendering links.
  • Added a Dashboard gear menu option to associate the Dashboard LookML with a User-defined Dashboard.
  • Updated the touch options for Visualizations on mobile:
    • Pressing and releasing will bring up the tooltip for a data point.
    • Pressing and dragging along a chart will display tooltips for whichever datapoint is being touched.
    • Pressing and holding on a single data point will bring up the drill modal.
  • Updated the display for Dashboards with Elements in multiple timezones.
  • Updated the display for collapsed Dashboard filter bars: Collapse filter bars now display the filter value for a User Attribute rather than the Attribute name.
  • Removed text elements from a Dashboard’s Edit settings.
  • Updated the behavior for clicking a Dashboard Element’s title: Clicking on the title now launches an Explore directly instead of opening the gear menu.

Scheduling and Downloading

  • Introduced the ability to add text to scheduled Looks and Dashboards.
  • Introduced filterable scheduling on Looks.
  • Added a new Inline Image scheduled Dashboard type that mirrors Dashboard display in Looker.
  • Improved Filtered Schedules:
    • User attribute-based filter values now display in filtered schedules.
    • If a piece of content is scheduled to more than one user and the schedule fails, the error email will now display the recipient information.
    • “View this data in Looker” links now take users to filtered versions of the Look or Dashboard if the email is for a filtered piece of content.

General Tweaks

  • Added more precision to the funnel visualization for comparing small values.

Looker 4.10

Notable Features

Improved Y-Axes Controls

The y-axis configuration settings have been revamped, making Cartesian charts much more flexible. You can now combine any number of y-axes (or chose not to!), scale and format them independently, and split pivoted series across axes. Happy creating!

Features by Section

Dashboards and Visualizations

  • Selective assignment of series to y-axes. Create or combine any number of y-axes. Learn more.
  • Introduced a Funnel visualization type. Learn more.
  • Added Visual Drilling to the Labs menu, letting it be disabled if so desired. Learn more.
  • Tables in PDFs now show their full width.

General Tweaks

  • Looks & Dashboards can now be moved into personal Spaces.
  • The Save button on the Explore page will now return you to the Explore Page instead of taking you to the Look.
  • Filter values rather than filter names are now displayed in bold when the filters bar is collapsed.
  • Hovering over relative timestamps now displays the exact time.
  • Added the ability to copy values from SQL Runner Tables & Drill Overlays.

Looker 4.8

Notable Features

Conditional Formatting

Make the results that matter pop! Table visualizations now sport a Conditional Formatting labs feature; use it to specify rules that color values that are low, high, or otherwise of interest.

Filterable Dashboard Schedules

Dashboard schedules can now each have their own filter values, letting you customize results for your recipients. Send regional teams results filtered for their territories of interest and filter weekly, quarterly, and annual reports independently. Use a single Dashboard to manage your scheduling needs!

Features by Section

Scheduling and Downloading

  • Filterable Dashboard Schedules. Introduced the ability to change filter values for each schedule associated with a given Dashboard.
  • Inline Tables is now the default email delivery option for new scheduled content. Existing schedules won’t be changed.

Dashboards and Visualizations

  • Conditional Formatting [labs] for Table visualizations. Learn more about Labs features.
  • Added drop-down options to the Add/Edit Dashboard Filters interface.
  • Trend Line equations and R2. Trend Line labels can now display the equation used for the line or the Trend Line’s R2 value.

Looker Platform and Administration

  • Powered by Looker
    • Saving from an Embedded Context. Introducing the ability for embedded users to save content the ability to curate content for embedded users.
    • Scheduling from an Embed Context. Embedded users now have the ability to schedule Looks and Dashboards.
    • Embedded Look URLs can now be modified to override filter values.
    • JavaScript embed events can continue firing across page loads.
    • Exposed embed-related external_id fields in already-existing credentials_embed and space routes.
    • “Rebuild Derived Tables & Run” option on Explore pages is now hidden for all embedded users.

Content Management and Discoverability

  • Unused Content and Trash. Introduced two sections that let Looker Admins to, in bulk, clean up all of the unused and unneeded content on an instance.
    • The Unused Content page will pull together all content that hasn’t been touched in 90 days. Admins can then delete those items, which will move them to the Trash.
    • Trash. Items in Trash can be restored or permanently deleted at the Admin’s discretion.
  • Tables in Spaces are now sortable and are paginated. This does not apply to the LookML Dashboard space.
  • Move and Copy Modals in Spaces now match the new Save Look modal.
  • Run on Load for Looks. Introduced the ability to set whether Looks run immediately. This setting can be configured in Edit Look Settings.
  • Moved Public Access settings for Looks to the Look Settings modal.
  • It is now possible to delete a Dashboard from the Dashboard page.

General Tweaks

  • Disabled the Save button from the Edit Look modal until the query is finished updating. This addresses an issue where Look edits would not persist if saved too quickly.
  • Group labels for measures are now the same color as measure names in the field picker.

Looker 4.6

Notable Features

Parameterized Content

Simplify monitoring, alerting, and updating users by tying Dashboard and Look filters to User attributes. A single dashboard can be tailored for each of your sales representatives based on names from your CRM or sales region. Update engineers and product managers on open issues based on assignee from your issue tracking service or routinely update your support team on their individual issues needing follow up.

Multiple Schedules per Piece of Content

Dashboards and Looks can now have several unique schedules, letting you schedule the same piece of content at different intervals or to different recipient lists. Send reports daily or weekly based on need or to different regional groups to ensure they’re received during business hours. You may even want to schedule visualizations to your team and CSVs to a webhook, S3, or SFTP for safe keeping.

Features by Section

Scheduling and Downloading

  • Multiple schedules. Added the ability to create multiple schedules via per piece of content from the schedule modal. Learn more.
  • Larger scheduled result sets. The schedule modal now has SFTP and webhook options, to which users may schedule Look results. An “all results” option is available in cases where query results may be streamed. Learn more.
  • Improved Inline Dashboard emails to improve legibility and visual consistency.

Dashboards and Visualizations

  • User Attributes in Filters. Added the ability to associate User Attribute values to filter values, enabling parameterized content. Learn more.
  • Increased scrolling speed when dragging dashboard tiles.
  • Improved rendering of map data by updating the mapping library.

Content Management and Discoverability

  • Redesigned Save Look modals to improve Space browsing and navigation.
  • Faceting for Top Content. Filter and sort Top Content by Group to explore what matters most to you and others.

Looker 4.4

Notable Features

User Attributes

Administrators can curate the Looker experience by dynamically modifying interactions with User Attributes. Administrators can assign values to Users and Groups and subsequently reference those values throughout the Looker platform to tailor interactions for each User. This includes assigning attributes such as a sales region or credentials to some outside services.

We’re starting with User Attributes to let administrators and developers to set User- or Group-specific Data Actions or database Connections, enabling users to do things like update issue tracking software right from Looker.

Features by Section

Looker Platform and Administration

  • User Attributes. Introducing a new system whereby Users and Groups can be assigned values that can then be referenced throughout Looker. Learn more.
    • Database connections: The host, port, database, username, and password of a Connection can be parameterized so that each User will connect with their own credentials rather than through a single Looker user. Learn more.
    • Data Actions. Data Actions now accept User Attributes as part of their payload, letting you use a User’s credentials to perform an operation against a particular service. Learn more.

Scheduling and Downloading

  • Larger scheduled result sets to SFTP via the API. Added the ability to schedule queries with no limit to SFTP via the API.
  • Scheduled tables now include totals and table calculations. Improved inline table and HTML attachment scheduled Look formats to include table calculations as well as row and column totals.
  • Improved Single Value visualization downloads. Scheduled inline visualizations and Look downloads are captured as images rather than text, enabling comparisons, text, and generally making them more closely resemble how they appear in the web browser.

Content Management and Discoverability

  • Recently Viewed Content. A list of the Dashboards and Looks you have been visiting lately. Learn more.
  • Sortable and paginated content browser. Top Content, Favorites and Recently Viewed Content are now sortable and pages currently contain ten Looks or Dashboards.

Looker 4.2

Notable Features

Content Management and Discoverability

You and your coworkers are probably whipping up some great content in Looker, but sorting through all that great stuff wasn’t always trivial. Introducing a new system for content discovery! Search is much zippier than the one in prior releases and is broader-reaching. A Favorites system letting you keep tabs on the Looks and drag-and-drop Dashboards that matters most to you regardless of where they live, provided you’ve been given access of course. Last but not least, the Top Content section surfaces what you and your coworkers have been using the most. Explore on!

Schedule Full Result Sets to Amazon S3

Shirk the constraints of email and send query results to S3. Introducing the ability to send full result sets to S3, provided a query meets the Looker’s standard result streaming requirements. Bypass browser, memory, and email limitations by scheduling all results to S3 or use the process to store snapshots, periodic reports.

Features By Section

Content Management and Discoverability

  • Favorites. A system for selecting and quickly navigating to the Looks & Dashboards you care about most. Clicking the heart icon will put a link to the content piece in a list that’s easy to access straight from Spaces. Learn more.

  • Top Content. A list of the most popular Looks & Dashboards on your Looker instance. This section is a great way to learn about new reports you haven’t taken a look at yet. Learn more.

  • Global Search. A search function in the navigation bar that searches across Looks, Dashboards, LookML Dashboards, LookML files, Explores, your Favorites, Top Content, and pages like Browse and your Account Settings. Learn more.

Scheduling & Downloading

Explore

  • Streamable In-database Pivots. Implemented streamable pivots for the majority of SQL dialects for which Looker supports query streaming (exceptions in the second link below). Barring other restrictions, query results are no longer limited to 30,000 cells and users may download large result sets. Learn more about streaming pivots. Learn more about streaming in Looker.

Visualizations

  • Added the ability to fade one of the series on a chart when hovering. Learn more.

  • Implemented logic to reduce the chances of value label collisions.

Looker 4.0

Features By Section

Explore

  • Dimension fill. The results table now populates with missing date, yesno, and many other dimensional values. Associated measures are given values of null. Learn more.
  • Added “Save & Schedule” option. Users will be prompted to save their query as a Look and then be taken directly to the Schedule modal.

Looker Design

  • Updated Colors to use white backgrounds and new button styles and colors.
  • Added “Explore From Here” link in Spaces. This shortcut takes users directly to a Look’s Explore page equivalent for faster exploration.

Visualizations

  • Series tab for pie charts, donut multiples, and table visualizations. Implemented the Series tab, previously only available on Cartesian charts, for pie charts, donut multiples, and table visualizations, which replaces the Style tab’s key-value pair method for changing colors and column labels.
  • Visual Drilling. Added a visualization option to the drill overlay, selectable when drilling from a visualization. Learn more.
  • Pivots no longer require a second dimension.
  • Introduced Labels for Trend Lines.

Scheduling & Downloading

  • Image Rendering. Added the ability to download an image of the visualization from a Look, Explore, or a Dashboard.
  • Added a progress page for downloading tasks.

Looker 3.56

More Clarity When Browsing or Editing Looks

Overview

We’ve made a set of changes that make using and creating Looks easier in Looker 3.56. See how it works in this video!

Starting in this release:

  • If you just want to browse existing saved content, Looks are now much simpler and have more information. You can make changes to filter values, limits, and sorting without affecting anyone else. And, you can still use the Look as a starting point to do your own exploring.
  • If you create and edit Looks, it will be clearer when you’re editing something that already exists and when you are just exploring. Click Edit when viewing a Look, then make any desired changes, including changing the Look name right on the Look’s page.
  • It’s much easier to edit a set of Looks used in a dashboard because you can edit them from the dashboard.

Using a Look

When viewing and using Looks, look for these new changes and features:

  • View the details pane on the right side to see information about the Look, who made it, which dashboards include it, and whether there are any schedules using it. You can also create a schedule for it or add it to a dashboard.
  • Without changing the Look you can modify the filter values, sort columns, and change the row and column limits. To see the Look’s original settings click Reset Look.
  • You can also interact with the visualization in the same way that you can on a dashboard, including seeing tooltips, launching the drill preview, or clicking the legend to show or hide data series.

Editing a Look

Looker 3.56 makes it very clear when the adjustments you make will really change the Look. Like a dashboard, you now click Edit to start editing a Look. An edit window overlays the Look, giving you access to the field picker and all other features to change the query and visualization. You can also change the name of the Look right on the page. Make your changes, then click Save.

From the edit window, you can also Explore From Here, see which dashboards will be affected by your edits, or Cancel your edits.

Exploring From a Look

If you want to start from a Look to explore, just click Explore from Here. You’ll get a new Explore page with the Look’s query already in place. You can add or remove fields and filters as desired without affecting the saved Look.

Exploring From a Space

You can also choose to explore a Look directly from a Space. Click Explore from Here in the gear dropdown menu.

Fast Editing of Looks from Dashboards

If you want to modify the Look that a dashboard tile is based on, first click Edit for the dashboard.

Next, click the dashboard tile’s menu and click Edit Original Look. Looker will display the new Look edit page. When you Save your changes, Looker displays the dashboard with the updated Look.

Automatic Y-Axis Limits No Longer Need to Include Zero

For many releases, Looker could automatically choose a maximum y-axis value for you if you did not set it explicitly. However, Looker always used a minimum y-axis value of zero. Starting in Looker 3.56, you can let Looker set the minimum y-axis value dynamically as well. To do so, turn on the Unpin from Zero setting.

Still have questions?
Go to Discourse - or - Email Support
Top