About ChrisB

ChrisB · 10-02-2023

A financial analyst reached out to me and asked that I implement a measure to an Explore he uses frequently.This measure "True Cost" is a simple division based upon the "breakdown type" of the transaction. In SQL, it goes like this:SELECTCASEWHEN BRE...

ChrisB · 02-15-2022

I apologize for the vague title.A dashboard that was created by my predecessor (no documentation) is not working anymore. It now retrieves zero rows when it was initially displaying sales metrics.The dashboard uses A LOT of derived tables. I painstak...

ChrisB · 11-01-2021

Hello!! I have a Looker report that uses a view. It relies on a derived table built thuslyview: cte_seller_revenue_past_12_months { derived_table: { sql: SELECT seller.id as seller_id, true as revenue_past_12_months FROM ... JOIN ... JOIN ... WHERE c...

ChrisB · 09-10-2021

Hi! I am a bit rusty with Looker so I have a question.I have imported a view from my database and created a model for it. As myself, I am able to use my explore, query and view data.How do I give access to the Explore I created to my users? I am gues...

ChrisB · 11-02-2021

The @ChrisB it is because of the filter - so if you use ‘Yes’ as the filter, it won’t have the or statement. However, since yesno is nullable Looker adds the OR for the ‘No’ piece. I don’t think there is a workaround aside from the coalesce or changi...

ChrisB · 11-02-2021

@ChrisB it is because of the filter - so if you use ‘Yes’ as the filter, it won’t have the or statement. However, since yesno is nullable Looker adds the OR for the ‘No’ piece. I don’t think there is a workaround aside from the coalesce or changing t...

ChrisB · 11-02-2021

I’ve used coalesce in the sql to have things like this work. So if the default would be false then in your yesno field add: sql: coalesce(${TABLE}.revenue_past_12_months, 'False') = 'True';; The coalesce works fine but it does not remove the unnecess...

ChrisB · 09-10-2021

That did the trick, Olga! Thanks so much for the quick reply!!

My Stats

s0s0rhw's Bio

Badges ChrisB Earned

Recent Activity

Case statement to sum a value based on another value???

Dashboard returns 0 rows / SQL code retrieves results

Odd behavior with yesno dimension

How do I grant my user access to an explore?

Re: Odd behavior with yesno dimension

Re: Odd behavior with yesno dimension

Re: Odd behavior with yesno dimension

Re: How do I grant my user access to an explore?