Calculating Custom Fields - Dashboards
I'm fairly new to SQL text, but I can usually get by. However, I'm stuck here.
The problem is simple: I want to calculate our overall "renewal" rate; that is, the percentage at which our clients renew with us by hiring us again.
The first two problems to solve are distinguishing between our "Client" and "Internal" projects, which I do by the following formula
SUM(CASE WHEN "Client or Internal" = 'Client' THEN 1 ELSE 0 END)
This works as it should.
The next problem is adding together every instance where a client has renewed. I created a custom field linked with Projects called "Renewal" (a simple Yes or No answer), so my formula is :
SUM(CASE WHEN 'Renewals' = 'YES' THEN 1 ELSE 0 END)
This formula does not work.
Can anyone help me out ?