About David_P1

David_P1 · 10-08-2021

What’s been your experience in organizing your lookML, specifically when provisioning reports to different customers. I am in the process of setting this up and would love to hear your thoughts on:Do you favor having a model per customer or only a si...

David_P1 · 09-28-2021

Anyone has any idea how to achieve the same look from the old dashboards with dashboards-next for text tiles?I am using the code that @izzymiller posted in this link:https://community.looker.com/dashboards-looks-7/center-align-linked-image-in-dashboa...

David_P1 · 09-07-2021

I came across a great video series of Looker releases from Josh Neman and the folks at Brooklyn Data Co., and thought of sharing it with the community - worth the bookmark! Would be helpful to have short videos like this attached to the official rele...

David_P1 · 02-01-2021

We make use of boards to improve the homepage experience of the different users e.g. we assign different boards to different user groups based on a user_attribute so that the content is curated for each group's needs.It would be great to have the hom...

David_P1 · 11-26-2020

Hi,I’d like to re-structure our current data model using the hub&spoke architecture. Are there any guides/documentation available?What was your experiencing in using this type of architecture? I specifically would like to leverage the modularization ...

David_P1 · 10-13-2021

something like this?dimension: is_dim_name { type: yesno sql: ${question_id} = ‘text’ and ${answer_label} is null ;; }

David_P1 · 09-28-2021

took some tweaking, but figured it out… here the code in case it helps someone:<DIV>⚠️ Warning <DIV> <H5>Special title treatment</H5> <P>With supporting text below as a natural lead-in to additional content.</P> Go somewhere </DIV></DIV>

David_P1 · 05-30-2021

Hi, you can achieve this by creating user_attributes.For example, you have a country filter in your dashboard and you want users to see their corresponding country whenever they access the dashboard. You will need to create a user_attribute and then ...

David_P1 · 05-30-2021

Hi @brittany_juarez, I can suggest 3 ways to approach this:Filtered measure: This is my preferred solution as it would allow you to reutilize the measures in the explore. measure: sum_dimension_today { type: sum sql: ${my_dimension};; filters: [date:...

David_P1 · 05-04-2021

hi @Michaël_S, check the answer provided by @Cyril_MTL_Analy in this post. You could use the same approach of creating a boolean dimension and then adding a filtered measure - the only difference being that your SQL should include the 7-day interval ...

My Stats

David_P1's Bio

Badges David_P1 Earned

Recent Activity

LookML architecture/organization (w/ multiple customers)

How to format text tiles in dashboards-next similar to old dashboards?

Shoutout to Brooklyn Data Co. ? (demo of Looker releases)

Make homepage sidebar available also for homepages that use a board instead of default homepage

Hub & Spoke architecture

Re: yesno dimension with several conditions

Re: How to format text tiles in dashboards-next similar to old dashboards?

Re: Has anyone found a solution for bursting?

Re: Custom Measure for finding value for today and yesterday

Re: Sum sales between start and en date