Date fields throwing error
My dimension group of date is apparently throwing errors when included in the dashboard. Can someone help me r...
Forum Posts
GROUPING MEASURES
Hello please I want to categorize my measures into buckets in my looker explore. Is that possible and if it is...
How can I hide the demo Explore?
I want to hide both “eCommerce” and “System Activity”, so when I click on Explore it only shows me “Vendas”. H...
Coalesce two date columns into one
Hi there!I have two views that I’m joining in an explore. Each view has a `created_at` column that I would lik...
Is it possible for an Explore to join a view which includes a liquid variable to itself?
I have a user_history table with roughly 100 fields, in which each record has a start_date and end_date. I’d l...
sql generated in explorer is weird
Hello, In lookml i have one explorer :Example : explore: toto{ join: tata{ type: left_outer relationship: one_...
organize views inside a folder
Hello, Is it possible to have in one explorer that hierarchy : Folder 1 view1 view2Folder 2 View3 View4…thank ...
join based on multiple conditions
I am trying to join 2 tables in the explore using sql_on.The first condition is ON and the second condition, I...
Inaccessible view error when joining a view with a "from" parameter
The problem is that I have a measure that is defined in a refined view that then is joined into an explore. Th...
Hiding some but not all fields in a dimension group
Hi I have a date dimension group that has the following structure: dimension_group: date_created { type: time ...
FIiter an explore before join
Hello, so I have two problems.PROBLEM1So, I have this explore and join in a model. I want to join some values ...
Explore Doesn't Show up When Creating a Project, and I can't create an Explore in the Model File
This should be basic, but I can’t figure out what’s going wrong. When I create the project from a single table...
How Join with two explores?
HiI built one explore :I want built customers explore and add these tables with left join to the explore but I...
join an explore with all its existing joins
Hi! I want to join explore A to explore B in my data model in lookml. Explore A was defined earlier in the mod...
How to update case statement in join to use aliasing instead?
I have a report that’s running off an Explore in my model, but one of the joins to a view needs to be updated ...
SQL Runner and Explore return different visualization
I want to add “funnel” visualization to my dashboard. I tested the query and visualization under SQL Runner en...
creating a measure to find # of users with X # of rows in a table at a time grain.
i’m looking to get the count of users with more than one ticket in a table that is at the ticket grain. So whe...
Rolling 30 day count distinct
Hi Lookers,I am trying to get the count of unique who made a transaction in a 30 day window starting from any ...
Accessing View date_time parameter from Explore
Hi there,If I'm looking to add in a date criteria to the sql_on parameter in an Explore join, am I able to lev...
Big Looker Explore vs Small
I have too many explores at my org at the moment which clutters the user experience. Are there best practices ...
Looker Dashboard - Deployment
Please Imagine there are two different projects in Google Big Query as follows:ga3-lateral-boulder -301812 big...
Filter a Column using wildcards and LIKE
Hi,Filter a column based on wild card characters. I want to filter values ending with ‘ABC’ from Col A in View...
Case When for YesNo in Custom Dimension
Hi,I need to use YesNo Dimension in Case When statement and check if it’s not equals to “Yes”, then put some v...
Rename Field name in Explore
Hi,I want to Rename Field names (of a Table/View pulled in Looker from Google Big Query) in Explore Page. Any ...
Bad SQL generated from Explore
BackgroundCreating and Explore with an “is in the past” 10 days filter generates the following where clauseWHE...
How do I average a daily count over week or month in looker where I need to join the data with other tables
I am new to Looker.I have a table with a count of distinct values grouped by day.I’ve imported into Looker as ...
Hide Fields in Explore if All Values are null
Hi Looker Community,Is there any way to dynamically hide dimension or measure in Explore if the values in that...
Unable to create explore, model file doesn't recognize views exist
I created a project > Model file > Views but when I try to create an explore in the model file using one of th...
How do I remove the GROUP BY clause for an explore/view with non-aggregate measures?
I have a pre-computed metric table that has a small set of dimensions and non-aggregate measures. How do I mod...
Hiding an explore from a group that it's included in
Hi all,I have an explore, e.g. ExploreA, that is defined in its own .explore.lkml file. It appears in group_la...