How do I dynamically switch view name in sql parameter of dimension?
There is a "rate" dimension in “masterdata” view using "${corp_1.date}" in sql parameter.explore: corp_1 { joi...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Merging Two Explores
Does anyone know how to merge two explores by month? When I click the gear icon on my primary explore I cannot...
Federated query from multiple backend instances
I have Looker dashboard, which needs to marshal data across two Snowflake instances - one in AWS and the secon...
Calculating the number days in the timestamp filter
Hi,I’m new to looker.I want to calculate the number of days in the timestamp filter.For example:If I have filt...
Looker and Sybase IQ
Is there support for Looker connecting to Sybase IQ?
Looking for an option to send an email with the saved filename & its file location of 'Amazon S3' from looker scheduler when using S3 scheduler
I'm looking for an solution or workaround to send an email with the saved filename & its file location after s...
Using "date_start" and "date_end" values of a filter in liquid if statement
Hello, everyone!I’m using templated filters with filter of type “date”. At the same time I need to display the...
Can we create a custom measure which excludes which excludes the main filters in a look?
A look created has a few main filters to derive a set of data. Can we create a custom measure which excludes t...
Seeking for the best LookML development system in our ads agency
15 marketers and 1 LookML developer use Looker at our digital ads agency in Japan. Each marketer gives his/her...
Change Value format display in bps
Hi,I want to customize value format to be display in bps. For example, 0.0123 will be displayed as 123 bps. Is...
BigQuery Machine Learning (BQML): LookML Syntax Explanation
Hi all,BigQuery Machine Learning (BQML) is a BigQuery’s feature that allows users to create and execute machin...
Looker on SAP HANA Calculation View
Hello,Have used Looker as a reporting tool using SAP HANA calculation view as source.Consuming SAP HANA calcul...
LookML IDE - Format file shortcut
Hi,by the documentation, Ctrl+Shift+F should auto-format a file (e.g. lookml dashboard file), it’s however doi...
Can Looker import descriptions from Snowflake?
I’m using dbt to push descriptions to Snowflake using the persist docs functionality. I am now wondering if Lo...
[Partner Block] Patched| google cloud billing by datatonic
This block has been patched to take into account the new sink steps and changes to the audit log tables (switc...
Dynamic value in parameter
Hello All,I want to create a dynamic parameter where I can choose the next three months from current month.Can...
Apply Min/Max to multiple columns in measure
TLDR: How can I apply MIN/MAX in measures to multiple columns?We have a table `Person` and 2 joined tables `ev...
Using SPLIT_PART in dimension
I have a table in snowflake with a column that produces a string like this “144514490704288__LOOKUP__193333025...
Creating yes/no type dimension with measure condition in sql
I have a location dimension and a inventory measure.I want to create a yesno type dimension which removes a se...
Use query's calculation in LookML.
Not sure how to ask this because I’m still new at this.Our data doesn’t include a field for message url.But it...
Help with VEGA migration to looker
Can anyone please help with the migration of “vega visualization”.https://github.com/vega/vega
adding 12 months roll back filter to the explore
I want to add a 12 months look back filter to the explore so that, the explore always gets the data for the la...
Splitting a date string
Hello, I am trying split a date and time string into separate date and time components, i.e. 01/04/2020 11:45:...
How do you access json object from a json file inside a view
I have a json file with a key value and i want to use this variable in a view how do i achieve this with Looke...
How to create a looker account for practice?
HI Iam a new user to looker and iam planning to explore the looekr visulaizations and how it works please let ...
dashboard filter on date range does not work for other users
Hi:I have built a dashboard with a filter on a date range. I have made it required and I have configured defau...
Model Multi - Fact
Hello all, I'm a newbie. I need to realize a model that link together two or more fact tables.For example Move...
how to escape a special character in my dynamic URL
Hello , I’m having an issue in which I have a parameter in my URL , for the most part it works well except one...
Templating in localizations
In my LookML, I have the following: valueFormat: '#,### "tons"'I would like to localize the “tons” string, but...
How can we localize filters in downloaded dashboards
The filters in my dashboard all have a localized title as in the screenshot above.My problem is that the filte...
