About brecht

brecht · 06-14-2021

Knowledge DropLast tested: May 13, 2020Option + Click on a series in the legend will deselect everything except that series.You can find more Looker keyboard shortcuts in this postThis content is subject to limited support.

brecht · 06-14-2021

Knowledge DropLast tested: Feb 20, 2019 At the moment, we don't have any formal docs written up on using CloudFormation.The easiest would be to create a linux host, get it all setup by following our installation guide, then create an AMI from it, and...

brecht · 05-07-2021

Knowledge DropLast tested: Jan 21, 2019 NoThere is a semi-workaround for this with the `create_process` parameter with sql_step subparameters. If your database dialect uses custom Data Definition Language (DDL) commands, you can use create_process to...

brecht · 07-17-2017

_In this post we’ll explore an easy way to enhance your geodata using Apps script and Google Maps service, which makes it easier to plot values on a map in Looker, without having to create a topoJSON file. Getting latitude & longitude for any address...

brecht · 12-07-2020

In general, any inline styling on html tags works I believe. So common css will work, but you won’t be able to use pseudo-classes and such.To reference other fields on your tile, you can use the {{ other_field._value }} syntax, e.g:measure: example {...

brecht · 12-07-2020

You can do this with a combination of some html on your measure and selecting a single value viz.Sample LookML:measure: example {type: counthtml: <DIV> <DIV>{{ value }} (20%)</DIV> <DIV> <P><STRONG>Your latest rebate status</STRONG></P> <P>(Next tier increases to 22%)</P> </DIV></DIV> ;;}Result:

brecht · 06-19-2019

@Simon is right - this is very database-specific, your db reference should have the correct SQL syntax. LookML does however have a dimension type of duration, which allows writing db-agnostic date/time diffs, which I’d say is a better solution. For e...

brecht · 04-04-2019

You’ll need to apply it to the full concatenated string Dawid: to_date(concat(to_string(${date}), ${time})) That gives you the date and time concatenated, as a date type, so you can use it in date diff functions.

brecht · 04-03-2019

Dawid_Nawrot: I created the second calculation called time and then used: concat(to_string(${date}), " ", to_string(${time})) You can use the to_date() calculation to turn it into a proper date type again, similar to the example above.

My Stats

brecht's Bio

Badges brecht Earned

Recent Activity

How do I de-select all series on a chart?

Using Looker on AWS CloudFormation

Can Looker use Stored Procedures?

Get latitude/longitude for any location through Google Sheets and plot these in Looker

Re: KPI/Visualization design in below format

Re: KPI/Visualization design in below format

Re: Date_diff function in LookML

Re: Date formatting for table calculation

Re: Date formatting for table calculation