Count with if

[sai_12]

Hello everyone

I am using the following on a table to get if a client is active or inactive

if([Phone Call]> date(Today()-56) or (Aggr(max(Email_Creation_Date),[client_id])>date(Today()-56)) or (Aggr(max(SMS_Creation_Date),[client_id)>date(Today()-56)),'Active','Inactive')

How can use this to count number of active and inactive users, in kpi chart

Question

Requirement is to show  how many active and inactive currently i know if a particular client is active or inactive

[Digvijay_Singh]

Its important to plug-in your table dimensions in the expression I think and it should be something like -

Sum(if(Expression,1,0)) 

But I don't understand how ([Phone Call] is used without any aggregation function in your expression, is it having just a single row per client?