Introduction
Table visualization is an essential part of any dashboard or data app; tables allow users to see a detailed view of the data and to get to the bottom of insights findings.
With sparklines and other mini-charts table can also visualize important KPIs for different entities and allow users to compare the performance of the different entities.
Here's a concise overview of the value of table visualization in data analytics:
Organized data presentation: Tables structure information in rows and columns for easy scanning
Quick data comparison: Allows side-by-side comparison of multiple data points
Precise value display: Shows exact numeric values without approximation
Handling large datasets: Can display many data points compactly
Sorting and filtering: Enables interactive exploration of data
Highlighting patterns: Can use color coding or conditional formatting to emphasize trends
Versatility: Suitable for various data types (numeric, categorical, text)
Familiarity: Most users are comfortable with tabular formats
Introduction
Data Tab Settings
Filter Tab Settings
Style Tab Settings
Layout Tab Settings
Progress bars
Column Types
Dimension
Dimension columns are fields that set the details level of the data in the table.
Dimension columns are using fields as they appear in the data source.Dimension Settings
Custom label- define the label for a dimension by either entering a manual value or by using a variable for a dynamic label.
Format type- define the display format for the values in the dimension.
Visual representation- define the visual display of the dimensions by selecting one of these options:
Text- showing the values in the dimensions as they are.
HTML- customize the look and feel of values by using an HTML code loaded in another field.
Link- The dimension is a string link to another website page. You can define the label either manually or using another field.
Image- show a picture. The dimension is a string that is a link to an image.
The image below shows the four different representations of the same field.
Show null values- if checked, null values in the dimension will be presented in the table.
Hide column- the dimension will be hidden from users but part of the query and the table structure.
Measure
Measures columns show the results of any calculation; the result can be either numeric or text.
Measure Settings
Custom label- define the label for a dimension by entering a manual value or using a variable for a dynamic label.
Format- select the format for the measure display
Visual representation- define the visual display of the measure, selecting one of these options :
Number - show the measured value as it is
Mini chart(sparkline)- select an additional dimension to split the result and show it as a chart.
If you would like to learn more about mini charts, you can check this article.Progress Bar- show the measure values with a bar.
The range to the progress bar can be set dynamically or manually.
Dynamically, we will calculate the min and max values according to the values of the measure in all rows in the table.Image- Show the measure results as an image, which is only relevant for string measures.
Icon- show an Icon near the measure.
Progress Bars
Progress bars are small bar visualizations helping understand scale at a glance in tables.
