Set analysis - compare two value for calculation

[#1]

Hello,

I'm having this issue and couldn't be able to figure it out.  Please help.

I am having two condition on my calculation, below is my expression.  I'm using chart pivot table

=count({<columnA={'A'}, column_id_a=column_id_b >} DISTINCT column_ticket

)

Name	#assigned	#closed
agent A	250	150

Thanks,

Trisha

[#2]

ah, i can upload the file now.  🙂

[Clever_Anjos]

It woulb nicer if you have a field with TL_IM_Open_Time formatted

I´ve done with "if" (it´s not the better way, but works)

Download it at : https://docs.google.com/file/d/0B-gcl9bj_QQJVDcyZUpKVmh5WlE/edit?usp=sharing

[#4]

Hi,

Yes, i have formatted the _Open_Time field in the original file.

btw, i can't open the link you sent, keep showing "internet explorer can't displayed".

Thanks!

[Clever_Anjos]

There´s a link to donwload

[#6]

Hi,

There is a blocked on proxy server from work, so i have to send the link to ask someone download it for me. 😞

Thanks for the file. I had it here and tested it.  The assigned works fine, but the "touched" didn't work.

It doesn't like "not in -->  -= ) syntax  so it still returned 0

Thank you so much for helping me out.  I'm stuck with this for couple days now.