Set Analysis with count

[evansabres]

I have an expression, =NUM(COUNT(IF(LOCATION = '100 BRIDGE',(TICKET_ID),'#,###.')))

I am counting the ticket id, as they are unique values that are 'scanned in' to an event. Counting them gives me a total for attendance.

What I want to do is introduce a condition in the equation to count the number of 'Ticket ID' that are scanned at different locations.

The expression is constructed correctly and allows me to proceed, however does not produce the intended result. For example, for one event, I have 10,000 scans, 5,000 should be at '100 Bridge' and the other 5,000 should be at '200 Bridge.' Currently my table is just showing the same values for each column.

Am I going about this incorrectly?

[sunny_talwar · Accepted solution]

Not sure I understand, but may be you need this

=Num(Count({<LOCATION = {'100 BRIDGE'}>} TICKET_ID), '#,###.')