About Chris_Tinnon

Chris_Tinnon · 05-12-2022

I’m genuinely curious what databases are being used. Your experiences with them, good and bad. Would you use something else if you could? Why?For context, we’re almost exclusively using Snowflake. I suppose the honeymoon period has worn off and I’m s...

Chris_Tinnon · 08-24-2020

What is the simplest way of getting the json results from a look into a pandas dataframe? Assuming I have a two dimensional table, with one dimension pivoted. (Note, I’ve actually written functions that parse the json and create a dataframe. But it’s...

Chris_Tinnon · 04-03-2020

I have a filter with hundreds of options. I have it set to use “is equal to” but the looker behavior is to do a where field in (value1, value2). What I need is for it to be where field = value1 and field = value2. Custom Filters is not the right solu...

Chris_Tinnon · 05-31-2022

You may find success with this tool. https://community.looker.com/open-source-projects-78/gazer-a-command-line-tool-for-looker-content-management-8066

Chris_Tinnon · 08-05-2021

You should be able to use count_distinct on user_id.measure: distinct_users { type: count_distinct sql: ${TABLE}.”USER_ID”}From there, you should be able to filter on the measure where count > 1.

Chris_Tinnon · 08-03-2021

Yes, but it seems like something that should be done in your database, not Looker. Without knowing your database, all I can say is read up on its relevant date functions.If you are not a lookml developer, there are table calc functions that can get y...

Chris_Tinnon · 08-03-2021

I’ve done this with merged tables. Not ideal, but functional. Your dashboard is just setup with two country filters that apply separately to the source tables which are merged.From a Lookml perspective, I believe you’ll want to use derived tables and...

Chris_Tinnon · 07-15-2021

Use ticks ‘__LOOKUP__’ instead of quotes around “__LOOKUP__”.

My Stats

Chris_Tinnon's Bio

Badges Chris_Tinnon Earned

Recent Activity

Your database behind Looker - Why are you using it? Would you want to use something else?

Easily loading JSON to a dataframe

Is Equal To filter, AND instead of OR/IN

Re: Moving Looker work (Looks, dashboards...) from one enterprise instance to another - Is possible?

Re: Help with a query

Re: String to date

Re: Comparison : Country in dashboard

Re: Using SPLIT_PART in dimension