3 Replies Latest reply on Jun 28, 2016 4:22 PM by Shaun Currier

# Line plot of top N dimension values + "other"

Hello, I have some data similar to this:

Part Name   |     Somefield1     |     Somefield2     |     Date

Part Name A  |     blah               |     blah                 |     somedate

Part Name A  |     blah               |     blah                 |     somedate

Part Name A  |     blah               |     blah                 |     somedate

Part Name B  |     blah               |     blah                 |     somedate

Part Name B  |     blah               |     blah                 |     somedate

Part Name C  |     blah               |     blah                 |     somedate

Part Name C  |     blah               |     blah                 |     somedate

Part Name D  |     blah               |     blah                 |     somedate

Part Name E  |     blah               |     blah                 |     somedate

Part Name E  |     blah               |     blah                 |     somedate

Part Name E  |     blah               |     blah                 |     somedate

I'd like to make a line plot with the following characteristics.

Columns: dates from the "Date" column

Rows: count of rows

Color: part names from the "Part Name" column

Mark type: line

This should give me one colored line per part name.  Trouble is, there are many distinct part names and I only want to show the top 5 or so to keep it from being confusing.  The remaining part names (call them the "Bottom M") I want to all be lumped together into a grey colored "other" line whose value is the count of rows from the non-Top N part names.

How can this be done in Tableau?

• ###### 1. Re: Line plot of top N dimension values + "other"

Further clarification... please understand that the part names not just A through E, but many names, more like A through ZZ.

• ###### 2. Re: Line plot of top N dimension values + "other"

Hi Shaun,

Please don't hesitate to search on the forum as this particular question has been asked a bunch. Here's the answer for reference - Create Sets for Top N and Others | Tableau Software

1 of 1 people found this helpful
• ###### 3. Re: Line plot of top N dimension values + "other"

Hi Tom.  You're right.  I actually had done extensive searching, but the solutions weren't working for me.  Since I've made the thread, I figured out what the distinction is between the problem that that link solves and what my problem actually is.  I made another post here to better explain that: Top N on filtered data - sets don't seem to work

In short, the problem is that my view is being filtered and the sets don't seem to be subject to filters, so the scope of the set's Top N is incongruent with the scope of the data in the view.