Conversion to Date
How do I convert to data in the looker, I saw that it doesn't have the dataparse
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
Unpin Axis from Zero on Combination Chart
Hello everyone,I am currently developing some charts for dashboard in LookML and I am facing some issue with t...
LookML Dashboard generate ratio
view: conversations { sql_table_name: "PUBLIC"."CONVERSTATIONS" ;; dimension: conversationId { type: string sq...
filter pushdown and looker empty points
IS there a looker-pinot connector ? We are using Trino to fetch data stored in Pinot , via LookerIn table the ...
SQL Server 2016 Error: GROUP BY expression must contain at least one column that is not an outer reference
Hi all,I am trying to build a viz that shows the fiscal year of the date selected by a user in a templated fil...
chart dimension changes and adjusts the date dynamically on the choice of filter
My requirement is a line chart where X-axis is plotted with week(six weeks) and Y-axis is a measure. Now the w...
Look files?
Hi Is there a specific lookml file type for looks, or a feature that is being developed?
Quarter Format Issue
Hi Team, I am facing problem with my Quarter value. In my data set I can see quarter as 2021-01,2021-04,2021-0...
Merge Query and LookML
Are there any plans for developers to create merge queries like everything else, i.e. write LookML and the res...
Dynamic Dimension with Links
I have a dynamic dimension that reads a parameter. The dimensions should have a link. These links do work if t...
How to correctly relate a master table of dates with 2 or more tables.?
How to correctly relate a master table of dates with 2 or more tables.?
Seemingly inconsistent SQL generation
I’m using liquid to dynamically switch the metric being used in a measure based on a parameter that users sele...
How to exclude data that has a specific tag ( when there are multiple tags)
Hi, I’m new to looker. I am trying to identify orders that are tagged as “test” to exclude them. The problem i...
Can I use constants in my sql derived table?
Hi all, I’d like to work with constants in my manifest file however I can’t seem to get it to work. Am I able ...
monthly recurring revenue, churn rate, net retention rate in the subscription world
Very often, I work on subscription data, with a typical contract table with a start date, an end date, an amou...
display historical pipeline with hubspot deal_stage table from fivetran
When I am working on cRM data, I always use the crm block form keboola with a bit of the salesforce block. I w...
SFTP Server Scheduled Delivery more than 5000 records
Hi,I created a Table chart and saved it as dashboard by using a database Table which comes from Google Big Que...
Add WK before Week Number
Hi Team, I am having week number column which is part of date dimension as 1,2,…. 52. Now my requirement is to...
Default filter selection on landing page
Hello,I have a filter in my dashboard from a field whose values looks like - ‘WK 20’ , ’Wk21’… so on. This is ...
Big Looker Explore vs Small
I have too many explores at my org at the moment which clutters the user experience. Are there best practices ...
Measure type of an amount of time
I have a dimension that represents the duration of a media in seconds, which is currently typed as a number.I ...
Run Initial SQL on Looker
Do we have any place in looker to Run the Initial query while connecting to the Database? Please help.I need t...
Run Initial SQL on new connection?
Hey all – I am wondering if there is a way to run a custom SQL statement for each connection . Specifically, I...
Get filter value from non-templated filter
Is there way to get a value from a filter that isn’t a templated filter and reference it in the `sql` paramete...
Database Limits
Hello,My client is currently using Amazon Athena for the database connection to Looker. Currently I have creat...
QA automation Looker reports
Hi,our organization has asked we QA to find a way to automate Looker reports. We use big query data in that.Ho...
Customizable drop downs using the HTML details
I'm trying to drop down Html with this code but it's not working measure: GROSS_PROFIT__Total { type: sum sql:...
How to capture date difference with liquid ml
I am attempting to use Liquid ML to adjust a table i am using for a look depending on the date range a user se...
Can't find the recorded bootcamp or webinar in the past?
Hi sir, I know there was used to have some recorded webinar or bootcamps in training.looker. But now those are...
Incremental SQL PDT not working
I’ve got this incremental PDT: derived_table: { increment_key: "last_update_time" increment_offset: 5 sql: WIT...
