This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
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 ...
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<!-- --><!-- -->...
@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...
@jaime_serafim-1 Have you tried using a running_total measure
type?https://docs.looker.com/reference/field-reference/measure-type-reference#running_total
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...
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.
@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...