Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Please help.
I'm trying to count those ID Conversations that were answered within 30seconds.
count id conversations if [tAnswered]<=30 and [nAnswered] =1
I just do not know how to insert the [nAnswered] condition on the below.
Count({<[Aggr tAnswered]={'<=30'}>}Distinct [ID: Conversation])
Hi Isabel
try this
Count( Distinct {<[Aggr tAnswered] ={"=sum([Aggr tAnswered])/1000<=30"},[Aggr nAnswered] ={1}>} [ID: Conversation])
or
sum(If([Aggr tAnswered]<=30 and [Aggr nAnswered] =1,1,0))
HI Isabel,
Please try this:
Count( Distinct {<tAnaswered={"<=30"},nAnswered={1} >} [ID: Conversation])
I hope this helps,
Luis
I do not know the reason why it is counting 32.38 . It should be 0
But if you only want it in a table like you have in the post then you just need a calculated one:
If(tAnaswered<=30 and nAnswered=1,1,0)
If you need it as a KPI then this should do:
Count( Distinct {<tAnaswered={"<=30"},nAnswered={1} >} [ID: Conversation])
I hope this helps,
Luis
I think it's because 32.38 comes from a Sum, and you seem to be trying to use the direct value
If(tAnaswered<=30 and nAnswered=1,1,0)
this returns everything to 0.
hmmm
Count( Distinct {<[Aggr tAnswered/1000] ={"<=30"},[Aggr nAnswered] ={1}>} [ID: Conversation])
how can I insert sum function here? I should sum the tAnswered
You're not comparing it correctly as you're displaying Sum(tAnaswered) but then using the field without aggregation in your IF
Please see if this example helps you:
Please let me know,
Cheers,
Luis
Edited: changed data as two rows were clubbed together
Hi Isabel
try this
Count( Distinct {<[Aggr tAnswered] ={"=sum([Aggr tAnswered])/1000<=30"},[Aggr nAnswered] ={1}>} [ID: Conversation])
or
sum(If([Aggr tAnswered]<=30 and [Aggr nAnswered] =1,1,0))