Wednesday, 11 January 2017

Pseudo Conditional Formating A Table in Tableau



Ever wanted to colour entire rows of a table in Tableau based on a condition? Well, you can, sorta, check out the video below on how to do it, or read one for more info. 






In this example I have a table looking at Tableau data extracts and I want to know which ones belong to archived projects so that I could turn off the update and take a bit of strain off the server. 


This calculated field looks at the project that the extract belongs to and sees if the word archived is contained within it.  If it does it gets the value of True, if not, False. This is then added to the rows, and the header is turned off. This has the effect of putting all the Archived extracts at the top of the page. I've also added the field to the colour shelf to add a coloured mark.


The problem is, the highlighted part is just the small mark, i would much rather have the entire row coloured. So to do that we need to use row banding formating. 

1. Remove the archived field from the colour shelf. 


2. Show the Archived field header on the row. 





3. Next, we want to get rid of the 'abc'. To do that we can use the blank trick that Emily Kund (@emily1852) presented in her TDT
This is just a single string of two double quotes and then we put that new field onto the label shelf. 



4. Go to Format, Shading and select the row. 

5. Change the header to be the highlight colour, in this case, orange. That changes all the headers to be orange, except for the far right, where the row banding settings adds the grey band.

6. Next, we can change the row band to be white and move the level slider to the left. Each time we move it notice how the coloured banding changes. When its all the way over to the left we get just two bands. 
7. The reason we get the two bands is because of the boolean true/false result of the archive calculation. We don't need that header anymore so right click on it and un-tick show header.


And there you go. A nice coloured band across the top of the table, clearly highlighting the issues, rather than just the mark. 

Be sure to check out the youtube video above for more details and follow on twitter at @Matt_Francis 



Matt Francis

Author & Editor

Tableau Zen Master, Social Ambassador, Wrangler of Data, Vizzer of Data

8 comments :

  1. Thanks for sharing the information about the Tableau and keep updating us.This information is really useful

    ReplyDelete
  2. To acquire the research paper with the aid of internet procedure the customer must go through some approach like here https://mastergrades.com/. A business should always serve students of various degrees of study. Therefore, it should only employ writers who are well skilled on the use of writing formats.

    ReplyDelete
  3. Do you need free Google+ Circles?
    Did you know you can get these AUTOMATICALLY & TOTALLY FREE by registering on Like 4 Like?

    ReplyDelete
  4. BlueHost is ultimately the best hosting provider with plans for any hosting needs.

    ReplyDelete
  5. If you want your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (even if they're dating somebody else now) you gotta watch this video
    right away...

    (VIDEO) Get your ex CRAWLING back to you...?

    ReplyDelete

 
biz.