Smartstaff, administrator
4,478
edits
Changes
→Manipulating data in the Interactive Report View
==Manipulating data in the Interactive Report View==
* In the Interactive View you can enter text queries to filter through report data, group data, sort data (ascending and descending), and calculate aggregate totals (count, sum, max, min, average). [[Image:InteractiveReport1.png|800px]] 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|800px]] ===Manipulating Columns=== The interactive view has a drop-down in each column, which allows users to do the following . . . * 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]]
===Filter data===
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.
Users can use the 'Clear All Filters' button along the top of the Interactive report to clear the filter for all columns.
===Sort data===
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.
===Group data===
The interactive view has a drop-down, which includes a Grouping option.
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
# Agg: Count -
# Agg: Sum
# Agg: Max
# Agg: Min
# Agg: Avg
Users can use the 'Ungroup' option within the drop-down to clear grouping based on an individual column, or can sue the Clear Grouping button along the top to clear grouping against all columns.
{| class="wikitable"