Reusable Table Calculations defined in LookML layer (new field type)
Lately I find myself wanting to use a measure of type: running_total in another measure. Things like that are ...
Forum Posts
Sum Of Two different type values in Measure
Hi All,I am having problem with sum of two different type values .example : i have address_type like current a...
Parameter to select set of metrics or do a calculation on multiple dimensions
I have a set of metrics that I want to visualise on a dashboard or exploreI would like to have some way of eit...
Finding top 10 performers each month without table pivot
I read the “How to Find the Top Performers Over Time with Table Calculations” article (https://help.looker.com...
Percentage Change
How to calculate percentage of change based on filtered time period(between two dates) selected by the user on...
Count Distinct without data on table?
Hello,My case is very simple. How do I count the amount of times that X has Y without having it on my table?Ex...
Best way to replace table calculations for month over month retention/results
I need to track 3 data points month over month that all have to do with the volume of partners on our delivery...
Case When in Custom Fields Dimension
Hi,How to create Custom Fields Dimension with Case when conditionsi have custom fields dimension and the resul...
How to calculate mean over a custom row value something like AVERAGEIF in Excel Spreadsheet?
How do I calculate the average over some values defined in a row ? For example H1 H2 ValueAx || a1 || 1 Ay || ...
Max Date and the Second Max Date
Hi All,I have my data with an ID and each ID has got multiple dates and valuation for each date. My requiremen...
Definitions of grouping functions using Group function
Does anyone know the exact definitions of these conditions using the “Group By” function on the front end of l...
Case when for custom dimension (bucketing)
Hello, I am hoping someone can give advice. I am looking to bucket orders.My goal is to create two custom dime...
Bug when generating SQL for BigQuery in function EXTRACT_DAYS()
Something very weird has been discovered by one of my colleagues. They were trying to plot some data with day ...
Splitting a date string
Hello, I am trying split a date and time string into separate date and time components, i.e. 01/04/2020 11:45:...
Creating a new dimension (buckets) from previous variable.
Hello,I am hoping someone can help me with this. I am not sure if this can be done in a table calculation or c...
Creating buckets of new combined categories for a chart.
Hello,I am hoping someone can help me with this. I am not sure if this can be done in a table calculation or c...
Avg for past x months weekly
Hi, below is my data tables I have.table1:sku_id dateval sales_data ab124 20210603 10 ab124 20210502 20 ab123 ...
Table Calc Totals in LookML
Trying to get an aggregation at specific level - I know this can be done in a visualization easily using table...
Table Calculations: Different Value Format for Each Row
Hello,I have implemented the table transpose solution described here. However, in the example by Looker, all t...
Native Derived Table > Auto-gen LookML for existing Explore table calcs
Hi Folks,Looker newbie, apologies in advance.I’m hoping to build a native derived table, to aggregate the resu...
Add timezone conversion when using custom fields
Sometimes I use Custom Dimensions to split my data by a point in time. Like let’s say 15th of February 2020. I...
Comparing dynamic weekly data with static benchmark
Hi Everyone!I’m looking for support on a quite simple calculation (I believe). Many thanks in advance for your...
Looker View - How to SUM a COUNT_DISTINCT Measure
Hello fellow Lookers, I have a View file that contains a Measure to COUNT_DISTINCT Id’s. I apply this Measure ...