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

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,