Skip to main content

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
0/9000