Hi community.
I am new here and this is my first question here and I will be very grateful for your advice.
Given:
Table on leads
Dimesions:
- Creation Date of leads
- Source of leads
- City of leads
- Status of leads
- Id of leads (unique for each lead)
Measures:
- count(id)
I need to calculate a conversion (I expect a new calculated field) with a following definition of
conversion rate = Total count of Ids with a status='customer' for given month/Total number of Ids for leads created for given month.
What would be the best way to solve this.
Many thanks in advance.
4 answers