About Shaun67

Shaun67 · 02-18-2020

Hi Looker Community, Can you tell me if there is a looker function / statement that is equivalent to ‘=countif’ in excel? The reason I ask is because I want looker to be able to count the number of instances of a particular outcome in a custom field....

Shaun67 · 03-09-2020

Hi Jimmy, Appreciate you taking the time to reply. Unfortunately I haven’t had an opportunity to try your suggestion as yet, but certainly plan to in the coming 24 hours. Many thanks! Cheers, Shaun

Shaun67 · 02-18-2020

Hi Quinn, Appreciate you taking the time to respond and fixing the error in the formula. Happily the formula worked but unfortunately it didn’t achieve what I was hoping it would do. I’ll raise a new thread in regards to this. Many thanks, Shaun

Shaun67 · 02-18-2020

Sara_Guzman: count(${view.field}) - match(${view.field}, offset(${view.field}, count(${view.field}) - row() * 2 + 1)) + 2 match(${view.field}}, ${view.field}) Hi Sara, I’ve got a similar question to the original poster, however when I try and adapt t...

My Stats

Shaun67's Bio

Badges Shaun67 Earned

Recent Activity

'Countif' type functionality in Looker?

Re: 'Countif' type functionality in Looker?

Re: How do I count duplicate values in a table?

Re: How do I count duplicate values in a table?