-
1. Re: Excluding data with multiple attributes
Andrew ConnollyApr 1, 2016 10:27 AM (in response to Chris Labriola)
1 of 1 people found this helpfulHi Chris--
Try this level of detail calculation:
{ FIXED [Box]: COUNT(if [Items] = 'item 2' then 1 end)} = 0
Place it on the filter shelf and only select true values. This will only return boxes who have a count of 'item 2' equal to 0
More on level of detail calculations here
-
2. Re: Excluding data with multiple attributes
Chris Labriola Apr 2, 2016 6:53 AM (in response to Andrew Connolly)Hiya Andrew,
Thanks for the calculation. This is great and does exclude the Boxes that contain that item. LOD expressions are pretty awesome
Do you know of any way of implementation that would allow the user to filter these on the fly so they would function like quick filters? For our data, one "Box" may have over 10 "items" in them and our users would like to be able to filter activity.
Thanks again!
-
3. Re: Excluding data with multiple attributes
Andrew ConnollyApr 4, 2016 8:52 AM (in response to Chris Labriola)
1 of 1 people found this helpfulOne approach would be to set the IF statement equal to a parameter:
{ FIXED [Box]: COUNT(if [Items] = [item parameter] then 1 end)} = 0
This would let a user change which item is driving the exclude filter, but would only allow for one item to be selected at a time.
If you're wanting the user to be able to exclude boxes based on multiple items, I think you'll have to create multiple calculations and place them all on the filter shelf.
if { FIXED [Box]: COUNT(if [Items] = 'item 1' then 1 end)} > 0 then "Uncheck to hide boxes w/item 1" else "N/A" end
-
4. Re: Excluding data with multiple attributes
Chris Labriola Apr 11, 2016 2:34 PM (in response to Chris Labriola)Thank you for the helpful advice. We ended up implementing both types of calculations to get the desired results for our users.