Creating Custom Column in View with filtered column

[amelia]

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?

[Angelina_QBeeQ]

Hi @amelia ,
Do you want to achive something like this and leave columns 1,2 and 5:

Or do you mean something else?

[amelia]

Thanks! I tried something like this but ended up resolving it on the SQL side. Thanks anyway 😄