Fix dashboard filter
Hi, I need to add a filter_x when the user select any other filter in a field. For example , if the user selec...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
post merge query aggregation
Hello. I merged two queries with date, ID1and ID2. Now, I hide the ID1 and ID2 from visualization and I want t...
Table Calculation: Custom Expression Help
I keep getting expression incomplete. I am stuck. concat(if(min(${reporting_date_month}) = 1, "January",if(min...
Bug - Y-axis density marks and labels
Working with exchange rates. We know their % change is quite small and most of the graphs are rendered correct...
Jira dashboard organization
I am doing automation on over ten products. In jira I am using Kanban style workflow where there is no sprint ...
New dashboards (beta) HTML options
The clever @brecht discovered some new HTML functionality available in the Dashboards (beta). I figured I’d sh...
How to create star rating from numeric value using HTML and Liquid
Hi fellow Lookers,In this post, I want to share my solution and highlight some issues when creating a star rat...
Advanced date filtering - prior day appears in results
I’m using the advanced date filter to select absolute number of days from a specific date. In the documentatio...
Median by Day for multiple records
I am new to Looker and I am trying to show the median value by day. If I have the following data, how would I ...
How to main a Ordering in Custom Group
I have created a custom group as shown above("< $1","$1 - $1.25" etc) while displaying I want it to sort by th...
Concern related to data refresh connection between Looker and React JS UI/UX dashboard
Hi AllHope you're doing good !I have a question related to Looker and I believe you can sort it out .I am usin...
Calculated Single Value Chart based on User Input
Gretings!I need to create a comission indicator inside a dashboard. The comission value will be sum of sales *...
Returning name of top customer per group
Hi, I have some data with Date, Product type (chairs, tables), Customer Name, Order Sum From this I want to cr...
Advanced filter - starts with a certain pattern of letters and numbers
We need to filter a look by a specific account number pattern: it starts with the letter H and then is followi...
Limiting the number of occurences in a dimension?
I have a dimension column for each month in the year (2022-01, etc.) and two other other columns, one being a ...
How do you group a list and count each user on the list from 2 separate columns?
HelloJust as an FYI, I cannot use LookML. I am forced to stick with custom filters/dimensions/measures/table c...
No Up/down color options on Waterfall chart
Hi!I’m not able to set the colors of Up, down and total bars on a Waterfall chart.There’s nothing to click, an...
Add a Single Value visual on top of another visual
Hello,Is it possible to add a single value visualization on top of an existing chart, for example a column cha...
Filtering Filter Values
Hi,I am trying to add a filter to a dashboard, but I want to limit this filter by another dimension. e.g. I ha...
Can we limit the number of tiles in a dashboard?
It is suggested here to keep the number of tiles in a dashboard to 25 and under. Is there a way to prevent use...
Automagic Heatmap and row limits
Hi! The automagic heatmap tool has been changing a bit recently, so wanted to see if I could clarify some thin...
Line Chart Visualisation + Next-gen Dashboards - Limit of data points?
I have a simple query where I removed the 500 row limit:In the screenshot above you can see 1972 data points. ...
Table Visualisation + HTML parameter + new line
Turns out if you have text you want to show with line breaks:Is not rendered correctly in the next-gen/new/cur...
Word limit in custom message for scheduling
While scheduling a dashboard in the custom message field (Advanced option). Do we have the word limit?
How to get a list of dashboards or looks used by a specific explore -
Whats the timeframe on when the looks and dashboards are given in this list. It seems like new looks/dashboard...
How to get a list of dashboards or looks that use an explore
How do I get a list of dashboards or looks that use a specific explore? I would like to modify an explore and ...
Formatting for totals row replicates the LookML on the data section of the explore but doesn't transfer to the viz section
HelloWe’re having an issue with the formatting of the Totals row when we select this option on the data part o...
Creating a bar chart from a merged query
Hello,Is it possible to create a stacked bar chart from a merged query if the two dimensions I want to use are...
Export PDF blocked by VisualizationError: The x-axis settings for this visualization have filtered out all rows.
Is there a way to get around this error that will allow me to download the dashboard (as a PDF) that this look...
Freeze Headers in a Table Visualization
I have a requirement where I want to freeze the headers of my table visualization ,as after a certain amount o...
