Calculating the % of a pivot index group
Hello! I am trying to do:Calculate the sum of column 1, 2 and 3 Take nulls into account Calculate column 1 as ...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Can values with Magnitude be formatted to show more digits in Explore?
I’m trying to find a way to turn values that are displayed with Magnitudes (K, M, B etc) into regular values w...
Sorting Looker Schedules
Does anyone know if there is a suggestion/improvement idea been raised to be able to sort/re-order the list of...
Creating a slider that changes data
Hello,I’ve to show data on a map with a 96 hour history shown by an interactive slider. When you scroll the sl...
Convert date to first day of the week
Hi Looker users and experts, I have a drop out date which is a random day in the week that i want adjust to th...
Need to center column titles in my table
Hi All,I’ve built a couple looks for my dashboard, however, the column titles are indented to the right instea...
Last 24 hours
Hey Everyone, I am getting live data ,every minute data getting updated. I want to show some reporting numbers...
Calculated Field: does date fall within start/exit date?
I am trying to create a calculated field that will flag if a service date falls outside the enrollment range (...
Access and filter a dashboard using a button in an external software as hubspot.
I need your help to know if it is possible to access and filter a dashboard using a button in an external soft...
count of each customers' first purchase
Hi All,I need to count the total first purchasing activity of the customers according to their countries (coun...
Automatically Pulling Looker Data To Google Sheet
Hello all, Does anyone know how I could go about automatically extracting data from looker and importing it in...
Filters Not Populating Suggestions in Dashboard (BigQuery based data)
I am new to Looker.I have a partitioned BigQuery connection to Looker.Due to this there is a required date fil...
Call looks library in different folders
Hello,I am willing to build a look library.This set of looks aims to be attached to two dashboards which are i...
Table-Next Updates?
I understand that Table-Next is being actively worked on by the Looker team (I hope). There’s still basic func...
Why does visualization open/load first when viewing a look?
Hi, I’ve noticed that when I open a saved look or dashboard, the visualization is the first thing to load/open...
Ranks with Table Calculations
It’s tempting to create a “top 10” style report and call it quits, often times it is more useful to understand...
Add Drill Down to Calculated field based off multiple measures
Hey there everyone,I am tryin got be able to drill down from a KPI percentage that uses two measures. As far a...
Copying Dashboard from My folder to Shared folder
Hi,Please let me know how to just copy only Dashboard (not looks) from My folder to Shared folderWhen I try to...
Simplify table calculation
Hello! I need an idea on simplify a table calculation to reduce unnecessary steps. For instance: 1+1*(${to_kin...
Add domain name in alerts
I am trying to setup a alert for a list of domains when there is a change in usage by 30% or more. The alerts ...
How to put value in donut chart
Is it at all possible to get text inside a donut chart? If it can’t happen with the simple Looker visualizatio...
How to get a date filter from a static custom date to today?
For a date filter I want keep the default date range from a custom date till current date.Example : 1/1/2022 -...
How to get custom number of rows in a column which is filtered by another column
Hi,I have the data in the following format.I need it sorted into this format.The format is topic should be sor...
Convert UK Postcodes to Postcode Areas
Hello!I am wanting to visualise sales in the UK on a map. Based on documentation, Looker allows for Postcode A...
Australia, New Zealand Map Layers
Hello, How can I access/ build/ integrate map layers for countries other than the US, e.g., Australia / New Ze...
Make chart to show same metric at different level
Hello,I am just wondering is it possible to create a chart in Looker which is about same metric but at differe...
Limit dropdown options of type: field_filter using LookML codes
Hi, I would like to know how can I change my default drop down for the filter Control : Advanced. There is a c...
Calculated column aggregation
Hello experts!I made a calculated field with if( some column <5, "NB", "B") and would like to see aggregated r...
How to use single value tiles for calculation?
HiI have a Title with Moth to date spend, another with Days left of the month, and a 3rd one with avg daily sp...
