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.
If you look at this screenshot, you can see the "repetition" of the
header names. "Company Id Company Id" etc...This is the LookML for
`company id` dimension: dimension: company_id { view_label: "Company Id"
label: "Company Id" description: "Seller's...
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...
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...
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...
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...
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 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...
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...
