Does `sql_trigger` work for data groups used normal explores?
Does `sql_trigger` work for data groups used in normal explores, or just PDTs?For a normal explore (not a PDT)...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Invalid expression: Expression incomplete error
I'm trying to write a simple case statement in custom dimension but I'm getting Invalid expression: Expression...
'Reset Filters' button doesn't bring back all available value options
I have several filters in the dashboard that listen to each other.Meaning, when there’s a selection made in on...
Looker reports missing table column data
HiI am compiling reports for co workers but for some reason the columns are re-sizing and resulting in missing...
How to format text tiles in dashboards-next similar to old dashboards?
Anyone has any idea how to achieve the same look from the old dashboards with dashboards-next for text tiles?I...
Icon not showing up in Boards
I am trying to put icons in text tile using font awesome code and pinning that dashboard into the board. when ...
Implementing Tabs2 Component
Hey all,So my team has been looking into the Tabs2 component at this resource.Based on the examples, I origina...
[Marketplace Visualization] Can Marketplace viz transfer my data to third-party?
ContextI am interested in installing the radial gauge visualization (link) from the marketplace.QuestionHow ca...
[Compliance - Marketplace Visualizations] Can Marketplace visualizations transfer my data to third-parties?
ContextI am interested in installing the radial gauge visualization (link) from the marketplace.QuestionHow ca...
Shades of Colors based on measure values
I Have a top 10 chart and all the values have only green as a color. I want to display different shades of gre...
Cross Filter overwrite existing filter
Hi, Is it possible for a cross filter to overwrite an existing dashboard filter.For Ex if i have a date filter...
How to get counts
I have records that have a field called `Compliance Framework` which can be [x,y,z,other]. I want to get a cou...
Filter BEFORE aggregating
Please share a link if I’ve missed this somewhere… can’t find the answer. Seems like a pretty basic need/quest...
Custom Fields - Creating a rank column based on earliest date when at specific point
Good day,I work in shipping and logistics. I’m looking to create a column showing a rank (1,2,3...) based on t...
count table calculation
Hi.how to count table calculation (MonthDiff) ?..MonthDiff is datediff(maxtrxbooking, Now())i want to show lik...
combining duplicate rows and sum up
Hi, I was wondering if there is a similar function as Pivot Table on Looker? Which would allow me to aggregate...
Compare this year's revenue totals to last year
Hello. I have a stacked bar graph showing my client’s total revenue, backlog and pipeline amounts per month (2...
concat 2 date columns
i need you help here, i concat 2 columns start date hour and start minutes , but the problem iis that m gettin...
Field removed from LookML stays in the "sorts" parameter of the tile
This may be a tiny bug but it shows up in the Content Validator, hence this post.If you remove a field from yo...
Rendered value from dimension value in single value tile not working anymore?
Rendered value from dimension value in single value tile not working anymore?
We have two time filters one for event time and one for user start time. Is it possible to have user update one of the time filters and the other time filter is set to the same time range?
We have two time filters one for event time and one for user start time. Is it possible to have user update on...
Looking (no pun intended) to figure out a way for a date ranger filter to only affect the numerator of a measure that divides two other measures?
As of now the filter affects both the numerator and denominator when I apply the filter to the tile that has t...
How to get null values sorted to bottom?
I’m trying to sort a table in explore in descending order from a column. The problem is that the Null values a...
How to make a date ranger filter in dashboard only affect the numerator of a measure used in its own tile that divides two other measures?
As of now the filter affects both the numerator and denominator when I apply the filter to the tile that has t...
Dashboard with 2 pages
Hi Team,I am working on PowerBI report migration into the looker. PowerBI has a capability of having multiple ...
Dashboard: how to define consistent filters (i.e., filters cross-filtering)
Scenario:migrating from PBI to Looker and building my first Looker dashboardIssue:Added two filters in my Dash...
Copying and pasting visuals
Are there any tips / best practices around copying visuals from Looker and pasting in external docs like power...
Cross filtering by selecting a field in table chart
Hi,I am trying out cross filtering functionality by selecting a value from one of the field in a table chart.T...
Can multiple users live edit a dashboard at once?
Hello,Similar to a google doc, can multiple user live edit a dashboard at once?
Multiple graphic in a single tile
I’m trying to create a tile with multiple elements on a single tile:Multiple elements on single tile
