filters

2025 Week 20 | Year-over-Year Selected Metric Trends

Introduction Welcome to Week 21 of 2025! This report allows users to select a performance metric (e.g., Revenue) and compare its values across 2024 and 2023. It provides a flexible way to explore year-over-year changes and spot trends or anomalies through interactive visuals. Good luck! -Andrei Requirements Main Visual: Area Chart with Year-on-Year Comparison Green …

2025 Week 20 | Year-over-Year Selected Metric Trends Read More »

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 »

#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 »