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

[Clever_Anjos]

try

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

and check if is what you need

[#3 · Accepted solution]

it works perfectly.  Thank you so much Clever Anjos.  You're the best!!!!

[Clever_Anjos]

You´re welcome.

So please mark it as correct answer and let me collect some points

[#5]

I thought I did.  Please check again and see if i did correctly. 

First time to post a request in this forum.

[#6]

hi "Clever Anjos", would you please help me one more issue related to it?

here is my syntax but it doesn't work.  Since my first two filter work fine, but it gave me too much duplicate record so i have to add one for filter for date.

=count({<columnA={'A'}, column_id_a=P(column_id_b),  column_date1=date(column_date2, 'MM/DD/YYYY')  >} DISTINCT column_ticket)

note:  column_date1 has this format  03/01/2013

column_date2 has this format  03/01/2013 08:15:45

I appreciate your help.

Trisha

[Clever_Anjos]

Try this:

=count({<columnA={'A'}, column_id_a=P(column_id_b),  column_date1={"$(=date(column_date2, 'MM/DD/YYYY'))"}  >} DISTINCT column_ticket)

[#8]

Hello,

Thanks for response.  I tried it several times even changed the date format but none of it works for me. 

This time it show 0.

[Clever_Anjos]

Could you post a qvw?

I´ll do it for you.

[#10]

i'm having a problem with uploading the qvw file. Still searching how to do it.