About Steve_Guidi

Steve_Guidi · 03-16-2022

Hello! I’m experimenting with map layers for rendering data in geographical regions and I’m finding some limitations that I can’t seem to work around. Perhaps this is caused by my data schema, or my understanding of how-to best use map_layer_name in ...

Steve_Guidi · 02-02-2022

I have a pre-computed metric table that has a small set of dimensions and non-aggregate measures. How do I model this table in Looker so that a GROUP BY clause isn’t appended to the report query?To give a contrived example of the use case, consider a...

Steve_Guidi · 03-18-2022

Thank you for the feedback, @Dawid! I’ve confirmed that the Liquid syntax features doesn’t apply to the map_layer_name attribute and I so I opted to redefine each dimension per desired map layer. dimension: postal_code { group_label: "Geography" type...

Steve_Guidi · 02-04-2022

Yes, that’s true. The required-field is not displayed, but that should be o.k. for my use case. I’m trying to ensure that someone doesn’t try to aggregate unique-user measures, and this will do it. The rendered report loses meaning without the module...

Steve_Guidi · 02-04-2022

If you are worried people will put UU into an analysis without moduleid (summing all the UU across modules) then you can make moduleid a required field for the UU measure. This is a great suggestion -- thank you! For more complex unique-user calculat...

Steve_Guidi · 02-02-2022

what is meant by GROUP BY 1? Does 1 refer to flight_distance field? Yes.In many SQL dialects, you can `GROUP BY` (and `ORDER BY`) the position of the field as it appears in the `SELECT` clause. This is a convenient short-hand notation that helps when...

My Stats

padmanabhamv's Bio

Badges Steve_Guidi Earned

Recent Activity

What are "best-practices" for organizing location/geographic data so that it plays nice with map layers?

How do I remove the GROUP BY clause for an explore/view with non-aggregate measures?

Re: What are "best-practices" for organizing location/geographic data so that it plays nice with map layers?

Re: How do I remove the GROUP BY clause for an explore/view with non-aggregate measures?

Re: How do I remove the GROUP BY clause for an explore/view with non-aggregate measures?

Re: Group by