How to use Count with Two Criteria as Dimension

[#1]

HI,

I have data structured like this

Recipient	Action	Valid	Date
emailAddress1@noemail.com	RECEIVED	1	01/01/2013
emailAddress1@noemail.com	OPENED	1	01/01/2013
emailAddress2@noemail.com	RECEIVED	1	01/02/2013
emailAddress2@noemail.com	RECEIVED	1	02/01/2013
emailAddress2@noemail.com	OPENED	1	04/02/2013
emailAddress2@noemail.com	CLICKED	0	05/01/2013
emailAddress5@noemail.com	RECEIVED	0	05/01/2013

My hope is to make a bar chart that will have the number of emails received (Action=Received & Valid=1) as the Dimension on the X axis and the number of Recipients on the Y axis as the expression,  This way I can see how many people received 1, 2,3...N email. 

I tried this with no luck as the dimension: =count({<Valid={'1'},Action={'RECEIVED'}>} Recipient)

many thanks

[maxgro · Accepted solution]

if I understand your question, try this

dimension

aggr(count(if(Valid=1 and Action='RECEIVED', Action)), Recipient)

measure

count(distinct if(Valid=1 and Action='RECEIVED',  Recipient))