Looker 4.12 Release Notes

release

(Carter Moar) #1

Release Rollout Begins: April 16, 2017
Release Final & Download Available: May 4, 2017

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).


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
  • Scheduling and Downloading
  • Dialects
  • LookML

Preparing for Release

Please take notice of items marked with a :zap: 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.

  • Addressed an issue where downloading sometimes lead to a 404 or 500 response (impacts Lookerbot)
  • Changed beta Dashboard API routes, consolidating LookML and User Defined dashboard routes
  • Clicking a Dashboard Element’s title now directly launches an Explore instead of opening the gear menu
  • Edit Mode for Dashboards now displays the options to add Looks, Text elements, as well as configuration settings and filters in a toolbar rather than in the gear menu
  • Removed Text elements from a Dashboard’s Edit settings
  • “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.
  • Collapsed Dashboard filter bars now display the filter value for a User Attribute rather than the Attribute name.
  • Switched to LIKE from REGEXP_LIKE for string comparisons in Denodo

Features by Section

Dashboards and Visualizations

  • Improved Dashboard creation and editing workflow.
  • You can now create a blank Dashboard from the Spaces page.
  • Dashboard titles can be edited directly from the Dashboard page.
  • Dashboards can be deleted from the Dashboard page.
  • :zap: Edit Mode for Dashboards now displays the options to add Looks, Text elements, as well as configuration settings and filters in a toolbar rather than in the gear menu.
  • Dashboard Text elements now accept certain Markdown tags for formatting and rendering links.
  • Added a Dashboard gear menu option to get the Dashboard LookML associated with a User Defined Dashboard. Learn more
  • Updated 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.
  • :zap: Collapsed Dashboard filter bars now display the filter value for a User Attribute rather than the Attribute name.
  • :zap: Removed Text elements from a Dashboard’s Edit settings.
  • :zap: Clicking a Dashboard Element’s title now directly launches an Explore instead of opening the gear menu.
  • :zap: Changed beta Dashboard API routes, consolidating LookML and User Defined dashboard routes. Impacted APIs include, but are not limited to:
  • Dashboards
  • Spaces
  • Looks

Scheduling and Downloading

  • Introduced the ability to add text to scheduled Looks and Dashboards.
  • Filterable scheduling is now available 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 recipient will be displayed in the error email.
  • :zap: “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.
  • Improved the error message produced when scheduling to an email address that is not in a whitelisted domain.

Dialects

  • Google BigQuery. Added the ability to download unlimited results.
  • Impala. Added the ability to configure Looker to use Cloudera-provided drivers. Learn More
  • :zap: Denodo. Switched to LIKE from REGEXP_LIKE for string comparisons.

LookML

  • Introduced percentile and percentile_distinct measure types for certain dialects. Learn more
  • Introduced median measure type for certain dialects. Learn more
  • Introduced median_distinct measure type for certain dialects. Learn more

General Tweaks and Bug Fixes

  • :zap: Addressed an issue where downloading sometimes lead to a 404 or 500 response. Created a new Lookerbot release as a result. Learn more.
  • Updated Data Actions to include the ability to provide a description for form fields, better error messaging, and a beta API endpoint.
  • Google BigQuery. Fixed an issue where filtered results were incorrect when using the case_sensitive parameter
  • Clarified definitions of Labs features in the Admin panel.
  • The Content Validator now updates Explore From Here Look and Dashboard links.
  • Addressed an error message that appeared if a view’s primary key was not included in a fields list.
  • Addressed a series of incorrect error messages that appeared before a Look or Dashboard element ran.
  • Addressed a number of extends-related LookML issues.
  • Added more precision to the funnel visualization for comparing small values.
  • Fixed an issue where drill links were not displayed for Funnel visualizations.
  • Fixed an issue where Dashboards with only Text elements would not appear in Spaces
  • Fixed an issue where deleted content would be included in counts in Spaces.
  • Fixed an issue where the Choose Looks modal did not populate if there was a deleted Look on a Dashboard.
  • Fixed an issue where a series’s settings were not preserved after moving between axes.
  • Fixed an issue where duplicate browser history events were produced for a single Dashboard page load.

Where is the LookML Associated with my Dashboard?
Where is the LookML Associated with my Dashboard?
(Carter Moar) #2

(Dan) #3

those filterable schedules on looks are :fire: - thank you!


(Jay Stricks) #4

What is the expected behavior for an embedded Dashboard, when the user does not have ‘explore’ permission?


(Jay Stricks) #5

Can you elaborate a bit what this means?


(Carter Moar) #6

A user without the explore permission should not be able to click through to explore from a Dashboard Element.

When creating or editing a schedule there is a “Message” text field. Text entered there will be in the body of scheduled emails.


(Philippa) #7

Which DB dialects will support percentile and percentile_distinct or will it be DB agnostic ?


(William Lane) #8

Here’s our support for percentiles/percentile_disctinct per DB:

Full support (works with symmetric aggregates) on:

  • Google BigQuery (legacy)
  • Google BigQuery (standard)
  • MySQL
  • PostgreSQL

Non-distinct (does not work with symmetric aggregates) support for:

  • Hive
  • Oracle
  • Presto
  • Redshift
  • Snowflake
  • Spark

(Jonathan Palmer) #9

Hi @William_Lane, what about for Exasol and Impala? Thanks, Jon


(Michael Erasmus) #10

Any timeline on when self-hosted customers will get this release?


(William Lane) #11

@jonpalmer There isn’t support for Exasol or Impala just yet but could you email support@looker.com and we’ll provide feedback to our product team?


(Carter Moar) #12

We’re still on track for Thursday, @Michael_Erasmus. Barring any major snafus, you should get an email on the fourth.


(Michael Erasmus) #13

Thanks @cutler!


(Leland) #14

Nice release here! Love the markdown support for text, and hope this is a nice transition to the ability for users to be able to add commentary on dashboards too :slight_smile:


(Carter Moar) #15

(Jay Stricks) #16

Are there any more details for this change?


(Carter Moar) #17

The API response structure for LookML dashboards is now the same as that for User Defined Dashboards (rather than returning two different response payloads)