Add weekend to a time_period parameter
Hey Guys,I have a time_period parameter that has values for Day, Week, Month, Fiscal Month. Can anyone suggest...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Type yesno returns null values as no
We had been using yesno as an equivalent to boolean, which has thrown off our reporting. For example, we have ...
Creating a Unique list of values using a custom dimension
HelloIm brand new to Looker and I am trying to learn as I go. Here is the situation. I created a custom dimens...
Render HTML for partial string of dimension value
Hi I have a use case where I need to highlight special characters(partial string) in dimension value (make it ...
LookML DT to SQL and PRIMARY KEY
If I have this LookML code:view: active_orders { derived_table: { sql: SELECT o.id FROM orders o WHERE order.d...
Extract Amounts from dimension based on start and end point
Hi All,I am very new doing this. I have a column with text for example:##TEXT## - £123.00 - TEST 1 ##TEXT## - ...
Using Looker to send data to analytics
Hi everyone, I’m fairly new to Looker and I’ve been looking for info about this for a few days, and I don’t re...
How to compare current quarter to same quarter last year?
I’m trying to show how we are performing in this current quarter to the same quarter last year, but have not f...
Mapbox MTS visualization not displaying on Looker.
Hey there,So I am facing errors in displaying my custom clusters after successfully uploading them on mapbox v...
Working with calendar table in multiple joins
Hello!I am new to the Looker World and the LookML as well.Recently i have been working in a task that is joini...
snowflake: 2 correlated columns have very different clustering information (one has perfect, the other has terrible)
0We have a table with 120M rows (over 2222 micropartitions), that has 2 important columns, record_id with valu...
Role Play Dimension
Can we implement role play dimension logic ?If yes please let me know how to achieve this requirement in looke...
Automate notifications for failed scheduled reports
Hi, I run a number of failed scheduled reports and I am looking to automate the process of notifying the owner...
Conversion to Date
How do I convert to data in the looker, I saw that it doesn't have the dataparse
How to use liquid variables date dimension and forecasting
Hello! I'm using this way to choose data aggregation in my current Looker solution: dimension_group: created {...
Unpin Axis from Zero on Combination Chart
Hello everyone,I am currently developing some charts for dashboard in LookML and I am facing some issue with t...
LookML Dashboard generate ratio
view: conversations { sql_table_name: "PUBLIC"."CONVERSTATIONS" ;; dimension: conversationId { type: string sq...
filter pushdown and looker empty points
IS there a looker-pinot connector ? We are using Trino to fetch data stored in Pinot , via LookerIn table the ...
SQL Server 2016 Error: GROUP BY expression must contain at least one column that is not an outer reference
Hi all,I am trying to build a viz that shows the fiscal year of the date selected by a user in a templated fil...
chart dimension changes and adjusts the date dynamically on the choice of filter
My requirement is a line chart where X-axis is plotted with week(six weeks) and Y-axis is a measure. Now the w...
Look files?
Hi Is there a specific lookml file type for looks, or a feature that is being developed?
Quarter Format Issue
Hi Team, I am facing problem with my Quarter value. In my data set I can see quarter as 2021-01,2021-04,2021-0...
Merge Query and LookML
Are there any plans for developers to create merge queries like everything else, i.e. write LookML and the res...
Dynamic Dimension with Links
I have a dynamic dimension that reads a parameter. The dimensions should have a link. These links do work if t...
How to correctly relate a master table of dates with 2 or more tables.?
How to correctly relate a master table of dates with 2 or more tables.?
Seemingly inconsistent SQL generation
I’m using liquid to dynamically switch the metric being used in a measure based on a parameter that users sele...
How to exclude data that has a specific tag ( when there are multiple tags)
Hi, I’m new to looker. I am trying to identify orders that are tagged as “test” to exclude them. The problem i...
Can I use constants in my sql derived table?
Hi all, I’d like to work with constants in my manifest file however I can’t seem to get it to work. Am I able ...
monthly recurring revenue, churn rate, net retention rate in the subscription world
Very often, I work on subscription data, with a typical contract table with a start date, an end date, an amou...
display historical pipeline with hubspot deal_stage table from fivetran
When I am working on cRM data, I always use the crm block form keboola with a bit of the salesforce block. I w...
