One Button Solution - Period over Period Analysis with a Set Trend for each Date Type
Hi!What I currently have is the following:A “to date filter”, that filters yesterday, weekly, monthly, quarter...
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
Syntax for "less than or equal to" in templated filter
I am trying to create a templated filter that will only show data on or before a given date. i.e. a filter tha...
Can we implement role play dimension logic like Order Date, Ship Date, Delivery Date, etc?
Can we implement role play dimension logic like Order Date, Ship Date, Delivery Date, etc?For example, suppose...
Maintenance of user-defined dashboards when deploying new versions Lookml code
Hi!We are working with a multi-environment (dev, acc and prd instance).We offer LookML dashboards to our end-u...
Show unecrypted data from DRUID in looker
We are planning to use Looker on DRUID for reporting. PII data elements in DRUID are encrypted but we need to ...
Draw polygons on map in looker
Hi,I have a geojson file that contain several polygons, how can I use it and upload it on a map it looker?
Switch between daily, weekly, monthly views with automatic autofill for missing grains
There’s a topic here that shows how we can create a date_granularity parameter that allows us between daily, w...
mesure distribution in month table (active users)
Hello guys, I have a measure that counts employees actively working in a range of time, so the measure looks a...
Reordering drill_down for measure to come before any dimensions
Hi community, I have a count_distinct measure that has drill_fields set to using a measure and a set of dimens...
one fact table with multiple dates
Hi, I am working on a project that we have some questions about.The project works as a star schema, we have on...
Creating a custom Date dimension in Looker Studio
Hello, I’ve been dealing with an issue when blending data from two different Google Analytics Universal views ...
Remove last 3 characters from a string
How do I remove the last 3 characters from a string in LookML? For example, I have “ownername2022:03:29”and I ...
Issue Calculating Median
Hi,I am trying to calculate median for differences between dates in Looker using datediff function and median ...
Total Sales for selected date filter
I need last n months sales for the brands means not separately for each months based on the number of months s...
Convert Date to String
I have a Date field I would really like to convert into a STRING so I’m able to use it in a CONCAT field. How ...
Save a number filtered by a dimension in a field to use it for further calculations
Hi everyone,I’m using looker studio for analytics data and have a roadblocker at the moment. In GA there is a ...
field name couldn't be find (refinements issue?)
I’m working an implementing this tutorial. ContextHere is the architecture of my project:I’m generating a fake...
Issue working with time fields from BigQuery inside Dimension in LookML
I have a TIME field inside my source table in BigQuery that have the time (hh : mm :ss) of my transactions:Whe...
Auto-Switch between Dev & Prod Schema and PDTs
I would like to share an approach to auto-switch between development and production datasets on a single looke...
How to set up an aggregation year filter and switch the data acquisition year for the entire dashboard at once
We would like to know if you have any ideas on how to implement the requirements in the following prerequisite...
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...
Connect Multiple Dashboards to a Unique Data Connection
Hello Everyone, I would like to know if there is an way to create a global connection to a database and connec...
Period over Period Control (and a bunch of other features) Block for Looker
We just released a new period over period block for Looker. It has a bunch of features. It was developed for R...
How to add a button to lookerml dashboard with filters in query parameters?
- dashboard: test_dashboard title: Test Dashboard layout: newspaper preferred_viewer: dashboards-next elements...
Counting unique id's in one column
Hi,I am new to Looker and am having various success and can see its a very powerful tool but i have hit a poin...
Code not saving CSV
I have the following code, what it does is it uses the client id and client secret to get an access token, the...
Multiple hyperlinks in one cell
Is it possible to show two or more hyperlinks in one cell in Looker?
Color coding on one dimension based on the values of another dimension
Is it possible to have conditional formatting on one dimension based on the value of another dimension in Look...
Change the color of dimensions in Map
I have two dimensions in my looker view file like this: dimension: start_location { type: location sql_latitud...
Aggregate Awareness with filter only fields?
I have a big partitioned table which I want to add aggregate awareness to. However, it uses a filter only fiel...
