Add Date Field in Drill Field
I have an END Date Field in my View that I want to include into a measure drill field. The End date is defined...
Forum Posts
Looking for a solution to count unique working days in Looker with existing parameters
Hello Looker community,I'm working on a project where I need to count the unique working days based on data in...
Looker visualization mysql issue
I connect to mysql server to visualize data into looker. I have column which has dates in text format. The tab...
method 3: period on period comparisons using postgres SQL
Hi, I have found this article which helps with period on period comparisons however it is in big query and I w...
Dynamic dates based on Completed period and period to date
Hi all, I was wondering if anyone has set up / knows how to do dynamic dates that are able to filter for day l...
How to set a relative date as the default date for a date filter parameter?
How to set default value for a date filter parameter which is like ‘3 months before todays date’ and also give...
Min/Max of a Timstamp Breaks Timezone Conversion
In our looker instance, we have a view that takes the min/max of a datetime:view: view_name { derived_table: {...
Convert String (yyyy-mm-dd) to Date field
I have a field in my database that is a string field but it contains dates in the following format: “yyyy-mm-d...
Custom filters/parameters: Select a complete full month
Hello,I have created a dashboard where I want the users to be able to compare period over period, specifically...
How to compare current quarter to same quarter last year?
I’m trying to show how we are performing in this current quarter to the same quarter last year, but have not f...
Filter data on max datetime for each id’s
Hi ,I have a requirement where is need to filter data on max date for each id’smy data looks thisid datetime a...
Does anyone know how to code custom dimension to get "week_end_date" as a new dimension? Versus week_start_date.
Hello Looker community,I would like to find a way to create a new dimension grouping data for a datatype date ...
How do have wk. 52 show as 2021 and not 2022?
We have a dimension_group that extracts timeframes from a timestamp field. We want to compare year over year f...
Complete dynamic date filter
Hi,I am currently working on a marketing dashboard, where the business user will be able to dynamically aggreg...
How to pass liquid parameters to `date` fields filters?
How to pass liquid parameters to `date` fields filters?I can pass parameter to string filters like this filter...
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...