Calculated field - concatenate and preserve date format
Hi there,I could use help with what I hoped was a simple calculated field. My source data has 4 separate End D...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Help aggregating data
I currently have a chart that displays the count of tickets by reporter (employee) tenure and another one that...
How create multiselection filter based in parameter?
How I can create multiselection filter based in parameter. Because when we creating a parameter and want to im...
Totals labels overlap series labels
Simple visualisation of stacked area chart and when Totals Labels are enabled they are positioned in exactly t...
How to carry one Dashboard filter to another Dashboard to apply the filter on target dashboard ?
Hi buddies....Here my question is 'How to carry one Dashboard filter to another Dashboard to apply the filter ...
How many ways can we create a view in the project
Hello buddies Im new to this looker BI platform. My question is how many ways we can create a view in the proj...
how to apply a filter to a single tile in the dashboard
Hi every one ....im new to this looker BI platform, presently am learning looker BI .MY QUESTION is how to app...
Discrepancies when viewing LookML dashboard vs the actual LookML
Banging my head against the wall with an imported project issue and I’m hoping someone can point out something...
Dashboard Link not in Alert message on Slack
Hello, I implemented some alerts on a Looker dashboard which send a message to a Slack channel if the conditio...
Filtering that has one selection but works like a contains
I have a table and each viewer has permissions based (user_attribute) on dimension Business Group.The dimensio...
How do I pre-populate a dashboard filter with user_attribute['email'], but using ‘contains’ logic?
We have a dimension in a model that reflects an employee’s management chain, all the way to the CEO. ceo@compa...
Adding Picture to the Dashboard
Follow the steps to Add the picture on the Dashboard Add text tile In the Body of the text tile add the plain ...
Implementing global changes to default chart lines in project
Hello :),A more advanced appearance of the chart line visualization can be modified by editing the chart confi...
Running sum when some periods have 0
I am trying to use a running sum on my time series chart. As you can see in the attached image there are some ...
create custom filter using custom measures
hi, i have 2 measures, for example total sales and total revenuei want to filter out users by trying different...
sv"add look to dashboard" button greyed out
hey guys!i'm trying to add look-linked tiles to my dashboard, but the "add look to dashboard" button is greyed...
How can i blend Search Ads 360 with Google Ads on Looker Studio
Hi Guys, I have connected 2 data sources on Looker Studio. These are Search Ads 360 and Google Ads. I wanted t...
if() statement no longer working. Anything wrong on my end?
Hi, I've had a report with a dimension (if() statement) that's been working fine for the past year until today...
Looker Table Calculation - IF statement
Hi all, I m trying to add a table calculation using the If statement. I have a column that displays the belowa...
Using a field from one view as a display filter but using another field to filter
Hi,The issue is we have a view called t_trade_product that contains the following:dimension: product_code {typ...
Custom Date Dimension
I’m trying to take a date field 2021-03-01 (as an example) and turn it into a custom dimension that would be 2...
Formatting in tables with subtotal
It is going to be able to use fomatting in tables with subtotal someday?Formatting is very important to highli...
Time series chart and total
Hi,this data comes from GA360 product gategory dimension. What would be best way to have total line also inclu...
Aggregation: Sum of count_distinct type measure
I am trying to create a measure of type count_distinct and I want to use it in another measure using type sum....
Include Filters Selected in Download to Excel or CSV
Hello,I’m quiet new to Looker. Does anyone know if its possible in Looker to include the Filters values select...
Linking dashboard filters from different views
The problem statement is to link dashboard filters from different views. When I link filters from same view, t...
creating board to calculate delta using two separate date range filters
In Looker we are trying to calculate a delta for a number of different fields between a test group and a contr...
I Want to have two measures under one column.
Internatiornal Clients#%I want to have two measures Under International clients, One which gives the count and...
Filter based on condition
Hi,I am trying to build a dashboard with multiple tiles, where they are related. The expectation is, when any ...
Limitations on Display Count
Hi,I have been trying to develop a dashboard with a table chart. I observed that after 5000 records, it does n...
