Smartstaff, administrator
4,478
edits
Changes
→Manipulating data in the Interactive Report View
Each column within the interactive view has a drop-down, which has a number of options for manipulating the columns or the data within the columns, as well as a text field to enter filter text.
[[Image:InteractiveReport3.png|800px500px]]
===Manipulating Columns===
* Hide Columns: user can choose to hide a column from the current view. Any hidden columns can be exposed again by clicking on the triple bar on the left of the screen and then clicking on the hidden column NOTE: Hidden columns appear with a 'x' beside them.
[[Image:InteractiveReport5.png|800px]]
* Pin Left / Right: users can choose to move columns to the far left or right using the Pin Left or Pin Right options. Once the column has been pinned then the previously selected pin option is then replaced with an ''Unpin'' option to allow the user to restore the column to its previous location.
[[Image:InteractiveReport6.png|800px]]
Each column within the interactive view has a text field where the filter text can be entered. Users can use the wildcard character '*' if they wish to run a search for multiple records with similar, but not identical data.
[[Image:InteractiveReport2.png|800px]]
Users can use the 'x' within the filter text field to clear the filter for individual columns.
The interactive view has a drop-down in each column, which includes a Sort Ascending and Sort Descending option.
[[Image:InteractiveReport4.png|800px]]
Users can use the 'Remove Sort' option within the drop-down to clear sorting within an individual column.
When the Grouping option is selected against a column then that column is automatically moved to the left hand side of the report. The groupings are displayed alongside a count of the number of records in each group.
[[Image:InteractiveReport7.png|800px]]
Users can expand and contract all of the groupings at once, using the '+' or '-' in the column header, or for individual groupings, using the '+' or '-' option adjacent to the individual groupings.
[[Image:InteractiveReport8.png|800px]]
The Grouping option can also be used in conjunction with aggregate functions