Most Collaboratory reports result in a table view of Activity data filtered for your specific query. These tables are dynamic, and can be sorted, filtered, and exported by Administrators.
Selecting a column in the table view will highlight the column and provide filter/sorting tools for the data:
Formatting Column Data
The column data can be formatted using the formatting tool. Selecting the column will trigger a menu to appear at the top of the column. Select the first icon, and then Formatting to display the formatting menu. You can also Hide a Column from this menu.
Filtering Column Data
Columns can be filtered to display only specific data. For example, you can filter the table view to display only Activities with the homelessness focus area. Selecting the column will trigger a menu to appear at the top of the column. Select the second icon (the funnel), to display the filter menu.
The first dropdown box within the filter menu allows you to specify how you wish to filter your data. Here, we have filtered the chart to display only rows within the focus area column that contain the word homelessness.
Sorting Column Data
Column data can be sorted in ascending or descending order. Selecting the column will trigger a menu to appear at the top of the column. Select the arrow icons to sort the data as desired.
Exporting Table Data
Once your table has been formatted, filtered, and sorted as needed, the table data can be exported into a .pdf, .xls, or .csv format by selecting the .PDF, .XLS, or .CSV buttons next to the date range selection.