The Tableau Performance Checklist: Rendering – Limit Text Tables With Lots of Marks

Data

The Tableau Performance Checklist: Rendering – Limit Text Tables With Lots of Marks

by Zack Gorman

The Tableau Performance Checklist series is designed to help you streamline your dashboard performance and Tableau Server configuration. Each post expands upon one item listed in the master Tableau Performance Checklist.

Let’s take a look at the next item on our rending category.

Limit the use of detailed text tables with lots of marks.

Ah yes, the fabled Text Table.

Mark Counts

Let’s start this discussion by reviewing mark counts. We covered this in the previous Rendering article in the Tableau Performance Checklist series, but it bears repeating. Marks are the individual data points on your chart. Depending on your visualization, these can appear as bars, plots, lines or text.

The way you can determine how many marks you have on your worksheet is to look at the bottom left-hand corner of Tableau Desktop.

Mark counts Tableau Desktop
 
This particular example has 209 marks. That’s not a big number for Tableau, but these can grow quickly if you’re not careful.

Text Tables

Text tables, or cross tabs (or pivot tables in Microsoft Excel), can end up with a lot of marks. If you have six different columns across fifty rows of states, then you’re throwing up three hundred marks right off the bat. Most likely, your report consumer will miss the point of your viz unless you build in a ton of contextual help (and blinking arrows pointing at the particular cell of importance).

A visualization with a lot of marks is not only difficult to decipher, but it also takes more time to load. Depending on how many marks you’ve got and how hard it is for Tableau to get them out of your data source, that can make a noticeable impact on your worksheet’s performance. Let’s assume that each of these entries averages six characters ($xxx,xxx.xx), then the number of items that Tableau must produce just for the data marks for this text table grows to 3,300. Holy schnikes!

That’s the double whammy – hard to use and slow to load. 

Best Use of Text

There are very few instances when a text table is a better option than a more visual representation of the data. An easy substitution is the traditional bar graph, which easily compares performance across columns. Using other charts, you can create visualizations that are more easily interpreted and digested. You’ll have to decide on what is the most important aspect of the data you’re working with before choosing which chart will best capture the story of the data.

In addition, text tables are not all that interactive. That’s a big strength of Tableau Software. Nothing builds understanding like letting someone jump in and click around.

When you can avoid text tables, do it. Use them as supplementary print handouts for the people that want the extra detail or for people who just have a whole bunch of extra time to go row by row.

In situations where a text table must be used, consider using dashboard actions so that they only show a relevant selection of data as opposed to the whole data source. My go-to is to utilize a combination of dashboard containers and filter actions to display a subset of text data only when the user goes out of their way for it. It’s a relatively easy process. Once you have your text table built out, add a layout container to your dashboard (horizontal or vertical, depending on how you want it to function). Add the text table and another sheet in your dashboard to the layout container, and remove the title from the text table. Then, add a filter action to your dashboard. It won’t matter if you choose hover, select or menu, but be sure to select Exclude all values under the Clearing the selection will: option. The end result looks like this in practice:


  
This helps to keep the mark count down and only shows relevant information once someone engages with the dashboard. 

While every chart type has its place, the text table is perhaps one of the more over-used options. Excel users that transition to Tableau have a tendency to stay with the old tried and true. Be brave and jump into the other chart types. You’ll find that your report consumers will be grateful.

Mastering Best Practices

If you’re interested in becoming a Tableau Server guru, then learning these performance best practices is essential. Check back frequently as we add new posts and dive deeper into each point in the Tableau Performance Checklist.

Another great way to identify best practices is to leverage the insights offered by our Performance Analyzer, part of Workbook Tools for Tableau. It will examine all of your workbooks, worksheets, dashboards and data sources against a list of best practices to ensure that you’re using all the tips and tricks to guarantee your visualizations are moving at light speed.

As always, feel free to get in touch with us if you have any questions regarding performance or anything Tableau related! We’d be happy to help.

Contact Us!

Want More The Tableau Performance Checklist

  1. The Tableau Performance Checklist
  2. The Tableau Performance Checklist: Data – Keep Analysis Simple
  3. The Tableau Performance Checklist: Data – Bring in Only Needed Data
  4. The Tableau Performance Checklist: Data – Use ‘Describe’ to Explore
  5. The Tableau Performance Checklist: Data – Remove Unused Columns from Extracts
  6. The Tableau Performance Checklist: Data – Use One TDS File
  7. The Tableau Performance Checklist: Data – Use Extracts
  8. The Tableau Performance Checklist: Filtering – Minimize Quick Filters
  9. The Tableau Performance Checklist: Filtering – Avoid ‘Only Relevant Values’ in Quick Filters
  10. The Tableau Performance Checklist: Filtering – Avoid High-Cardinality Quick Filters
  11. The Tableau Performance Checklist: Filtering – Avoid Quick Filters That Drive Context Filters
  12. The Tableau Performance Checklist: Filtering – Keep Range Quick Filters Simple
  13. The Tableau Performance Checklist: Filtering – Use Dashboard Filter Actions
  14. The Tableau Performance Checklist: Filtering – Don’t Be Lazy with User Filters
  15. The Tableau Performance Checklist: Custom SQL – Limit in Live Connections
  16. The Tableau Performance Checklist: Custom SQL – Avoid Parameters
  17. The Tableau Performance Checklist: Custom SQL – Watch for Useless Clauses
  18. The Tableau Performance Checklist: Calculations – Use Calculated Fields Carefully
  19. The Tableau Performance Checklist: Calculations – Limit Blended Calculations
  20. The Tableau Performance Checklist: Calculations – Avoid Row-Level Calculations Involving Parameters
  21. The Tableau Performance Checklist: Rendering – Avoid High Mark Counts
  22. The Tableau Performance Checklist: Rendering – Limit Text Tables With Lots of Marks
  23. The Tableau Performance Checklist: Rendering – Minimize Image & Shape File Sizes
  24. The Tableau Performance Checklist: Rendering – Use Transparent Background PNGs
  25. The Tableau Performance Checklist: Local Computations – Server Performance
  26. The Tableau Performance Checklist: Local Computations – Table Calculations
  27. The Tableau Performance Checklist: Dashboard Layout – Limit Number of Worksheets
  28. The Tableau Performance Checklist: Dashboard Layout – Fix Dashboard Size

More About the Author

Zack Gorman

Analytics Consultant
The Tableau Conference 2016 Session Finder Tableau Conference 2016 is rapidly approaching, and data visualization aficionados from around the world will descend upon Austin. ...
Wheel of Presidents: A Different Way to Visualize Presidential Data in Tableau People working with Tableau come from many different backgrounds. They’re analysts, data journalists, graphic designers or just curious ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK