Forum Discussion

SadStatue's avatar
SadStatue
Helper II
5 years ago
Solved

Employment conversion rate measure calculation

Dear community,   Below you can find the data related to a recruitment process. What I want is to calculate a conversion rate between 2 phase of this process (Stat 11 to 20). Timestamp Referen...
Need Help
SadStatue's avatar
SadStatue
Helper II
5 years ago

Hi v-xulin-mstf ,

Thanks for your response.

it works if we select a single Reference ID, but it wont work if we dont filter it by a single Ref ID. And I want it to work generaly.

below example is more comprehensive:

So I want the (count of red underlined)/(count of highlighted).

Cheers,

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

So the numerator has to be the count of all rows that have 20 in the stat column and the denominator has to be all rows that have 11 in the stat column.  Am i correct?  Share the link from where i can download your PBI file.

  • SadStatue's avatar
    SadStatue
    Helper II
    5 years ago

    Hi Ashish_Mathur ,

    Thank you for your comment. No I have some more considerations in calculation of this conversion rate. I want to find the rate that 11 (Interviewed applicant) turned to 20 (Employed). So there should be an 20 for counted 11 (on the same ref ID/job position) and also the 11 time stamp should be before the time stamp of related (on the same ref ID) 20 .
    in the sample data there are two 11 that I dont want to count as below:

    You can find the whole data here, but lets start working with the sample data.