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,

  • SadStatue's avatar
    SadStatue
    Helper II
    5 years ago

    Hi v-xulin-mstf ,

    Thank you so much for your time and effort to find the solution. Its woorking perfectly.

     

    Cheers,

  • SadStatue's avatar
    SadStatue
    Helper II
    5 years ago

    Hiv-xulin-mstf 

    Thanks for your response. I used your suggested solution but I noticed that its not working properly!! as we manage part of the filtering in a column which make it so undynamic!
    I believe we have to manage the whole filtering and calculation in measure level and not in the columns as I want to show these conversion rates in bar chart (conversion rate per month).
    so it calculate all the record with stat 20 and devide by all record with stat 11 and column=1. so our measure fail to filter stat 11s that have the same reference_ID (position).
    It would be great if you can have another look on it

    Cheers,