Crazy average value on measure
Looker is generating a crazy average SQL and I don't understand why. In my view, I have a number field which r...
Forum Posts
How to replicate "userelationship" (power bi) in looker?
Hi guys!The problem I’m facing is that in one fact table there are two dates:-Start date-End dateSo, in power ...
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...
GROUPING MEASURES
Hello please I want to categorize my measures into buckets in my looker explore. Is that possible and if it is...
Moving Averages as Measures
I’ve come up with a “hacky” solution to including Moving Average as Measures into existing Looker models descr...
How do I sum values that start as strings and have decimal points
Hello!I have a BQ table that contains values like 10.0055858585 and 0.069872323 in a column that is a STRING t...
Dynamic Measure Not Working
I’m trying to create a report where users can view the Revenue by month OR the Clicks by month. I think Dynami...
Looker Filter Expressions
Hi Community!What are the differences between measures leveraging Looker Filter Expressions and When Case Stat...
How to create calculated field between two measures in different views?
So, I have two different views, that both have measures “count user ids”, but based on different events: i.e. ...
Custom filter on measure
I have created a parameter using allowed values and a certain range of percentages to select: parameter: param...
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 ...
Measures from separate Views
Hi there,Suppose I have two tables, Revenue and Expenses, where Revenue has a measure named rev, and Expenses ...
Empty map drill overlay modal displaying only proper drill-fields for location-type dimensions
In case anyone else is struggling with this issue, I did not see another thread or any documentation of this e...
Subtracting Two Measures
I am simply trying to subtract two measures: Count of X - Count of Y? This is done easily with a table calcula...
Can I create a Dimension or Measure for the earliest/latest date in a range defined by a user in an explore?
I want to create either a dimension or a measure that will capture the earliest and latest dates in a date ran...
Sum of unique users that...
Hi! Let’s say I have a view looking like the table below. The table shows the Customer id and what store they ...
Drill fields on measures using filters
Hello!I have question related to drill fields on a measure. From my understanding, drill fields will utilize t...
Create custom measure that shows future expected sales
Hi, I am very new to Looker and was wondering if someone could point me in the right direction.I need to creat...
filter-only-field on multiple dimensions
hello everyone, I have the need to apply a filter to a dashboard but it must be hidden, this means no user inp...
Use dimension when creating measure with Case statement
I am trying to create a measure conditionally based on a dimension.My dimensions:dimension_group: date { hidde...
Remove scientific notation for ID fields
Hi, I came across a field that are unique identifiers that have both characters and digits like this: 201220Z0...
Time Intelligence & Comparison: best practice for code modularity
Hi,what is the best practice in terms of code modularity for implementing time intelligence & comparison such ...