SpreadsheetWEB Version 2.5 includes advanced data visualization and dashboard features that enhance existing data collection, analysis and reporting features. SpreadsheetWEB users can create advanced dashboards through a user-friendly browser based editor.
There four main components of dashboards supported in SpreadsheetWEB:
- Filters
- Data grid
- Pivot tables
- Charts
SpreadsheetWEB supports several filter types including listbox, combobox, radio button, checkbox, and sliders. Depending on the field type and characteristics, appropriate filter type can be selected by the user.
Data Grid lists selected data fields in a tabular view. Data is refreshed in realtime based on the filter selections. Data grid is optimized for performance to display very large data sets. Data Grid also supports visual icons to represent data similar to conditional formatting in Microsoft Excel. SpreadsheetWEB includes a large icon library and a formula editor to map them with data.
SpreadsheetWEB dashboards can also be enhanced with crosstab tables also knows as pivot tables. Standard formulas like Sum, Count, Average are supported to aggregate data in pivot tables. User can drill down in the data using built-in expand/collapse features.
SpreadsheetWEB supports various chart types and associate them with data fields. Dashboard users can interact with data visually through these charts. Following chart types are supported in this version:
- bar
- line
- scatter
- area
- pie
- polar
- bubble
Charts also include common expressions like Sum, Count, Average for data aggregation. Other chart features include zoom and print.
In conclusion, dashboard support in SpreadsheetWEB Version 2.5 provides an evironment for organizations to collect, analyze and visualize data all in one platform.
