I am looking to create a Calendar
i wanna create a calendar con i can visualize the time off of my employees, is it posible on looker?in a calen...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Inaccessible view user_mini-session referenced in retention
Hi, I am having some issues referencing a dimension from one view into another. (unable to post without the sp...
Using Liquid variables with sql
I built a parameter and a measure which run SQL from a joined view, but when I run it in Explore, I get an err...
Required Dimension in Explore
I’m building an explore that will be used for a very specific purpose, and because of this there are certain d...
Which would be the best 3D modelling software available in the market?
I am currently pursuing Robotics Engg. I had question in my mind that, which would be the best 3D modeling sof...
Is it possible to have multiple select option for Parameter filter in dynamic measures
I want to know if there is a way to multi select revenue and order count at the same time and see data.Sample ...
How to determine when Query Performance issues are caused by Database Bottlenecks/Settings?
There are many factors that contribute to slow Query Performance in the Looker application, one of the most co...
Manage auto refresh for a report doesnt work
I use Google Analytics Pro and I can't find the auto refresh featureIt does not exist under recourse
Best practises for Total metrics in datasets
Hi, i am just wondering what is your opinion about including TOTAL metrics in a dataset.I have a dataset that ...
dynamic hyperlink
Hi, is it possible to create a dynamic hyperlink that opens a new report and updates two different data sourc...
How to keep Bigquery Structs
Hi everyone,I have some tables in BigQuery with Structs (nested data); for example, I may have 5 rows with the...
Updating the view does not update dashboard
I have a dashboard which has a tile built from "ABC" view. I wanted to make some column name changes, so I upd...
percent_of_total Question
From the docs: “percent_of_total calculates a cell’s portion of the column total. The percentage is calculated...
Is it possible to rename fields when joining a view to a explore?
I would want to rename a field when doing the join of a view into a explore, to have a more descriptive name f...
"Error switching into Development Mode" message
I have the developer role on a Looker Instance. I can see the project and its associated LookML in read only m...
Is there a way to view LookML Dashboard usage?
Anyone know if there is a way to track usage/views/queries of LookML dashboards either directly or indirectly?...
Using LIKE operator for parameter in derived table
It's similar to this thread https://www.googlecloudcommunity.com/gc/Modeling/Using-LIKE-operator-and-wildcards...
Displaying null values in sums
Looker Coalesces by Default By default, Looker coalesces sum measures with zero. This gives us a nice “0” disp...
Potential bug in dimension type: date filter due to obligatory TIMESTAMP conversion
when using a dimension of type date,dimension: utc_created_date {type: datesql: ${TABLE}.utc_created_date ;;de...
Problem triggering Cloud Functions with Looker Actions
Hello everyone,I spent the last two days trying to figure out how to trigger a Cloud Function from Looker.I ha...
Merge Queries
Hey,We are trying to do a merge query but it isn't producing any results. We are joining the explores on an ID...
Slider Parameter
HI there,I am trying to create a slider style parameter. So in the slider I need a range of values, say 0 to 1...
Convert text to Date
Hi i have a google sheet that is the data source for looker. One of the dates is inthe following format - 11/2...
Currency Conversion Parameter and Formatting
It’s common to want to switch between currencies in Looker. This is usually achieved by having your results/ta...
Not able to create a project in Looker despite Admin Role
Hi Team,I have admin role in Looker. But when I try to create a new Looker project, I encounter Looker access ...
How to convert time duration(Ex.. like 1d 5h 12m 25s from 55678900 seconds )
Hi,i am a looker developer i need to create one look.i have a dimension called duration,dimension: duration{ty...
Order of displayed filters
Is there a way to specify the order of the filters displayed in dashboards?Ex: I have a filter on countries. A...
Drill Down Issue
I am trying to create a collection of fields for drilling down in an explore and hitting an issue. I have an e...
How to display text string with html tags as html
I have a simple string dimension that contains html tags. When I display in Looker it treats the dimension as ...
