Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to include a condition in my set analysis.
I have the following table, where I would like to count the SubscriptionID's that has Status 7 and a status 2. So I would like to count ID nbr 123 but not 124. How can I do this?
This expression gives me both 123 and 124:
=count({$<Status={"7"}>} distinct SubscriptionID)
Table:
Load * inline
[
SubscriptionID, Status, Date
123, 2, 2014-01-01
123, 6, 2014-02-01
123, 7, 2014-03-01
124, 7, 2014-03-01
125, 2, 2014-01-01
125, 6, 2014-02-01
];
Thanks
Thank you!
Exactly what I needed!
Works perfect thanks a lot