Calculate Standard Deviation and Percentiles by Country
How can I get a table where I can see the country code, the count of accounts created and the standard deviati...
Forum Posts
Hierarchical Filters
Hello I have a question about having filters affect the results you see in other filters inside of Looker.So f...
Is it possible to create conditional formatting for a daily deadline in time?
I would like my dashboard to highlight items and tell me if a certain time is met on a daily basis. Does anyon...
"Filtering is not supported on SQL tiles"
Hey there!As the title suggests, I saw the following message while editing filters for a dashboard:“Filtering ...
Subtracting two date time
Hi everyone I got an issue, How can I subtract the arrival and depart (date_time) in to deviation (hours) and ...
Concatenete values
Hi,I would like to know how can I create a new field which will concatenete x values (area code) into one stri...
BigQuery Join Google Analytics Datasets for Looker Reports
We have several websites (same website but different topleveldomains) and store the GA360 data in BigQuery. Th...
Looker Filter that can evaluate to more than one condition
I'm trying to create a filter for my dashboard.I need the filter to be able to evaluate to more than one condi...
SQL Runner and dashboard function return different visualization
I want to add “funnel” visualization to my dashboard. I tested the query and visualization under SQL Runner en...
Pivot by 2 fields from 2 different explores
There is a ‘company’ table. This view joins to a ‘content’ dt that includes the number of content that a compa...
Metrics depending on a different dates
Hello Looker community,I am new in this community I want to know how to get the KPIS after one week of the la...
derived_table gcp_billing_export creation failed: SQL Error in CREATE TABLE as SELECT: 404 Not Found GET
I’m trying to work with “Cloud Cost Management: Google Cloud” block. The dashboards are failed to load, the da...
Grouping by Date but can't explain why?
I’ve only been using looker for about a month and have been learning through trial and error so far.I’m really...
Filling in Dates, but not for dates but for integer numbers series in x axis.
Some day someone asked how do I go from here:Missing cases in an integer numbers variable in X-axis are not pl...
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 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...
Timezone Conversion Seems to be Backwards (redshift)
We have a Redshift database set to UTC. When we run a report localized to something like American/Chicago, it ...
Calculate past 6 months based on a date filter
Let’s say i set my dashboard filter to a certain date , i want all my looks to bring in the past 6 months data...
Using a lookup table or Case Statement in Custom Dimensions/Table Calculations
Hello Folks, I have the following requirement. I have a query result that is in this format: Month Number Land...
Bigquery OAuth embed mode 403
team, We are creating embed sso url to view explore. This explore was using database connection to big query u...
Create columns based on other columns with filters applied
Hello,I’m new on looker so please be understanding I’d like to create a dashboard representing a monthly rati...
Can not make a filter on a dashboard
Hi.Using SQL runner, I made views and add them to the project.I made a dashboard but when I click Add filter t...
Concatenate a measure and a table calculation as custom field
I am a complete newbie to Looker (I have been using it for less than week so kindly pardon my ignorance) . I a...
Whitespace in Looker
What is whitespace? Whitespace is a character that will occupy space on a page but does not correspond to a vi...