The Tableau Performance Checklist: Calculations – Limit Blended Calculations

Data

The Tableau Performance Checklist: Calculations – Limit Blended Calculations

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.

Next up on the list of ways to make your dashboards be the best they can be, we take a closer look at blended calculations:

Limit blended calculations. They require sequentially querying multiple data sources and can be time-consuming. Where possible, create a view on the database server.

Occasionally, all of the information we need to tell compelling stories visually is nicely stored and prepared for us ahead of time. This is usually the result of hard work on the back end from our IT or Data Management teams (thanks guys!). Most times, however, this fairy-tale scenario isn’t how our data visualization journey begins. Rather, we slog through numerous data sources scattered across different platforms, servers, etc. Even with considerable data management efforts, there still may be a couple of disparate sources that need a little TLC in order to produce valuable insight. 

Blended Calculations

Tableau’s answer to this situation is the blended calculation, in which fields from more than one data source can be used in a single calculated field. For example, let’s say you need to need to produce a global sales figure across your organization, but each region’s autonomy in its data management practices means that the data is stored across four or five separate locations. You may be tempted to use Tableau to build the following calculation to yield your global sales figure: 

Tableau: Global Sales Calc

Steer clear of this temptation! While Tableau’s intuitive interface makes this kind of calculation very easy to create, it is less than ideal when considering the performance implications on your visualizations.

Potential Problems

Using blended calculations in Tableau is possible, but it’s not preferable. When you reference more than one data source in your calculated field, Tableau must individually query each data source separately to retrieve the values for your calculation. Remember this rule: Your visualization can only be as fast as your slowest data source.

Not only do you run the risk of waiting on a particularly slow data source, but you’re forcing Tableau into extra steps to pull down the data required to complete the calculation. That incrementally adds to the loading time of your visualization, which can be rather onerous with large data sets.

But abandon not hope, ye who enter. In the case of our example discussed above, a better alternative to a blended calculation would be to prepare a new view on the database server. This keeps the data processing and querying outside of Tableau and allows the tool to do what it does best – quick and flexible data visualization.

Performance Analyzer

The good news is that our Performance Analyzer tool, part of our Power Tools for Tableau suite, peeks under the hood of your workbooks to check for blended calculations along with other items. It will even show you the specific calculation potentially causing slowed performance, like so:

Tableau Performance Analyzer

So, for the low, low price of free, why not take the Performance Analyzer (and really all of the Workbook Tools) for a two week spin to see all the ways it can make your Tableau life easier? Download now and run your workbooks through to see what other tips and tricks you can discover. A few seconds to complete each analysis and receive expert advice, knocking your dashboards into tip top shape, seems like a no-brainer to me. Furthermore, you’re getting the functionality of a collection of other tools bundled with the Performance Analyzer. 

Think “Efficiency”

Calculations are a very powerful feature in Tableau Desktop, but we would do well to keep in mind Uncle Ben’s wise words on great power. In many cases, a bit of extra prep with your database administrator at the data layer goes a long way in achieving the same visualizations far more efficiently. Of course, this takes a bit of up front consideration when it comes to the questions you want to ask or stories you hope to tell, but many Tableau experts stress the importance of this design and planning stage in their own work. So, once we’ve planned out our brilliant dashboard, let’s make sure the data to build the story is prepared ahead of time and avoid the spinning wheels that often come hand in hand with blended calculations.

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

Jimmy Steinmetz

Solutions Lead
Debriefing My Trip to Dataiku HQ Recently, David Siegel, Rachel Kurtz and I spent the day with the team over at Dataiku HQ in New York to learn about the platform and ...
A Quick Exasol Script for Building Python UDFs A client recently had a challenge wanting to use Exasol’s User-Defined Functions with a Python script, but they were having a hard time ...

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