Using table calculation functions and operators to create window functions
Not directly - however, you can create window functions by using some complicated table calculation formulas w...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Need to calculate a column average - please help!
End Goal: Compare Q4 rep averages to Q1 rep averages in 3 specific columns. This seems like it should be so si...
Is there a way to get a list of all reports based on a particular explore?
Hi all,We have a view file undergoing some changes and want to identify all reports built on that view.Luckily...
Parameters & Filters - Dynamically changing default date to latest available date
Hi all,Could you please let me know if there is any way to show the filter/parameter value at top of the Looke...
As close as you can get to a Bullet Graph with Looker's out of the box charts (Actual vs Target)
Hello there Looker community! I’ve been building bullet-like graphs for quite a lot of clients so I thought I’...
Creating a running total across rows with table calculations
You can create a running total across rows with table calculations using the pivot_offset function. You can al...
How do you tell people what tiles are affected by dashboard filters?
Hey guys! As the title suggests, our team is struggling to find an easy and maintainable way of communicating ...
Stacked bars comparison in the same chart?
Hi - I’m looking to represent a comparison between current and previous year for stacked bars. Is this possibl...
Dashboard layout type "grid" is not supported.
Hello everyone,I’m new to Looker, and I was trying to use a Block from the marketplace. Everything worked perf...
Single record table padding
Looks like there’s some padding missing. It’s really close to the edge:
Migrate Looker Dashboard from Dev environment to QA environment
Move Looker Dashboard to a New Looker Instance
Remove duplicate rows from table
I have a query that shows collaboration between two organizations that i need to display in a table. The probl...
How to provide individual access on dashboard in same folder
I have 25 looks created from an explore. now i want to create 5 dashboards for different level of people in th...
Targeted Individuals - Scheduled Report
Need to send a report to targeted people within the scheduled report email listWHERE the data has changed sinc...
How to create a stacked donut chart?
I’m looking to create a dashboard like this in table. How would I do this?
Is there any date range(start date - enddate) dashboard filter? Couldn't find it in the control dropdown of the filters. Can someone please help me out?!!
Is there any way to create a start date - end date range filter on top of the dashboard?
Sorting on column which uses offset
I have a dataset as follows, i’m using offset to create a subtotal of PSI, called Total PSI, and then i want t...
Transpose doesn't honour the order of columns
Two great things came to Looker last year: transpose and ability to change the order of column in next-table v...
Filters with Hyperlink
Hi All,New to looker, just curious to know if there is any way to have dimension values with link in Filter.Us...
Metrics depending on a different dates
Hello Looker community,I am new in this community I want to know how to get the KPIS after one week of the la...
Anyone still frustrated with Table-Next?
Hi,I’m curious if we’re the only ones that find Table-Next to be endlessly frustrating and constantly revert b...
Format txt invalid error when trying to schedule a Dashboard format csv zip
If a user schedules a Dashboard with the format option CSV zip file, the schedule errors with message: Error m...
Quotation marks in Custom Fields?
Hello! I hope that you are well today. Does anyone know if there is a way to add quotation marks into Custom f...
Export as Excel with Pivots
I viewed the report as a Table Report and displayed the measures at the top. However, when I download it as Ex...
How to adding (and display) a fixed value (constant) table calculation
I am trying to display a fixed value table calculation to an existing combination chart (column and line).I ha...
Conditional Colors for points on a map
Looker documentation says "you can set the color of map points or define the range of colors to be used if you...
Using the Table Viz to generate an hourly heat map
I’m trying to recreate the following viz - A heat map of the hourly number of events. I used the table viz to ...
Value format not working
I have been trying to apply value format to my Looks but they are not working as I expected.In this picture th...
Button Group Inline filter options disappeared
Hi!I’ve set up a dashboard with a few filters but some of them are gone now.I’ve tried deleting and add new on...
Button Toggle Filter bug
Hey Looker Staff! It seems there is a bug on the dashboard-next when using the button toggles filter type. Whe...
