Count how many Providers submit a range of cases
Hello, I am trying to segment our Providers by how many cases they submit.
I have the formula below but I have something wrong. Ideally it will tell me how many Providers submit between 1 and 10 cases and 11 to 20 cases labeled them as Provider 1-10. This count will change throughout the year as they continue to submit cases. When I know a case has been approved is then `FirstSetupApprovedDate` has a date, if it is blank I wouldnt want to count it
I hope someone can help
WHEN COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID`) >= -1 AND <= 10 then 'Povider 1-10'
WHEN COUNT(case when `FirstSetupApprovedDate` IS NOT NULL then `CaseID`) >= -11 AND <= 20 then 'Povider 11-20'