About eric_h

eric_h · 08-10-2022

I remember a few months ago, there was a ‘fashion.ly’ site that served as a demo for Powered by Looker features. I’m also remembering a place where embedded ‘blocks’ were showcased. For example:Embed block for displaying a dashboard in an iframe Embe...

eric_h · 06-29-2021

Sounds like you could make a derived table to calculate the total that you’ll use in the percent of total calculation, and use bind_filters: to limit the filters that are applied to that derived table.Here’s an example using dummy data: view: total_p...

eric_h · 06-29-2021

Do you have access to the Alerts and Alert History section under “Admin”? I want to know if the alert is running and whether there are any errors keeping it from working before digging into the calculation and the data. Hope we can figure it out!

Re: Last 14 days user population · 04-14-2021

I know you can get the filters to carry over with native derived tables using ‘bind_all_filters: yes’ in your ‘explore_source:’ definition. As far as I know you can’t carry them over in a SQL derived table in the same way.Clever SQL there using STRIN...

Re: Last 14 days user population · 04-12-2021

Since you’re using overlapping periods, I think you’d need to create a snapshot of the data for each period of 14 days. I’ve been using this flexible Period-over-period code, and it should help you out, as well. You’d need to set your ‘Created Date’ ...

eric_h · 04-07-2021

I think the table calculation route that Eric mentioned is the easiest to implement, but you can also add Top N analysis to your LookML, as well!There’s a great article that shows how you can dynamically select the top 5, 10, 15, however many you wan...

My Stats

eric_h's Bio

Badges eric_h Earned

Recent Activity

Is there a new location for the Fashion.ly demo site or embedded 'blocks'?

Re: Percent of Total Ignoring Filters

Re: Issue with Looker Alerts

Re: Last 14 days user population

Re: Last 14 days user population

Re: Grouping Dimensions by Rank