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.
To give that some context, I am running a report that produces many rows of data - the size of which depends on the date range used.
One of the columns within that report is a ‘concatenation’ of four other columns, where the concatenated information is only displayed when it satisfies a yes/no condition via an ‘if statement’ (per a table calculation).
What I am desperately keen to do is to be able to count the number of times the concatenated results appear in the data (akin to countif in excel).
Hopefully this all makes sense (I’m a looker newbie) and there is a solution.
Many thanks,
Shaun
LinkedIn
Twitter
