About moebe

moebe · 02-17-2023

Looker offers to calculate the total in addition to the details in an Explore: This has always been a bit tricky, and in my opinion a suboptimal way to go.Today, however, I encountered a problem that actually makes this path become ridiculous, and I ...

moebe · 06-10-2021

Hello togetherWe are looking for a new Business Intelligence Engineer in Bern, Switzerland.We are running a state of the art BI landscape since October 2020 with HVR and Matillion for realtime streaming and ELT, Snowflake as DWH and Looker as fronten...

moebe · 04-12-2021

Hi allI wanted to share my thoughts on the new "incremental refresh" feature.It's actually a great thing.Unfortunately, I think the current solution is not sufficiently well thought out and not very useful for some use cases.I always refer to the com...

moebe · 09-21-2020

The following problem: In my base I calculate key figures. For performance reasons and for reasons of key figure correctness I now need a persisted table from a subset of the master data and key figures. Normally I do this via PDT. But in this case t...

moebe · 09-01-2020

Layer, Refinement, Extend or: what is the best solution? We are currently working on the largest of our LookML models. This model is actually not that complicated, but it gets a lot more complex due to looker behavior and business requirements. The p...

moebe · 02-18-2023

I thought about it again and found a - I think - simple solution.We as users can't implement it, but it shouldn't be rocket science for Looker/Google. To fix the problem with the wrong totals, Looker/Google would only have to rewrite the TOTAL statem...

moebe · 11-21-2022

here too.Different problem, same need.We face the problem that we need a filter (i.e. field a = "X" or field b = "X"), which is not possible.We could use a lookml field "Filter", but that would not be reflected in the aggregate overview. But if we co...

moebe · 03-16-2022

We have just opened a new BUG.We have the problem that the table VIZ delivers wrong totals in connection with subtotals.So the subtotal does not match the underlying data.This is of course quite dangerous, as this error is not directly visible to the...

moebe · 03-05-2022

I'm afraid something along those lines:https://community.looker.com/looker-adoption-community-1016/can-someone-confirm-looker-laying-off-us-dcl-29178I really hope the BOT does not lead to a deterioration of support.

moebe · 02-02-2022

Good catch DataChicoI would also like to see a function to recreate the PDT from time to time.The current solution is fine, but as described here, the current solution is not good enough if you have historical changes.We currently refresh once a week...

My Stats

mdeorue's Bio

Badges moebe Earned

Recent Activity

Complex issue with the way Looker calculates totals

Business Intelligence Engineer - @BKW

New incremental feature

How do I calculate a new key figure based on a NDT?

Layer, Refinement, Extend or: what is the best solution?

Re: Complex issue with the way Looker calculates totals

Re: Can we restrict filter condition options for strings?

Re: Anyone still frustrated with Table-Next?

Re: Launching chatbot in our chat widget from March 14th

Re: Incremental PDT's - rebuild entire table nightly