Documentation

Tables

By definition, a table isn’t a type of visualization; they display your data in its most raw format. They are great to show a larger number of measures and dimensions of your data. Thanks to tables, you can look up individual values and at the same time display grand totals. This is particularly helpful when you have an audience that needs to know the core of your data, or when your audience wants/needs to know what your results are precisely made of.

 

For a more advanced table, you can add a field to Decompose by, a function that will even allow you to create a pivot table with ease.

 

Styled Table Example datapine

 

But keep in mind that in spite of the easiness to generate it, tables are not exactly pleasing to the human eyes: we read tables. This is why they are not a visualization type per se, and take longer to assimilate. Besides, we would not recommend you to use a table if you need to identify trends, patterns and relationships.

 

Therefore, when it comes to tables the customization of colors and format is particularly important: font size and style, headers, row and columns aspect. You should nonetheless remain careful on how you use them in order to increase comprehension and perception, rather than decrease them.

 

To help you with that, datapine’s tables come with a large set of style options that let you define custom colors, border styles, font types and number formats. You may also add custom columns based on the table columns and use advanced functions such as a gradient background for low to high value visualizations. Use the conditional formatting options to highlight variances or apply a unique set of style elements to customize your tables just like you would do in Excel. To learn more about the Table Style Option, please click here.

 

 

Tip: Tables are escpecially suitable to display a larger number of text or string values. Simply drag and drop the text field into the X-Axis dimension and any other field you wish to measure into the Y-Axis. With a right click on the table headers you may hide the second column to exclusively display the string values.