connection issue
Cannot connect: time zone tables don't appear to be loaded JDBC string: jdbc:mysql://14.97.218.174:2300/uc_dat...
Forum Posts
one fact table with multiple dates
Hi, I am working on a project that we have some questions about.The project works as a star schema, we have on...
Creating a custom Date dimension in Looker Studio
Hello, I’ve been dealing with an issue when blending data from two different Google Analytics Universal views ...
Remove last 3 characters from a string
How do I remove the last 3 characters from a string in LookML? For example, I have “ownername2022:03:29”and I ...
Convert Date to String
I have a Date field I would really like to convert into a STRING so I’m able to use it in a CONCAT field. How ...
Looker visualization mysql issue
I connect to mysql server to visualize data into looker. I have column which has dates in text format. The tab...
Can we restrict filter condition options for strings?
Hi,I have a filter for string type and in the dropdown it shows the options based on which we can filter, Can ...
Filter based on list of entries of another table
Hi all,I am trying to how i can achieve the following in lookerI have 2 tables, Table_A and Table_B I would li...
Create HAVING clause and GROUP BY without it in SELECT clause
Hi, Is there a way in LookML or within the Explore itself to replicate the following SQL query - where `order_...
EXPLAIN is not working in Looker Sql runner
Hi Team ,We are using Big Query as data warehouse and I am trying to analyze the sql query performance using S...
Firebase Block - Derived Tables Issue
I am currently using the Firebase block available on Github. When generating one of the predefined derived tab...
Looker LOOKML will not accept double quotes for passed condition
When passing a filter from an Explore like in the below example for whatever reason we cannot get it to provid...
How to create flexible GROUP BY on LookML
This is the function generated in SQL, I want to include c.bkg_no, c.cntr_no, c.cntr_tpsz_cdm on GROUP BY belo...
Include all fields in Liquid variable
Do Looker support a variable name that include all the fields in the query?For example, I have this Liquid: {%...
Help Needed( new to Looker): Fiscal YTD calculation
I am trying to build a look which is essentially this:NetworkId | CountOrder Last month | COuntOrders_Fiscal_Y...
templated filters and derived tables
view: closed_loans { derived_table: { sql: with closed_loan_data as ( select row_number() over (order by coale...
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 ...
Multiple selection dropdown menu with a SQL DISTINCT UNION of values
Hello,I’d like to create a dropdown filter of approximately 70 values, the values are from an SQL query of the...
Count non-distinct values in a dimension
Hi,How do I go about count non-distinct values in looker explore for one dimension.I can write this in SQL but...
Avoid TO_DATE casting when data type already is DATE
This is the LookML dimension_group: dt { type: time timeframes: [ date, month, quarter, year ] convert_tz: no ...
Grouping rows
Hello,I’m reaching out for some help on how to aggregate rows in order to correctly display them in a chart. I...
I'm trying to convert the data to lat long coordinates in the looker, but I can only draw the polygon by circular points.
I would like the drawing to be in polygon format, but it is coming as circles, if i join the dots, the polygon...
Aggregate counts
Hello, I’m having trouble figuring out how to count publications in my data set by year and author. In my expl...
Errors with Setting Default Time Filters
I have an application where I want users to be able to filter their data by time on a dashboard, and I want to...
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...
3 month rolling COUNT using lookml
Does anyone know how can i get this ?I want to create rolling 3 month count of a measure .So basically if i wa...
How to update case statement in join to use aliasing instead?
I have a report that’s running off an Explore in my model, but one of the joins to a view needs to be updated ...
Convert String (yyyy-mm-dd) to Date field
I have a field in my database that is a string field but it contains dates in the following format: “yyyy-mm-d...
SQL Runner and Explore return different visualization
I want to add “funnel” visualization to my dashboard. I tested the query and visualization under SQL Runner en...
user selected value in query as filter
I am trying to create a derived table based off the below query on Looker. Except, I want the user to choose t...