Increasing your data-pixel ratio in KPI lists

Data

Increasing your data-pixel ratio in KPI lists

by Ben Sullins

Building on the KPI tutorial from Tableau found here, I would like to add a neat trick to increase your data-pixel ratio and remove additional clutter from your KPI charts by using a custom shape. The premise is based on Stephen Few and Edward Tufte’s principle to reduce the redundant non-data pixels and increase the data visualizations effectiveness. So, here’s how:

  1. Download the workbook from Tableau’s tutorial here: kpi_0.twbx or go through it and build it yourself.
  2. Download this custom shape (14.png) and save it to C:My DocumentsMy Tableau RepositoryShapesKPI
  3. Open the workbook with the KPI’s and edit the shapes, converting the ‘Above Benchmark’ to the blank white shape in the KPI category. You may have to ‘Reload Shapes’ before it shows up. Also, you won’t see it but hover in the bottom left and it should show up.
  4. Click OK and you’ve done it!

Before

After

The data-pixel ratio now is significantly higher and you’ve succeeded in making this view more effective by removing redundant icons from your visualization. I will say that this assumes the most important purpose of this view is to identify KPIs that are ‘Below Benchmark’. Enjoy!

More About the Author

Ben Sullins

Business Intelligence Consultant
Adding Google Analytics to Your Tableau Server If you’re a Tableau Server administrator or publisher of content to Tableau Server, then you probably at some point wondered how ...
Migrating Tableau Server to a New Domain In general, Tableau Server is relatively easy to administer. This is in large part due to having very few configuration items you can ...

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

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072