Datameer Blog

Tag: Looker FAQs

How to create a funnel chart visualization in Looker?

How to show the column value labels in thousands without changing the value label format for % change 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 trial of Datameer Spotlight and discover how data and […]

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

How to allow dimension/measure tooltip in Looker to show the description to user when pointing over name of the object in a Look (Table)?

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?

How to use a dimension from another view 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?

How to do conditional formatting of color or images within table cells using HTML 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?

How to change the order of stacks in a stacked area chart 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?

How to do time zone conversions for Microsoft SQL Server databases using 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

Instant Access To Our Free Library Of Resources

Discover the Top ETL and Data Integration Platforms

Comparison_of_Leading_ETL_And_Data_Integration_Platforms

Featured Blog Posts

Five Critical Success Factors To Migrate Data to Snowflake
Five Critical Success Factors To Migrate Data t...

You’ve decided to modernize your data and analytics stack and migrate analytics workloads to the ...

  • John Morrell
  • May 10, 2021
ETL++
ETL++: Reinvigorating the Data Integration Market

(This article first appeared on Medium on April 6, 2021.) The definition of “++” means incrementa...

  • John Morrell
  • April 12, 2021
Spectrum ETL
Disrupting the no-code cloud ELT market: Datame...

More than just loading Data: Datameer launches Datameer Spectrum ETL++ to disrupt the no-code clo...

  • Press Release
  • February 9, 2021
READ ALL