Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I did distinct(CustomerID) for a count of individuals that registered for AM 2012, 2013 and 2014.... but I want to find out who went to ALL three of the meetings, 2012 and 2013 and 2014, instead of just giving me the number of individuals that went to said meetings (or statement):
When I run a nested select statement sql query of:
select count(distinct CustomerID)
from EventList
where eventtitle = 'Annual Meeting 2012'
and CustomerID in
(select distinct CustomerID
from EventList
where eventtitle = 'Annual Meeting 2013'
and CustomerID in
(select distinct CustomerID
from EventList
where eventtitle = 'Annual Meeting 2014'));
I get 288 distinct individuals that went to ALL THREE events. Does this make sense? If so how would I accomplish this?
Thanks,
Joe
This may require some data model manipulation:
You can also use the and operator in set analysis to get your result form the selection
And Operator in Set Analysis
Hi,
Try like this
=Sum(Aggr(If(Count({<Category ={'Annual Meeting 2012', 'Annual Meeting 2013', 'Annual Meeting 2014'}>} DISTINCT Category) = 3, 1, 0), CustomerID))
Hope this helps you.
Regards,
Jagan.