I'd love to see an enhanced Table widget that allows for pivot table functionality in ExB which could be used to provide complete summaries of sites in a simple pivot table rather than having to export raw data to csv and undertaking the Pivot in Excel.
Functionality would be similar to Excel Pivot Table :
Row, Column and Values Fields should all be able to be defined from the table being used
Filters would ideally have an ability to link to other filters enabled on the ExB site (Filter Widget or Map Filters)
Refresh timeframes for data updates to be defined in the setup
Ideally - Data would allow for integration of Parent and Related tables but this can be offset if needed by using a joined View.
thanks
mw
