Forum Discussion

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous -

 

I think you are going to want to essentially recreate the 3 measures used for retention, but with the "last quarter" filter you were using in AVERAGEX.  So create

 

[LQ Added]

[LQ Active]

[LQ Starting]

 

and then your [LQ Retention] is essentially the same formula

 

( [LQ Added] - [LQ Active] ) / [LQ Starting]

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

dedelman_clng I see. I will give it a try and let you know the outcome! Thank you for the advice.