Date filtering formatting
When I select timeframe filter in dashboards, the date displayed here in the filter is in the format: YYYY/MM/...
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
How to set default date format?
I have the following dimension group for dates. Currently, the default dates that appear on charts are 2021-07...
Caching Policy on PDT
Can you create a caching policy on a PDT to be something like “at 06:00 every day”, rather than persisting for...
Last Quarter data in new quarter
Hi, i need to get the data for the last date of quarter can someonehelp me here
Using liquid parameters in SQL breaks filter suggestions
Hello,I am writing custom SQL to define my table in Looker and I’m trying to filter date within the look using...
build first project in looker
I am a new user here at looker. I am not getting any help from documentation. I have not found any option wher...
Custom Map Layer (topojson) Not Showing Up on Map
Hello! I am working on integrating some custom map layers into my Looker Explores and having difficulty gettin...
Creating a new dimension (buckets) from previous variable.
Hello,I am hoping someone can help me with this. I am not sure if this can be done in a table calculation or c...
Generating Excel
By using looker, can we generate excel with random numbers. Do we have any function for that in looker ?
Metric Selector Parameter as column
I would like to create a list of metrics as a dimension so I can create the following. I would then need to fi...
Creating buckets of new combined categories for a chart.
Hello,I am hoping someone can help me with this. I am not sure if this can be done in a table calculation or c...
Value Format Name validation issue
Hi,I have added a named_value_format in my model:named_value_format: gbp_with_comma { value_format: "\"£\"#,##...
Looking to Create Adjusted Date Dimension Based on Min Date of 2 Columns
Hello - I am working with some messy data that needs to be adjusted in certain cases, but don’t have access to...
[Analytic Block] User Loyalty and Other User Attributes
About This BlockLoyalty facts are attributes computed over the lifetime of each user, which helps us segment a...
How can I add my brand logo in Looker Excel format?
My customers always download Looker reports to Excel. However, when they do so, Excel file is not formatted. C...
Top5
Hi,I trying to filter a tile from my dashboard with the top 5 categories per month. I found this link: https:/...
There was a problem running the query
I have been getting this error in a Look . I narrowed it down to one particular field , but the same field wor...
Sql_always_where in Explore when using Templated filter
Hi,For a Dashboard requirement , i had to create a templated filter and write an sql_always_where filter in th...
Why is sum measure is not working in derived sql? But works when custom filter is applied
On using this .lkml file, sum is not calculated for my column “SumPlannedQuantity”Complete file can be viewed ...
How to get Filter's Start and End Date From Another View?
Hi guys, hope you are doing great. I would like to know if anyone can help me with my problem, but first, I wa...
How can I label my column string values differently in Looker?
I have a column with few name values which are string basically and I need to just rename them so that it show...
Count the number of days beween two purchases
Hello,I have a table with the dates customers made purchases.Please I would like to calculate the number of da...
Temp derived_table creation failed: Unknown database 'looker_tmp'
Hello,I’m trying to create a temporary derived table and get the following error: “temp derived_table XX creat...
LookML VSCode Extension - Syntax Highlighter
After having read this topic: https://community.looker.com/open-source-projects-78/anyone-interested-in-a-vsco...
Liquid syntax
Hello everyone,I can’t understand why the following block of code works(First Block) while the one below(Secon...
Using measures multiple times based on parameters
Hi!Is there a way to repeat measures (or dimensions) multiple times depending on parameters?To set up the cont...
Generating fileds in lookml based on query result
Hi, I need dynamically create dimensions based on query results that return column names and data types.Is it ...
Best practice for including different field sets in explore based on user attributes
Imagine you have a lot of fields and you want to customize the end-user experience for each team at your compa...
Custom Dimension selection doesn't register when creating custom measure
Overview: This is a bug I encountered with the ‘Field to Measure’ dropdown in the Custom Measure creation moda...
Cannot specify both sql_table_name and derived_table for view
Hi i want to create a derived table using sql in my view only that sql query is a composition of two unions of...
