This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
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...
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...
_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...
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 {<!-- --><!-- --><!-- -->...
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:
@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...
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.
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.