In today’s blog we’ll take a look at one of Tableau’s most famous features. In my Tableau Public, you will notice that I often use parameters. They are so versatile and allow you to provide the user with the interactivity they need.

But what exactly are parameters? How do they work? Hopefully you’re getting excited. You will get a full explanation of everything, some user cases, and a example that shows Top and Bottom N at the same time, with the user controlling N.

What are parameters? Learn more here

Some user cases examples

  1. Pre-defined filters.
  2. What-if analysis
  3. Swapping Dimensions or Measures
  4. Reference Line
  5. Top and Bottom N

Walk trough exercise – Top and Bottom N
Imagine you have a sample data set where you would like to show some insights about the products based on the volume of orders. It makes sense to show this in a bar chart, but you don’t know what information is best to include. The most popular products? But what about the less popular ones?

Okay, so you’ve decided to make two charts and set up some filters to display the top and bottom N products. My guess is that you noticed that your charts are a bit off. That’s right, they’re statists! The user cannot interact with it or change the N number further. It would be great if you could create parameters for this. So, let’s begin, we’ll use the Superstore Data sample for this example. This is not news to you!

Let’s start by putting some nice music on. Perhaps you’d like something different, here is my Spotify playlist.

1. What do we do?
In this opportunity, we want to identify the five most profitable products and the five least profitable products, and we want to be able to change these values. To do that, we’ll use parameters with combined sets. You can learn more about sets here.

2. Create the parameters
First, make the TOP N, then duplicate it, and rename to Bottom N. It’s that easy!

3. Create the sets
One more time, first make the TOP N set first, then duplicate it, and rename and select Bottom N instead.

4. Combine the sets
We’ve got the two sets ready, now let’s combine them. Select both, and then right-click, then click on Create Combined Set.

5. Put all together
Remember when you used individual filters to show top and bottom products? The combined set can also be used as a filter. So, let’s put everything together as follows.

6. Here it is!

All right, that’s all. Now you’re able to use parameters and sets. Thanks for checking it out! I hope you enjoy it. I look forward to seeing you soon. You can see my Tableau Public here.   See you soon on my next blog, and if you’re looking for new tunes while learning new cool stuff or preparing for your Alteryx certification, check out my Spotify playlist here.

Antoneely Calizaya
Author: Antoneely Calizaya

Antoneely is a curious and lifelong learner, and she has become fascinated by a wide variety of business challenges she has encountered throughout her career. She is currently pursuing a Master’s in Business Analytics and has a Bachelor’s in Management and Marketing. She is passionate about data-driven decision making and enjoys working with complex data problems. She has six years of experience including a mid-level position in management, developing projects and implementing strategies. When she matched her passions and interests, it was clear that she wanted to learn as much as she could about data analysis, data science, machine learning, and new technologies. Her favourite new platforms are Alteryx and Tableau. She’s constantly seeking new things to learn and is always up for new ways to challenge herself. She finds fascinating books about the brain, creativity, subconscious mind, and mindfulness. She enjoys hosting meetups related to fun outdoor activities. The latest hobbies she enjoys are pole fitness, video editing, illustrating with her Wacom, and she’s looking to join a footy team. Antoneely’s long-term goal is to use all her data superpowers to contribute to improving access to equitable and quality education, emphasising rural areas, and vulnerable populations.