12 Replies Latest reply: Dec 27, 2017 11:22 PM by Isabel Encinas

# count if multiple dimension

Hi Everyone,

I'm trying to count those ID Conversations that were answered within 30seconds.

I just do not know how to insert the [nAnswered] condition on the below.

• ###### Re: count if multiple dimension

HI Isabel,

Count( Distinct {<tAnaswered={"<=30"},nAnswered={1} >} [ID: Conversation])

I hope this helps,

Luis

• ###### Re: count if multiple dimension

I do not know the reason why it is counting 32.38 . It should be 0

• ###### Re: count if multiple dimension

I think it's because 32.38 comes from a Sum, and you seem to be trying to use the direct value

• ###### Re: count if multiple dimension

hmmm

how can I insert sum function here? I should sum the tAnswered

• ###### Re: count if multiple dimension

But if you only want it in a table like you have in the post then you just need a calculated one:

If you need it as a KPI then this should do:

Count( Distinct {<tAnaswered={"<=30"},nAnswered={1} >} [ID: Conversation])

I hope this helps,

Luis

• ###### Re: count if multiple dimension

this returns everything to 0.

• ###### Re: count if multiple dimension

You're not comparing it correctly as you're displaying Sum(tAnaswered) but then using the field without aggregation in your IF

• ###### Re: count if multiple dimension

Hi Isabel

try this

or

• ###### Re: count if multiple dimension

you're the best!

it worked! Thanks a lot

• ###### Re: count if multiple dimension

Please see if this example helps you:

Cheers,

Luis

Edited: changed data as two rows were clubbed together

• ###### Re: count if multiple dimension

it is not working on my end

• ###### Re: count if multiple dimension

Hi Isabel,

If you want, reply to this post, then use the advanced editor and attach a sample of the data, just raw data with ID, Date, timetoanswer and if it was answered (1/0).

I'll prepare a qvf and will send it back to you for review

Cheers,

Luis