10 Replies Latest reply on Nov 11, 2017 7:34 AM by Nipa Madhani

Highlight Max Number in each column of table

Mark Bennitt Feb 5, 2015 11:24 AM

I have a viz that is your standard table, 6 columns by 6 rows. What I would like to do is have the maximum number from each column stick out in some way, whether by changing the background color of that cell or using some sort of symbol. I have attempted to use the size feature with my counts but it did not look right. Does anyone have any suggestions?

1. Re: Highlight Max Number in each column of table

gaurav.fouzdar Feb 5, 2015 11:31 AM (in response to Mark Bennitt)

By default it's the maximum value for columns and rows is set 6 but you can increase the same upto 16. Check the following link:
Controlling Row and Column Concatenation | Tableau Software
Like Show 0 Likes(0)

Actions
2. Re: Highlight Max Number in each column of table

Mark Bennitt Feb 5, 2015 11:32 AM (in response to gaurav.fouzdar)

I apologize for not being clear in my question. I want the maximum value in my table for each column to be highlighted so that the user can quickly identify that number.
Like Show 0 Likes(0)

Actions
3. Re: Highlight Max Number in each column of table

gaurav.fouzdar Feb 6, 2015 7:57 AM (in response to Mark Bennitt)

Then probably you should use descending sorting for the required table.Check the following:
Setting a Default Sort Order | Tableau Software
Like Show 0 Likes(0)

Actions
4. Re: Highlight Max Number in each column of table

Matt Lutton Feb 6, 2015 8:03 AM (in response to Mark Bennitt)

Hi Mark:

If you can post an example TWBX utilizing Superstore Sales, or another sample data set, as well as a mockup of your expected results for that data, I will be happy to take a look.

Conditionally formatting in Tableau can be difficult when approaching it from how other tools work. A great resource for learning and understanding what is possible can be found below (be sure to download the workbook so you can read/study the captions in each sheet)

http://community.tableau.com/docs/DOC-1072
Like Show 1 Likes(1)

Actions
5. Re: Highlight Max Number in each column of table

KK Molugu Feb 6, 2015 8:09 AM (in response to Mark Bennitt)
Mark:

Its a little bit tricky, but based on your questions you are looking to highlight or visualize if the value in a column is the max. This is what I have and hope this helps and what you are looking for.

..kk

Window Max - 156092-kk.twbx 1.4 MB

4 of 4 people found this helpful
Like Show 6 Likes(6)

Actions
6. Re: Highlight Max Number in each column of table

Mark Bennitt Feb 6, 2015 8:21 AM (in response to KK Molugu)

This is EXACTLY what I needed. Thank you!
Like Show 0 Likes(0)

Actions
7. Re: Highlight Max Number in each column of table

Joshua Preston May 12, 2017 7:47 AM (in response to KK Molugu)
Hey KK - how would you modify this calculation to get the do a window_max for the individual columns (age) here? Workbook 10.2.1 attached.

thx in advance?

selfies_test.twbx 23.5 KB
Like Show 0 Likes(0)

Actions
8. Re: Highlight Max Number in each column of table

mafalda.santos Aug 17, 2017 11:59 AM (in response to Joshua Preston)

Hi Joshua,

How did you solve this problem?

Thanks in advance

Mafalda
Like Show 0 Likes(0)

Actions
9. Re: Highlight Max Number in each column of table

Vincent Baumel Aug 17, 2017 1:20 PM (in response to Joshua Preston)

Joshua-

Keep the Window_Max field on color, but set it to compute using Table (down)...
Like Show 0 Likes(0)

Actions
10. Re: Highlight Max Number in each column of table

Nipa Madhani Nov 11, 2017 7:34 AM (in response to KK Molugu)

Hi,

Can you please share the code for window_max. Ican not open your file, as I am using Tableau Public.

Thanks
Like Show 0 Likes(0)

Actions