Showing results for 
Search instead for 
Did you mean: 

Creating Custom Column in View with filtered column

10 - ETL
10 - ETL

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?


10 - ETL
10 - ETL

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



Or do you mean something else?


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