Data Grid
The data grid displays the data for the report in a table.
The data grid for the selected report is initially displayed in
the lower right pane, although it can be resized using the resize
cursors
, hidden using the hide button
, or expanded to fill the entire pane using the expand button
.
You can control the information in the data grid through the various controls and options on the grid.
- Check boxes enable you to select the rows to display in the report chart. When selected, a check box displays the color of the corresponding bar, pie slice, or bubble in the chart. You can also use the drop-down menu in the first column header to display the top 5, 10, or 20 rows, instead of clicking each check box.
- Search Filter restricts the rows shown to those containing a specified string. All display columns are searched for the entered text.
- When selected, Compare displays two extra columns for each metric. One shows the value for the second period, the other shows the percentage change between the two.
- Click the arrow in the header for each column and metric in the data grid (including the compare metrics and percentage change columns) to sort using the selected column. You can sort in ascending or descending order.
- Use the drop-down menu in the first column header to display either all results or just the top 5, 10, or 20 results from the first column menu.
Different reports have differing display capabilities.
- Flat List Reports
- For Flat List reports a row displays for each display column combination
selected when the report was created plus a totals row at the top
of the grid. Columns are displayed for each selected metric.
If you have created Relational Zooms for a Flat List Report, each row with relational data will have a magnifying glass
button
by each display column combination. Click this to open the corresponding
relational zoom. - Hierarchy Reports
- For Hierarchy reports, a row displays for each value for the first
display column. You can expand any row to see the associated values
for the second display column. If there are more than two display
columns, you can expand any secondary row to see the associated values
for the additional display columns. You can expand or collapse the
rows by clicking
or
,
respectively. - Filtered Groups Reports
- For Filtered Groups reports, a row is displays for each group
with columns for a selected metric. You can expand or collapse the
rows by clicking
or
,
respectively. - Segment Compare Reports
- For Segment Compare reports, a row is displays for each reporting period containing columns for each segment selected when the report was created.
- Lifecycle Reports
- For Lifecycle reports, a data grid appears when you zoom on a milestone or a migrators segment.
- Live reports
- For Live reports, a row displays for each display column combination
selected when the report was created. Columns are displayed for each
selected metric.
Live reports default to the current day. You can select only single days within the last eight days for viewing real-time data.