filters

2024 Week 40 | Sigma: Can you avoid the food?

Introduction Welcome to Week Forty! In my last article,  Week 36, we covered how to affect multiple columns using the same filter.  This week, we’re going to focus on even more advanced filtering techniques.  What do you do when you want to compare multiple arrays?  Luckily Sigma recently released a brand new function:  ArrayIntersection.   In …

2024 Week 40 | Sigma: Can you avoid the food? Read More

2024 Week 36 | Sigma: Can you filter without targets?

Introduction Welcome to Week Thirty-Six! This week, we’re going to focus on some more advanced filtering.  By now, you should know how to utilize a page control’s targets to filter a single column in an element.  What do you do when you need to affect multiple columns in the same element?  You can utilize a …

2024 Week 36 | Sigma: Can you filter without targets? Read More

#WOW2024 | Week 26 | Can you filter from a donut without highlighting the pie?

Introduction I was recently catching up on the Flerlage Twins blog, and came across a post that I had somehow missed from the end of  last year about trying to solve a highlighting problem with donut charts when filtering. I read through it, and was surprised that my favorite technique from Yuri Fal didn’t work, …

#WOW2024 | Week 26 | Can you filter from a donut without highlighting the pie? Read More

2020 Week 49: Can you toggle between AND & OR filtering logic?

Introduction Sam Epley (100% completion club #WOW2020) is responsible for this week’s Workout Wednesday Challenge.  Here are all the details in Sam’s own words: Several months ago, I was working with a client who wanted to provide their end user with some pretty clever functionality I’d never seen before. They wanted their user to be …

2020 Week 49: Can you toggle between AND & OR filtering logic? Read More

Scroll to Top