Datameer Blog

Tag: Looker FAQs

How to create a funnel chart visualization in Looker?

This tutorial addresses how to show the column value labels in thousands without changing the value label format for % change in a Looker dashboard. SOLUTION: Go to “Y-Axis Format” and use the value: 0.000,”” This would give values in the 1000s.   Sign up for a 14-day trial of Datameer Spotlight and discover how data […]

  • February 1, 2018
How to create a funnel chart visualization in Looker?

We can enable tooltip for dimensions and measures by adding descriptions in their respective LookMLs. Please consider the examples below: measure: gross_margin {   description: This measure provides Gross Margin on each sale.   type: sum   sql: ${TABLE}.gross_margin ;; } dimension: product {   description: This field provides the name of the Product sold.   type: string   sql: ${TABLE}.product […]

  • January 25, 2018
How to create a funnel chart visualization in Looker?

We can use a substitution operator ($) to reference dimensions and measures from other views in LookML. Consider the following code where we have two views, example_A and example_B.  ############################################ View: example_A {  sql_table_name: xyz ;; dimension: field_A { type: number sql: ${TABLE}.id ;; } ############################################ View: example_B {  sql_table_name: abc ;; dimension: field_B { […]

  • January 25, 2018
How to create a funnel chart visualization in Looker?

Please consider there is a field called order_status, which gives the status of each order. The possible values for order_status can be: order_is_paid order_is_shipped order_is_returned While Exploring the data, it may be helpful to display a separate background color for each status. This can be done in LookML using liquid syntax in the html: parameter […]

  • January 25, 2018
How to create a funnel chart visualization in Looker?

Stacked area chart is an extension of a basic area chart. It is used to group values of multiple dimensions on the same graph. The values of each dimension are displayed on top of each other.  To change the order of stacks in a stacked area chart in Looker, just do the following:  Go to […]

  • January 25, 2018
How to create a funnel chart visualization in Looker?

From Looker v6.22 and MS SQL Server 2016 version onwards, Looker has started supporting time zone conversions for Microsoft SQL Server databases. Hence you would use the same methods as would use to convert timezones for other databases. There are multiple settings within Looker that can be used to convert time-based data: System Time Zone […]

  • January 25, 2018

Subscribe for the Latest Posts

Search

Download our Ebook on Data Collaboration

A primer on analytics collaboration book cover

Featured Blog Posts

Spectrum ETL
More than just loading Data: Datameer launches ...

With Spectrum ETL++, Datameer eliminates the hidden costs of ingesting data to the cloud, enables...

  • Press Release
  • February 9, 2021
The Role of Chief Data Officers (CDOs) in 2020
The Role of Chief Data Officers (CDOs) in 2021

The Chief Data Officers role (CDOs) in 2021 is evolving as CDOs are having quite possibly their m...

  • John Morrell
  • February 9, 2021
Google Partners with Datameer
Datameer Partners with Google Cloud to Deliver ...

Datameer is now a Google Cloud migration partner The partnership will help customers build secure...

  • Press Release
  • December 2, 2020
READ ALL