how to configure a custom email for the alert
Hi! I need to send a custom email for the alert and to make sure there is no data in the email, the same way a...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Custom Reference Line appearing on Wrong Axis
Hi, I am trying to put a Custom reference line on a visualization but it keeps putting it on the right axis ev...
Can not create Views from Tables in Redshift
Can not create Views from Tables in Redshift, get the following:An Error Occurred Loading Tables from "redshif...
SQL Runner and dashboard function return different visualization
I want to add “funnel” visualization to my dashboard. I tested the query and visualization under SQL Runner en...
No "measure type" showing up for custom measure
Hi All -- I am fairly new to Looker and trying to create visualizations that have date dimensions, with measur...
dimension group fiscal year
In user table if we want to create dimension group fiscal year, fiscal quarter and fiscal month num is not wor...
Is there a way to insert widgets for a blank new report?
When I create a new report. Is that possible to insert existing widgets to the report?
Date fill not showing on future months in column visualization
Hello, I have this dashboard tile that shows a measure broken down by month name and pivoted by year. This is ...
Aggregation, calculated field and another aggregation for visualization
Hi nice community people,I have the following look:the sum field is aggregated by Looker the rank field is a c...
Can you set up parent and child looks?
I work in a business that has various teams, which have their own reporting and KPIs, however there is also an...
JIRA vs. Service-Now for Software Project Management
The company that I'm working for is going to start using ServiceNow for its IT operations and call-center mana...
How can I see all the available databases.
I have been given access to the data through the looker portal, however the company hasn’t given me a list of ...
Display months as words instead of numbers
I am currently trying to display Months in a word format instead of a number format for a tile. Above is what ...
Could not find the model or view requested when Development mode turned on
Hi, Im able to see the explore when i turn the Development mode off, but when i turn on the Development mode o...
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...
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 ...
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...
