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

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

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

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

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

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 […]