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 […]
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 […]
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 { […]
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 […]
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 […]
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 […]
You’ve decided to modernize your data and analytics stack and migrate analytics workloads to the ...
(This article first appeared on Medium on April 6, 2021.) The definition of “++” means incrementa...
More than just loading Data: Datameer launches Datameer Spectrum ETL++ to disrupt the no-code clo...