About blue1

blue1 · 02-12-2024

I came across something very bizarre. For some reason, alerts in Looker respect caching policies.This does not make any sense to me. If an alert runs on a cache that is showing outdated information, it will alert to something that might no longer be ...

blue1 · 01-25-2024

Here is the situation:We have a very large model as customer would like to join basically all existing tables together.As with all models, there is a root table that all other tables join to through a tree of connections.The problem comes when I set ...

blue1 · 01-19-2024

One of our users would like to schedule content to a REST API endpoint. The parameters include:https:// URLUsernamePasswordI could not find any scheduling options that support these parameters, does anyone have experience with this? The current webho...

blue1 · 07-13-2022

Hi All,I want to create this post to make you aware of this bug. I have contacted Looker Support, but was simply told that downloading vis tables when the order is different from the data table is currently not supported and this is “normal” behaviou...

blue1 · 10-12-2020

I want to share my approach to bulk editing Looks in a Dashboard. Sometime you have to move Looks on a Dashboard to a new Model or Explorer. You could of course open every look using “Explore from Here” and modify the URL and then re-add it to the da...

blue1 · 01-30-2024

I see, I did not know about this parameter, thank you! It might help for the second or third load, however, it will not solve the initial runtime being slow.

blue1 · 01-30-2024

I have a solution for this, but it does not consider Holidays, as that is almost impossible to get right, especially across timezones.However, here is what you can do to exclude weekends:dimension: datediff_no_weekend { type: number sql: datediff(sec...

blue1 · 01-30-2024

Sometimes, the best solution is to simply create a Derived Table . You can created the exact logic you need in SQL and join it to the TeamID in your model.

blue1 · 01-30-2024

Hi @dsimeonova , thanks for your suggestion. Caching happens automatically, the problem is the initial slow load of the filter when it is run for the first time that can be frustrating UX.The inefficiency comes from the fact that the sql query from t...

blue1 · 01-30-2024

If you want to sort a date in descending order, all you have to do is make more recent dates a smaller number than older dates. To achieve this, you can simply convert the date into a negative number: dimension: inverted_date { hidden: yes type: numb...

My Stats

blue1's Bio

Badges blue1 Earned

Recent Activity

How does it make sense that alerts can run on a cache?

How do you optimise filters?

Setting up a Webhook schedule with a Username and Password (WebDAV Https)

PSA: When data columns and vis columns are in different order, downloaded data will have incorrect headers!

How to: Bulk edit Looks on a Dashboard

Re: How do you optimise filters?

Re: How can I calculate working days between two dates in Looker?

Re: How to do a Count based on Groupings

Re: How do you optimise filters?

Re: order_by_field descending?