cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Custom Column in View with filtered column

amelia
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?

2 REPLIES 2

Angelina_QBeeQ
10 - ETL
10 - ETL

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

Angelina_1-1657790528830.png

 

Or do you mean something else?

 

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