How to implement DatesYTD and DatesMTD using LookML
Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql_...
Forum Posts
Not able to see the filters in Explore in Edit Mode
I have a dashboard, In which i have 4 looks. I was asked to apply a date filter on it. When I added, it worked...
connected model to another model
Is it possible to have one model which is connected to an other model ? I've my modelA which is connected to B...
Symmetric aggregates overflow bug?
Here is some lookml : view: debug_test_1 { derived_table: { sql: SELECT '14d' as id UNION ALL SELECT '13d' as ...
Inaccessible view despite views being joined in explore
Hi, I have created a new dimension "dimension_one" in my view "view_one". This new dimension references fields...
i Want to manipulate "period Control" filter in my looker studio
I have a report and need to be able to manipulate the value of the "Date Range Control" field. I need to get s...
Doubt with conditional filter
Hello everyoneNew with Looker and following some of the Labs available. In one of them we need to create a con...
How to convert number to time in looker
Hello Team,I am query regarding how to convert measure with number data type to time data type in the form of ...
Automatically create Lookml Views, Model, Explores
Hi, I was wondering if it is possible to create Look-ml views, model, explores automatically. Somethin like wh...
I am looking to create a Calendar
i wanna create a calendar con i can visualize the time off of my employees, is it posible on looker?in a calen...
Inaccessible view user_mini-session referenced in retention
Hi, I am having some issues referencing a dimension from one view into another. (unable to post without the sp...
Which would be the best 3D modelling software available in the market?
I am currently pursuing Robotics Engg. I had question in my mind that, which would be the best 3D modeling sof...
Regarding LoolMl
How to translate Lookml code from snowflake to Bigquery
Best practises for Total metrics in datasets
Hi, i am just wondering what is your opinion about including TOTAL metrics in a dataset.I have a dataset that ...
How to keep Bigquery Structs
Hi everyone,I have some tables in BigQuery with Structs (nested data); for example, I may have 5 rows with the...
Potential bug in dimension type: date filter due to obligatory TIMESTAMP conversion
when using a dimension of type date,dimension: utc_created_date {type: datesql: ${TABLE}.utc_created_date ;;de...
Merge Queries
Hey,We are trying to do a merge query but it isn't producing any results. We are joining the explores on an ID...
Convert text to Date
Hi i have a google sheet that is the data source for looker. One of the dates is inthe following format - 11/2...
Not able to create a project in Looker despite Admin Role
Hi Team,I have admin role in Looker. But when I try to create a new Looker project, I encounter Looker access ...
Drill Down Issue
I am trying to create a collection of fields for drilling down in an explore and hitting an issue. I have an e...
Connected Sheets for Looker limitations: always_on_filters, drill_fields
Hi, I am trying out Connected Sheets for Looker, so accessing LookML explore via Google Sheets and I am seeing...
Dimension Groups / Hierarchies for Strings. Like Product Hierarchy, Or Region Hierarchy
How can one implement below in looker?Let's say we have a sales report, and content is sliced and diced via co...
how to get database name in Looker
I would like to capture database name in looker. How can we do that? I see there is way to capture dialect via...
Nested dynamic parameter
Does anyone know how to nest a parameter? Instead of having a single parameter with 6 values, we want 2 parame...
Looker Access Filters
Hello,For my job, I am updating a model with an explore extend. In that extend, I am joining the base explore ...
idiom problems
im triying to make a report and im working in english but when my boss uploaded the report in our page (where ...
Show images stored in google drive folder
I’ve an AppSheet app (storage is a google sheet file) taking pictures and saving on a google drive folder. I’m...
Sales of current week Vs Sales Last week based on Week Number(Custom) Selection by User
I want to show Sales of current week in a tile(Multiple value) object. Where users will be selecting a week nu...
The lookml validator does not raise a warning or error when there is a typo in relationship
Hello, I hope this is the right place to raise this issue. As per documentation the syntax for relationship is...
When is convert_tz: no ignored?
Looker documentation highlights the below nuance about using convert_tz: no. However, in my testing, I do not ...