Qualify in LookML
Hi All,I am wondering if there any way to filter on row_number window function in Looker or using LookML. I am...
Forum Posts
Implement vertical "writing-mode" in Looker "Table" visualisation
Hi,I wonder any expert out here can help me please.I have a tabular report in Looker that has one pivoted dime...
Custom relative drill link to other Look not opening in dril modal
According to the documentation, using relative links in a LookML link parameter should open the link in a pop-...
Calculating average across two views in looker when dealing with timestamp difference
I am working with a data where I need to calculate the difference and average of when a user is created and co...
Hierarchy of User Attributes and Access Filters to access more or less in dashboards off 1 Explore
Hello,I need help trying to approach accessing different user attribute data across dashboards for a single ex...
How to add a YTD running total measure on a month report ?
I am trying to include in a report that contains data from previous month, a running total for the year. For e...
Is this a bug on Visualization ?
In Looker while i created a report adding Dim & Measures , the graph stack size are wrong , if you see y axis ...
Grouping dimensions using 'case when' grouping users lookml code.
Please help. For context, 1 user can have multiple generations of a product. Generation 1Generation 2Generatio...
Datagroups Deleted Overnight
Hi, it looks like our Datagroups were deleted overnight. Anyone else experiencing this? Also it seems like our...
SQL Error: 0 when scheduling looks to google sheets
Hi All,I have created a look (that has pivoted date columns) that I have scheduled to update google sheets. Af...
Using Looker to send data to analytics
Hi everyone, I’m fairly new to Looker and I’ve been looking for info about this for a few days, and I don’t re...
How to compare current quarter to same quarter last year?
I’m trying to show how we are performing in this current quarter to the same quarter last year, but have not f...
Filter a Column using wildcards and LIKE
Hi,Filter a column based on wild card characters. I want to filter values ending with ‘ABC’ from Col A in View...
Autoscale enable for Looker
Need Autoscale for Looker,
Setting height of the Look to fit contents in Custom Visualization
I created a Custom Visualization within a Look.I am not able to set the height of the Look so that entire cont...
How to find differences week over week?
Hi! Apologies if this has been asked before - I’m having a hard time figuring out even what question to ask.I’...
Downloading Visualizations in Excel
After creating a Dashboard, I tried to download one of my visualizations(Line Chart) in Excel format but it do...
Creating a field that captures the earliest value from a set of rows
Hi Good Lookers! I'm trying to create a new dimension that extracts the earliest year from a date field associ...
Exceeding URL row limit
It seems that URL links only offer up to 1000 rows regardless of the initial row limit set within Looker, anyw...
Definitions of grouping functions using Group function
Does anyone know the exact definitions of these conditions using the “Group By” function on the front end of l...
There was a problem running the query
I have been getting this error in a Look . I narrowed it down to one particular field , but the same field wor...
Check if an array is empty
I have a table user_list_data with two columns, user_id and portfolio. For instance:user_id | portfolio1 | {1,...
How to calculate YTD,MTD ,LYYTD and Cumulative calculations in Looker?
Hi All,Could you please let me know How to calculate” YTD,MTD ,LYYTD and Cumulative “calculations in Looker?Pl...
DropDown in Looker
Hi All,Can anyone will please help me understand that is there any option available in looker by which we can ...
Blach borders for Tile
Can we put black borders for each and every Tile?
Creating Another Dimension Value Dependent on Other Values of the Same Dimension
Hey all,I’m trying to create another value of a dimension that would involve a calculation among other values ...
Applying dynamic filters on Links as Drilldowns
Using the [drill_fields] feature to apply a Drill Down into the data is great but it’s missing some key featur...
caculate cumulative total month by month every year since 2010
Hello,Please I want to create a dashboard calculate :the turnover month by month and the cumulative total of t...
Show Total regardless of any selections/filters
HI All,I need to show the Total Sales and the total sales should be shown always even when we filter using any...
How to calculate Sum of averages for different level of detail?
We have information in a table with Sales by Invoice ID which is mapped to a Location and Area. Like below:Inv...