Hide Column in PIVOT Table Chart
Hi,I want to hide both “Order Items Shipped Date” and “Order Items Count” as highlighted in Table Chart (two d...
Forum Posts
Looker expression editor _ subtraction by pivot rows (sum by grouped dimensions, then subtract)
Hi,I am new to Looker, not sure if it is possible using Looker expression editor to achieve this (I cannot use...
Feature Request: Ability to create charts out of pivot tables
Pivot charts are very powerful as they offer great multidimensional insights, yet in table style they are ofte...
Creating pivot table with monthly historic data and most recent data
I’m trying to create a Pivot Table w/ Heatmap report showing historic data for the last 6 months for two data ...
Unduplicating Rows and Aggregating Sums by Date without LookML Access
Hi,I’m currently working on a Look that displays revenue at risk dollar values associated with billing errors ...
Hierarchical Table/Matrix with Subtotal and Grand Total
Hello Learners and Experts,I am new to Looker and exploring looker’s different feature. I wanted to create Hie...
Calculating the % of a pivot index group
Hello! I am trying to do:Calculate the sum of column 1, 2 and 3 Take nulls into account Calculate column 1 as ...
Table with subtotals doesn't meet users needs
Hi there, We’ve just adquired looker as our new BI corporate tool. We’re already created some models and dashb...
Unpivot one dimension?
I want to show revenue of 1. price discounted items, 2. package discounted items, and 3. all discounted items....
Ordering of pivoted columns
Hi,In Excel pivot table, it’s possible to reorder so that the pivoted column is nested under each values. e.g....
Hide last pivot column
Hi everyone!I am working on hiding the last pivot column from visualization. I’ve already explored these worka...
Export as Excel with Pivots
I viewed the report as a Table Report and displayed the measures at the top. However, when I download it as Ex...
Is there a way to exclude null values for pivoted table calculation column?
For example i have data for 2019 and 2020 i wanted to calculate variance i get null for 2019 Variance due to d...
Exclude first column for pivot_offset
Hello,I’m trying to build a table with a week on week % change. I’ve done this with pivot offset but the first...
Difference between two pivoted columns
Hello. I’m trying to get the differences between test and control for segments 1 and 2.Disregard the values th...
How can I merge 2 queries when one of them is pivoted?
My objective is to get a stacked bar chart with a line laid on top.Stacked bar chart data looks like this:Grou...
Pivot with values in different columns
Hey folks, I’m still fairly new to Looker and I’m trying to format some data in a way that I can easily produc...
How to create table calculation using pivoted measure data?
I’m relatively new to Looker, so this may be an incredibly simple ask, but how do you build your table calcula...
Measure not grouping by pivoted dimension properly
Getting some unexpected results when I attempt to pivot a measure by a dimension. I would like the pivoted mea...
Summing over multiple pivots
HII have a table with multiple pivots (as in the screen shot below), and I need to calculate a ratio of sums o...
How to pivot or group by a measure?
Hi, I have a look which, at a basic level, is 1 dimension (user ID) and 1 measure (number of products used). I...