Creating Custom Column in View with filtered column

There is a metric that I am using for a view in a widget, as shown below: 

`(COUNT([user_id], [status])/COUNT([user_id])`

 

I have a view where I have a user_id and status column. I want to create a metric with only a count of user_id where status = 'ACTIVE' as the numerator. Then I want to have just COUNT(user_id) as a denominator. 

I want to create a custom column in the view with this value. Can anyone please advise?