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...
Forum Posts
How to concat and convert date from from YYY-DD-MM to MM/DD/YYYY
I want to write a dimension with adding text values and date with MM/DD/YYYY formateg: Result for: 2022/11/05 ...
How to Change the Date format to Sep - 2022
I copied and pasted the code into my LookML from this support page and put in my timestamp field. It does not ...
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...
Converting String to Date
dimension: ticket_start_date{ type: date_time sql: cast(${TABLE}.start as timestamp);;I’ve tried using the fun...
Changing String Date Type from DD-MM-YYYY to YYYY-MM-DD in Date Datatype
I have a view in Looker which has a dimension Sales date with datatype as String and it is in the format DD-MM...
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 ...
DATE_TRUNC timestamp to week in SQL Runner
Hello, I’m using SQL Runner for the first time and am attempting to roll up a series of dates into their respe...
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...
BigQuery + Looker: Timestamp vs Datetime
Hello, we have Looker on top of BigQuery. Currently there is a lot of mixed usage when it comes to dates and t...
Converting epoch date to yyyymmdd dimension for exporting purposes
For external reporting purposes I need to convert the epoch date to a yyyymmdd format.I used the liquid logic ...
Date formatting
Hi,How to change the date format from ‘02-jan-20’ to ‘2020-01-02’ in the dimension?