Show multiple lines in line chart
I have the data like this-date| product| priceI want to plot the prices of the products datewise on a linechar...
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
LookML error: could not find a field 'nbfc_name'
Here is the code snippet. I m unable to figure out why it throws this error even when the field is present. vi...
User Attribute in Manifest
Does anybody know if it is possible to use an user attribute in the manifest of a project? I need to use the u...
Bigquery and Looker tables not synched
Recent modifications were made to our google bigquery tables but I don't see the modifications in my looker ta...
Location Calculation without Studio or LookML
Is there a way to calculate distance between two points without Studio or LookML, just an expression generated...
Facebook Ads from Fivetran
Hi. I just discovered the Facebook Ads block in Marketplace, and wanted to try it out by setting up the Fivetr...
Crazy average value on measure
Looker is generating a crazy average SQL and I don't understand why. In my view, I have a number field which r...
Conversions count error
Looker Studio is connected to Analytics 4 property. Looker Studio dashboard shows all data except data for Con...
Table calculation (division) is showing a wrong result
Hi Looker team,I’ve set up a metric in Looker Studio called ROI = (x - y) / yThe result is wrong, i.e. In the ...
LookML concatenation with space in between fields
Trying to concatenate dimensions and separate them with a space or dash but when I add in the character the ne...
dimension_group Automatic Label Suffix
Using a dimension_group of type time, Looker automatically appends “Date” to the label. For example, given the...
Link a Dashboard to another one passing values
Hi all!I have a dashboard with some information on a grid (Project info); my goal is to click on a value in a ...
Tooltip clipped
I have a dimension with a link and an html tag to add a tooltip as follows. dimension: price { type: number va...
Advanced Date Filtering
Hello y’allI am currently trying to find my way around the advanced date filtering, and struggling to find a s...
Pass date filter using liquid variables in html
Hello… hoping you can advise. I’m trying to pass multiple dashboard filters including a “date range” filter to...
Dynamic Timeframe option
I need to create a custom option in the timeframes drop down menu that will vary depending on the user. For ex...
Dashboard Button link to get filter values and auto-apply in Look
Could you help me with one tricky functionality I am trying to implement in Looker.Let me provide the backgrou...
Looker Over Complex Queries
Hi, I'm having an issue right now in looker where I have an explore based on one table let's just call it "amo...
Liquid: number_with_delimiter not working
Hi, am new to Looker and I am trying to use liquid for some advanced conditional formating but it seems to me ...
Uniqueness test generates wrong SQL with count(distinct)
I have a model, where videos is main table, with playbacks joined to it. Each playback has playback_key (set a...
Difficulty Formatting Percentage Values in Looker Visualizations
Hello,I'm encountering an issue with percentage formatting in Looker visualizations. I have defined a measure ...
How to convert number to time in looker
Hello Team,I am query regarding how to convert measure with number data type to time data type in the form of ...
Google Looker actions
I'm attempting to create a dimension based on the value generated by a HTTP request. After some research, it s...
liquid with drill_fields
Hi, Im trying to achieve something along the lines of the following. I want to display a different set of deta...
New LookML breaks cell HTML colour format
Problem: in 19 days, a Looker upgrade will be performed in my instance, and the HTML/Liquid rendering for heat...
Download PDF reports limits the rows
When downloading a report as .pdf, we select download and it does download only what’s visible in the UI. it d...
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 ...
