Date calculation in format (days/hours/minutes/seconds)
I need to calculate number days between two dates and the result will be return in format of days:hours:minute...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Linking filters cross different explores
Hello,I built a dashboard with visualizations from different explores developped using different lookml models...
Apply a Dashboard Filter to Multiple Explores
I have a LookML dashboard that displays visualizations from 3 different explores. I would like to add a user-d...
Using parameters in aggregate tables
Hi community, We are trying to setup aggregate tables for dashboards that have parameter filters applied. Appa...
Bar chart in Looker
I have plotted a bar chart between profit and date ( date is in strings format) and I basically want this bar ...
Looker filter suggestions disappear
When a dynamic liquid time filter was applied in a derived table, the suggesntions in the filter disappears. P...
Creating custom table with irregular multiple headers in looker dashboard
Hi,I am trying to create custom table with irregular multiple headers in looker dashboard and screenshot for t...
Source/Medium/Channel showing incomplete data
I'm trying to get a breakdown of which channels are bringing visitors to our news posts. The total count is 28...
Convert string to value in Custom Dimension as a Looker End User
As an end user of Looker, how can I convert a custom dimension string to a numeric value so I can aggregate th...
Format durations to less than seconds
I'm trying to create a report for a swimming club, with a pivot table: row dimension = date + swimmer name, co...
Week by Week Comparison
Hello there,I'm trying to create a week to week comparison (Friday to Friday), where I can also filter by e.g....
Retrieve list of filters being applied to a query through Custom Visualization V2
I am building a Custom Vis using the custom_visualizations_v2.I am trying to retrieve a list of current filter...
Sum rows for pie chart with two values
Hi there,I have a dimension with 10 values, but I want to sum 9 of them into a single value to display on a pi...
Using same look in different dashboards
We share some identical tile calculations on different dashboards. Is there a way to link a tile/look to an ex...
Table View Object
Hey There! I have a table view object where I am showing the past 24 months sales by Account but I also have t...
What happens to looks, dashboards if the underlying explore is deleted?
The team I work with has been creating Explores as new versions of existing ones. We were hoping to start dele...
Looker Bar Chart: Create Custom X Labels
A noob query: I have four columns in my data, say, A, B, C, D. I want to count distinct non-null values in eac...
Item coupon dimension not visible in Looker Studio
Hello,I would like to ask you why I can not see dimension of Item Coupon in Looker studio.In GA4 explore repor...
Default Value Filter and Changing Filter Value
Hello, I currently have a filter that's set up as shown in the picture below. It is a date filter, but it is s...
how to calculate the length of months that have passed when i have start date and end date field?
I have data fields: start date and end date. I want to calculate the length of months that have passed using c...
Chart Cross-Filtering Not Working
Hi everyone. For the last couple of days, I've noticed that cross-filtering from charts is not working. When I...
Converting measure columns to dimension in lookml or in explore
Hi All, I've 3 measure columns in BigQuery tables as a,b and c. I want to create a specific dimension as a met...
Table subtotals shows wrong values
Hi,I have tried creating a Table visualization with subtotals enabled. While the subtotals are shown, but the ...
Change date format to mm/dd/yy in Looker
HiCurrently the date is showing as yyyy/mm/dd in a table report. How can I change the format to display as mm/...
Displaying overlapping data labels nicely
Is there a way to display data labels so that they don't overlap? I've enabled overlapping for these data labe...
How to customize color depending on the max number in a column
I want to highlight the max number in a column. Any suggestions please.I have tried rank but unable to use it ...
how to get value for previous month in looker studio?
I have a field in my data that represents number of employees in the end of the month (called ending headcount...
Invalid Total Obtained after addition of a column
I have been attempting to resolve an issue in Google Data Looker Studio. The problem arises when I add a colum...
looker column totals
I have a calculated filed in looker that is using table calculations based off another column.When i select to...
