Get average of data where 2 pivot column match
Hi EveryoneI have a looker look which uses 2 pivot dimensions. You can see below. One is Degree term ID, secon...
Forum Posts
Bar chart of Percent difference in the positive and negative direction
Hello everyone,I'm hoping to get some help making a bar chart to display percent differences in both the posit...
Can you create custom dimensions in Connected Sheet for Looker?
I have custom dimensions in a Looker Explore, but when I connect the underlying LookML to GSheet, I can't seem...
Create a date array dimension in Looker
Hi, I want to count resolved and created tickets per day in the same Looker graph. However, each measure relie...
Report Schedules vs Dashboard Schedules
Hi all,When I schedule a saved report, I have a lot of options for advanced logic. For example, I can send it ...
Connected Sheets for Looker
Testing a conversation about Connected Sheets for Looker
Dynamic timeframe using parameter
I have created this parameter , dimension and measure in LookMLParameter:parameter: select_timeframe {label: "...
sql_always_where completely blocking filter suggestions
Hey!Maybe someone can help me with the following issue:In my model, I have an explore that joins multiple view...
Static header for looker dashboard table
I want to create a header that is *sticky to the top of a looker dashboard Anyone help me to get this achieve ...
Scatter Plot Equation in table
I have created a scatter plot and want to use the equation generated in another tile. Eg:Equation: 55844ln(x)-...
Looks broke due to changes in view/explore.
Hi All,I made multiple Looks using set of explores. Then I made some changes to the view and explores in proje...
Dynamic Y axis value format
How can I dynamically change the value format of the Y axis when the selection for the Y axis is made on the b...
Cannot use EXTRACT() Function
Can anyone help me understand why when I try to create a custom dimension I cannot use the EXTRACT() function?...
Is it possible to find out which explore a label belongs to?
Hello everyone,Do you know if it's possible to find out which explore a label belongs to?Example of use: someo...
dynamic 13 months always
Basically what we are trying to accomplish is as follows:There is a date filter on a dashboard, there is a bar...
Field Picker - filter-fields moved and field order rules changed?
I've noticed two weird things lately. First is that Filter-fields only are now below Dimensions and Measures. ...
Formatting comments in Looker Data Dictionary
Is there a way to format comments in Looker's Data Dictionary. I am looking to add some SQL snippets to furthe...
Rank with a Filter (table calculation)
I have a list of SKUs, the Product Category each SKU belongs in, and each SKU’s Order Count. I’d like to make ...
Explorer for wrong references. Best practice
I have 2 viewsOrders.view derived_table: { sql: select 1 as id, 100 as amount, 1 as customer_id UNION ALL sele...
Filter a Large Explore with Extends OR Build a Large Explore with Extends
We sometimes need a “mega Explore” - an explore that joins several adjacent domains together (e.g. web traffic...
Still cannot "explore from here" in a new tab in dashboards-next in the new release 21.x?
Hey, We are at looker version 21.x, When I try to do “explore from here” from a tile (dashboard element) on th...
How to get null values sorted to bottom?
I’m trying to sort a table in explore in descending order from a column. The problem is that the Null values a...
Mixing "Explore´s fields"
Hi, when I enter an explore, I see some "Fields" on the left side. For example, if I enter the "Explore" calle...
in Table Calculations - find distinct value AND last instance of duplicate values
I have a column of values where, in table calculations, I need to identify in another column whether that valu...
Merged Explores on Dashboard Not Exporting as CSV Correctly
So I have built a merged pivot table (with table calculations) for a co-worker that is part of a dashboard.The...