cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
steviea Frequent Visitor
Frequent Visitor

Normalize Age of Cancelled Accounts by Age of Currently Active Accounts

I have a column with start and end dates of cancelled accounts as well as the number of days between those two dates. I have another table with currently active accounts, the start dates and number of days since start for those accounts. I want to plot, over time, the average age of cancelled accounts. Naturally this is going to trend upwards as the company gets older, especially since were only 4/5 years old. I want to normalize it to look at the average normalized by the age of active accounts but don't know where to start. Any help would be greatly appreciated!

1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Normalize Age of Cancelled Accounts by Age of Currently Active Accounts

Hi @steviea ,

 

Please elabrate your requirement with sample data and show us desired output.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.