Rate of users who are active from 5 years.

[girish21595]

Hi All,

I have a table with [license id], start date, end date... 

I need the rate of users who were active 5 years ago.

i.e., count( [license id] whose ID is active from 5 years) / total count( [License id] who were active 5 years ago.)

scenario: In 2005 (a,b,c,d,e) were the active users. (g,h) were joined in 2006 and (a,b,c) left in 2007. 

Suppose we are in 2010 and the rate = 2/5.  Which is (d,e)/(a,b,c,d,e). I should not consider the users added in between.

I need this as a yearly trend.

Thanks

Girish

[anushree1]

how do you want to show this do you want to display active users on a text box?

[girish21595]

Nope I want it as trend with year as dimension

[anushree1]

Please check if the attached file works

[girish21595]

Hi Anushree,

The qvf which you attached didn't work.

I have attached a sample data file and the application. I almost got the answer. In UI I added a table. If I select a year, I am getting the correct answer. Please have a look at the measure and let me know if any corrections.