#WOW2017 | 46 | Top N Customers

Introduction

EDITOR’S NOTE: This challenge was originally published on Emma Whyte’s Tableau blog which no longer exists. This challenge is republished here with the author’s permissions
 

This week I’ve taken a different approach to viewing our Top N Customers in Superstore. I recommend clicking the picture below to see the viz on Tableau Public. Interact with the viz to see what’s required this week.

Requirements

  • Allow the end user to select how many top customers to see. This should be a range from 1 to 20
  • Top customers is defined as those customers whose average sales per basket (order) is highest.
  • All other customers should be grouped in to ‘Other’
  • If the end user selects ‘Show Names’ in the dropdown they should see the customers names rather than ‘Other’
  • The title should change depending on the number of top customers selected
  • The Top N Customers labels in rows should change depending on the number of top customers selected
  • Match my tooltips and formatting exactly

Dataset

Use the most recent version of Superstore – otherwise You’ll need to download the data to re-create this viz.

Attribute

When you publish your solution on Tableau Public make sure to take the time and include a link to the original inspiration.  Also include the hashtag #WOW2023 in your description to make it searchable!

Share

After you finish your workout, share on Twitter and/or LinkedIn using the hashtag #WOW2023 @Tableau and tag @WorkoutWednsday @EmmaWhyte & @vizwizbi

 

Solution

Interactive

Scroll to Top