compare the sum
Hello! I want to do a simple thing:I have Columns "women" and "men". I want to compare the sum of numbers in t...
Forum Posts
Totals in merged queries results
Hi all, I know it's not possible to add totals to a pivoted merged queries result but I wonder if anyone has y...
Not able to see the filters in Explore in Edit Mode
I have a dashboard, In which i have 4 looks. I was asked to apply a date filter on it. When I added, it worked...
Not able to see the views on Explore
Hi All, I have 2 views. When i go to looker -> develop -> then these views are visible to me. But, when I go t...
How to create a measure in LookML based on different views/explorers
I have created two views from a table with some implemented measures. It's something basic, illustrated as fol...
Creating a dimension % of a total
I have categories of revenue loss as dimensions per month with their monthly value, and I need to calculate th...
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...
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...
Location Calculation without Studio or LookML
Is there a way to calculate distance between two points without Studio or LookML, just an expression generated...
Comparison table in ga4
I want to create a table in looker similar to the comparison table in ga4, but I don't know exactly how. If th...
templates for looker studio
Hi, i hope you are well. Does anyone know if there is a website where I can get nice looker templates for ga4 ...
Doubt with conditional filter
Hello everyoneNew with Looker and following some of the Labs available. In one of them we need to create a con...
Show custom message for empty resultset
When there is empty resultset for the looks in the dashboard, how to show a custom message instead of "No resu...
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...
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...
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...
custom table calculation function
Hi,We are doing a lot of calculations with Looker outputs.Recently we're doing AB testings.I want to create cu...
String to date conversion on looker custom filter
Hi everyone, Am trying to make a custom measure and adding some custom filters for counting a measure as follo...
idiom problems
im triying to make a report and im working in english but when my boss uploaded the report in our page (where ...
One Measure as pivot data one measure as Unpivot( single) data
view: my_view {measure: revenue {type: sumsql: ${TABLE}.revenue ;;}dimension: category {type: stringsql: ${TAB...
Filtering percentages
Hi all, I was wondering if there is a solution to filtering a metric which has a data type equal to 'percent'....
Calculating % relative to Total with Multiple Filters in Different Tables
Hello, I need to use the total from one chart in another chart to calculate the % of each data point relative ...
I'm trying to calculate the percentage, COUNT(ABC) when Filter = "xyz" / Count(ABC) with no filter
Hi,I'm trying to calculate the Counts and Percentages in a table.Filter: Field contains "xyz"Count(ABC), Perce...
Customization in Looker Studio Visualization
I've started using Looker Studio and wondered if we could have time-based visualizations like timeplot or scat...
MERGE ERROR GOOGLE SHEETS SQL SERVER
Hello everyone, I was trying to combine data from two data sources, the first one comes form SQL Server, and t...
Dimension to Handle Array Type data in Lookml
Hi,I have a table >500B rows. DBA has put a rule that the table can only be queried with a where condition on ...
[Analytics Block] LLMs in LookML
Do you want to enable your Looker users to leverage large language models on your text data? This analytic blo...