About ernesto1

ernesto1 · 06-12-2018

It’s tempting to create a “top 10” style report and call it quits, often times it is more useful to understand the relative ranking of movement based on a time period; like how popular was this item last month vs last year? The end result is somethin...

ernesto1 · 05-28-2018

Google Analytics has a date selector that allows for comparison of two arbitrary time periods on the same chart. Period over Period analysis is useful for looking at this 30 days vs the previous 30 days, but it doesn’t let you compare how two arbitra...

ernesto1 · 05-04-2021

Hi @Arnaldo - you can always try an access_filter with a “Advanced (text)” user attribute with comma separated values. Or if you need to do it manually here’s some liquid that might help: sql_always_where: {% assign attributes = _user_attributes['cou...

ernesto1 · 10-28-2020

Hi @Vitaliy - your best bet is to hit “Help → Product Idea?” within Looker and submit a full request from there https://community.looker.com/getting-started-1006/feature-requests-how-your-feedback-makes-looker-better-20570

ernesto1 · 10-28-2020

Hi @Bob_Liu ! That’s a great question, certainly makes sense to have a different query to be able to compare results to. The thing is, the expression has to come from the same explore source as it’s using the table calcualtions mechanism. I found cre...

ernesto1 · 10-28-2020

Hi @Vitaliy ! Looks like you will need to edit LookML to get multiple values to show in your tooltip, this article should help: https://help.looker.com/hc/en-us/articles/360023508894-Displaying-Values-From-Other-Fields-in-the-Tooltip

ernesto1 · 10-28-2020

What is your name? Ernesto Ongaro What is your job title and industry? Sales Engineer @ Looker How long have you used Looker? 3.5 years, which in Looker years is decades  Trailing or Leading commas in your SQL queries? I switch back and forth, my lo...

My Stats

ernesto1's Bio

Badges ernesto1 Earned

Recent Activity

Ranks with Table Calculations

Arbitrary Period Comparisons

Re: Advanced Permissioning Using User Attributes

Re: Show values of 2 measures on a label

Re: Dynamic data tests

Re: Show values of 2 measures on a label

Re: ? Introductions Thread