add dimensions as they appear in a JSON column
We’ve got a JSON column with varied and often-changing keys. I want each of those keys to be a dimension.What ...
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 define a dimension with custom values on LookML?
I need to create a dimension with custom values such as ‘Demand’, ‘Visits Last Year’, ‘Avg Selling Price’ for ...
how to copy a production project to create a hub for hub and spoke
I want to convert a production project into a hub for hub and spoke.We currently serve multiple clients from o...
convert my timestamp dimension group from utc to gmt?
I have a dimension group like this--dimension_group: timestamp{ type: time description: "day-month-year time o...
How do we change an integer to string
Would like to change my sql in lookml from an integer originally to a string. dimension: nest { type: number s...
query date filters
So we have a lot of end users that like to run queries that have no date filters or use ‘is_any_time’ on the d...
Modelling Expansion Revenue SaaS
Hi everybody.I am currently struggling with defining and creating a specific metric for a SaaS business which ...
Link not passing dashboard filter value
I’m trying generate a list of dashboard names that link to the referenced dashboard. In order to accomplish th...
Project dupllication
Hello ! Is possible to duplicate projects in order to have a backup ?Thank you!Edit: Sorry for the misspell in...
Does a Image come back
I have a list of products , some will have images on a website , i can pull those in to Looker , what i need t...
Currency conversion
Hi, We are having multiple currency revenue in a table. I want to convert them all in one currency USD. How ca...
how to make case dimensions out of a column?
Does someone know how I can use this type of sql in Looker?Select , count(case when tickets= 'A' then id end) ...
How to add multiple values in multiple filters within the same field inside a view?
wanted to add something like this but not able to find a correct syntax--measure: total_revenue { type: sum sq...
Change join type dynamically with filters or parameters?
Hello everyone, I have a bit of a particular situation and was hoping for a workaround. Our Purchase table is ...
Check if an array is empty
I have a table user_list_data with two columns, user_id and portfolio. For instance:user_id | portfolio1 | {1,...
How to calculate YTD,MTD ,LYYTD and Cumulative calculations in Looker?
Hi All,Could you please let me know How to calculate” YTD,MTD ,LYYTD and Cumulative “calculations in Looker?Pl...
Imablanced Aggregation
Hello, I have 2 tables.SalesDate Product Size Number Sold 1/1/2021 T-shirt L 500 1/1/2021 T-shirt S 400 1/1/20...
Small UX Bug - hiding column with list of files
Lack of z-index makes this button hard to click:
PRUEBA
PRUEBA
Create View from TableのUpdate版をつくってほしい
Create View from Tableが好きで、いつも便利に使っているのですが、View定義後に上流のデータマート側に変更が入った際、都度dimension/measureを追加するのが手間なケースがあります。“U...
How to Generate dates not in a dataset
Problem: You want to generate a list of all dates between x_startdate and y_enddate but do not have those date...
Database Partitions: Troubleshooting
DB Concepts Series: Troubleshooting PartitionsPost Context: This content is adapted from our internal SME (Sub...
Database Partitions: How they work
DB Concepts Series: What partitions are, and how they're usedPost Context: This content is adapted from our in...
Restricting date parameter values
If I have two parameters parameter: reference_period { type: date } parameter: compared_period { type: date }i...
Configuration required to use database connection
Hello everyone,I’m trying to do some training by creating new models on already existing projects. However, tr...
How to Query from one Project and Write PDTs to Another with BQ
Hi all,I have gotten question about writing PDTs to a separate BQ project, but we want to able to query tables...
Identifying text with apostrophes
When creating a case when statement and referring to text in Looker, if the text has an apostrophe I cant seem...
Everybody loves maps!
Recently I’ve been working with more data of my favourite kind - geospatial. I realised that this portion of L...
Order by
I would like to know if you can fix my order by the column marked in yellow. Even though I was sorting it in t...
Table Calc Totals in LookML
Trying to get an aggregation at specific level - I know this can be done in a visualization easily using table...
