Filtering data using two dates in LookML

[Simant_Sah]

Hey guys!

I’m trying to get the count of leads between two dates. Below is the LookML I’m writing in order to filter it by dates:

measure: q3_leads_and_contacts {
type: number
sql: case
when extract(month from ${createddate_date})>=3 or extract(month from ${createddate_date})>=6
then ${count}
end
;;
}

However, it’s giving me an error saying “createddate should be in the group by clause”. What am I missing here?