Hi All, I have searched and read many articles but have not found an answer or post which matches my criteria.
This is a very simplistic example but I hope it makes it clear. I have 5 users and 3 bats. The green bat has a problem so I need to filter out the users who only only ever use the green bat, in this sample it would be Ryan and Susie, regardless of of date.
I created a data table and with users for rows and I can set the columns to show the unique count of bat used - Bob and Sally = 2, Joe = 3, and Ryan and Susie = 1. I also tried column filters by bat which is correct but when I try to filter just for the green bat, I also get Joe and Sally who don't meet the criteria as they also used other bats.
How can I isolate just Ryan and Susie? I don't have the timestamp in the visualization but I should come up with a count of 2.
Thanks for the help!