Any table that lives in an SQL-based data source (SQL Server, Oracle, MySQL, Excel, Access, and more) is a great candidate for Visual KPI’s Tables feature. Here, we show you how easy it is navigating tables in Visual KPI.
You set up tables in Visual KPI Designer. Learn more
The Tables tab on Visual KPI’s main navigation menu displays any tables available in the group you are currently viewing.
Note: Not all Groups have tables in them. If there are no tables in the group you are viewing (or its child groups), the Tables tab will disappear. If the Tables tab is grayed out, there are tables in child groups. You can click the grayed out tab to see all tables within child groups.
For example, if you are looking at the top-level group, you’ll see a list of all the tables.
If you drill down into a sub-group, you’ll see a list of tables for that sub-group.
You can see a maintenance log, shift report, error list, or any other tabular data you have access to right in your browser or mobile device. Just like every visualization in Visual KPI, tables automatically resize based on screen size, and you can scroll to see all of the data in the table. You can configure multiple tables from the same data and add color and icons to your tables to highlight status based on parameters you set.
View all Tables for all Groups
The quickest way to see all tables in your Visual KPI site is to click the Home icon (), which takes you to the Home Group, and then click Tables ( ) in the navigation bar. You’ll see all tables for the top-level group here.
To expand this list to see tables for all child groups, click the Show Tables for this group and all child groups icon (). Click the icon again () to show only tables for the current group.
To open any table in the list, click on its name in the list.
Get More Info About a Table
If you are in the Tables list view, click the More icon () in any table to open a drop-down panel that shows some basic information about the table.
The View Full Table Details icon () opens the System Configuration Details screen. This gives you detailed information about the configuration of the table set up by your admin in the Visual KPI Designer.
Some Things You Can Do with Tables
Use the Export to CSV icon ( ) to export table data for further analysis.
View the raw data from a table by clicking the View Raw Data icon ( ).
Raw Table data can be sorted. Use the headers and double arrows () to sort by any column. Once you have sorted by a single column, you can sort by a second column by holding down the shift key and clicking on the second column you wish to sort.
The Search Table icon ( ) allows you to search dynamically for anything within the table. This is especially useful for tables with lots of data.
You can also search Table columns. Click at the top of any column to search based on the information in that column.
Share tables using the Share icon ( ).
You can do so much more with tables. Contact us if you want to really jazz up your tables in Visual KPI.
Learn more about working with Charts & Tables in this video lesson. Sign up for Visual KPI Training. It’s free!