Could not load Model " " when trying to access Table/View from Explore
Hi,I am trying to access Table/View from Explore. However, getting the following message. Could not load Model...
Forum Posts
Hide Column in PIVOT Table Chart
Hi,I want to hide both “Order Items Shipped Date” and “Order Items Count” as highlighted in Table Chart (two d...
Looker expression editor _ subtraction by pivot rows (sum by grouped dimensions, then subtract)
Hi,I am new to Looker, not sure if it is possible using Looker expression editor to achieve this (I cannot use...
First Unnest then Join
Dear Looker Community,I stuck with a problem and need your help.I have an explore (“client_info”), which keeps...
Add milliseconds to DateTime within Explore Custom Dimension
I’m trying to do something like this within an Explore Custom Dimension:add_milliseconds( ${Hits.HitTime} ,${S...
Custom Filter Using "OR" logic
How can I limit rows returned in an explore to satisfy the below business need?For any order series ID,If that...
Merge result like a model?
Could I consume a merge result like a model?I want to hide the key dimension of the visual and group by anothe...
About checking the page indicators included in the content group of Looker Studio
We have created a content group using the {{Page Path}} regular expression condition in GA4 (GTM).So, we have ...
Date Filer Show only select operators
I have a date filter. Is it possible to show ONLY the following instead of all available:Is in the last Is in ...
Calculating annualized attrition
How to create a calculated field for “Annualized Attrition” in Looker Studio. Any help will be highly apprecia...
Annotations in Charts
Caveat: This has only been tested for Line and Bar charts. Not all chart types allow the vis config customizat...
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 ...
Mandatory Filter
Hi, I want to use column Country as a filter for the Dashboard like this: every time a user opens the dashboar...
Download filters along with results
Hi,I have a requirement where I need to download the filters applied along with the results. Could not find a ...
Is atomfashion.io source code is available in github
Is there any code which replicates atomfashion.io is available / hosted on github (or any git cloud provider) ...
number to string custom dimension?
new to looker and migrating reports from oracle bi and a whole new learning experience...I have a numeric fiel...
Rank with a Filter (table calculation)
I have a list of SKUs, the Product Category each SKU belongs in, and each SKU’s Order Count. I’d like to make ...
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...
dimension group fiscal year
In user table if we want to create dimension group fiscal year, fiscal quarter and fiscal month num is not wor...
Median by Day for multiple records
I am new to Looker and I am trying to show the median value by day. If I have the following data, how would I ...
No Up/down color options on Waterfall chart
Hi!I’m not able to set the colors of Up, down and total bars on a Waterfall chart.There’s nothing to click, an...
How to get a list of dashboards or looks that use an explore
How do I get a list of dashboards or looks that use a specific explore? I would like to modify an explore and ...
How to stop Chi-Squared function from using null values?
I would like to utilize the chi-squared built-in function to get p-values for each experiment (pivoted, in thi...
Change dashboard source view
Currently I have a dashboard built on a view (lets say V1). Now due to logic change I had to create another vi...
[Custom Field] Extracting key pay from a field
Hello,I am trying to create a custom field that extract data from a field (assuming the field is called “my_in...
Running total start is the total sum before filter
Hi Guys,So I’m creating a running total field.I have data between 2010 -2020.I want to show the sum(sales) and...
Creating an explore with monthly aggregation checking if a client left by current clients
Hi Guys,I’m trying to create a stacked bar chart that is monthly aggregated.I have the following colums : star...
Limitting user / user group access only to a perticular model
how do i make sure a user or a user group is limited to one single model in the whole project like accounting ...
Custom Dimensions - Bins show decimal point with integers
The data is of integer type but creating Custom Dimension Bins still shows a redundant 0 after the decimal poi...
% of total count when rows are not exclusive, and there's a pivot
I’m trying to build a visualisation to show the number of customers that have enabled a certain feature.There ...