About shiggins

shiggins · 07-07-2021

Knowledge DropLast tested: Mar 23, 2021 Just a brain dump of stuff I found while tinkering with the Extension Framework.FirebaseIf you want to sync stuff with a realtime database, Firebase is a good option but you will have to do something like this ...

Calculating User Repurchase Rate · 02-09-2018

Definition: How frequently do your users, who have already purchased an item, purchase again? Example Mary buys shoes on Monday. Steve buys socks on Monday. John buys a tie on Monday. Elena buys a hat on Tuesday. Mary buys a dress on Friday the same ...

shiggins · 11-16-2017

There are a number of great use cases for being able to have a progress bar or a way to visually represent when a project moves from one stage to the next. With Looker we can achieve this using the html parameter. Thanks to @Bryan_Weber for doing all...

shiggins · 11-25-2021

@glorinthegalaxy You can do this in a Table Calculation.Where user_id is the column with the repeated value you want an incrementing number per unique value:if(row()=match(${order_items.user_id}, ${order_items.user_id}),1,1-1*(match(${order_items.use...

shiggins · 11-25-2021

@jaime_serafim-1 Have you tried using a running_total measure type?https://docs.looker.com/reference/field-reference/measure-type-reference#running_total

shiggins · 02-20-2020

Yes, a Native Derived Table that isn’t persisted will produce a CTE like that. As will a regular derived table. One of the major benefits of using a NDT vs a regular derived table is you can use bind_all_filters which will mitigate the need to create...

shiggins · 02-20-2020

Without much context, what comes to mind is using a Native Derived Table to calculate the variable (orders within a range) that’s joined back into your main Explore and leveraged (as a Dimension) for calculating Costs.

shiggins · 09-24-2019

@davisclark granted, this wasn’t intended to be an example of a histogram, so I can see where I was confusing and possibly conflating the two asks, but an example of generating dynamic # of buckets and the functions that can be used to calculate thos...

My Stats

shiggins's Bio

Badges shiggins Earned

Recent Activity

Looker Extension Framework Development - Edge Case Quirks

Calculating User Repurchase Rate

Using HTML and Liquid to create 'progress' bars inside a Table Vis

Re: How can I create a column with a sequence for every new id

Re: How to calculate YTD for every date period in history and not just as now?

Re: Variable to store values in lookml

Re: Variable to store values in lookml

Re: Creating Dynamic Tiers