Exploring data

Exploring data

You can find out additional information about the data inside a report. Once you are viewing a report, you can hover over a data point to bring up a tooltip that provides additional information.

After clicking on a report, click a data point to highlight it and bring up additional options.

• Keep Only - display only the selected data point.
• Exclude - remove the highlighted data from view.
• View Data - open a new window to display the actual data used. After exploring or interacting with the data, you can click Reset to return to the report's original view. View Data Click View Data to see the underlying data used in your selected data points in more detail.
• Click the Summary tab to see the aggregated data used in your selection.
• Click the Full data tab to see the values in each row of the selected data.
• Select Show all columns to display all the underlying data used in the selected data points.
• Click Download all rows as a text file to save the displayed data in CSV format.

Selecting multiple data points

Click and drag your cursor to select several data points at once. You can also press and hold Ctrl while selecting items to create a custom group. This is particularly useful when you need to select nonadjacent data points. Hover your cursor over the highlighted data points and you’ll see an expanded tooltip. Move your cursor over a highlighted data point to display additional details via a tooltip.

• Keep Only - Limits the view to show only the selected data points.
• Exclude - Removes the highlighted data from view.
• View Data - Opens a new window that displays the actual data used.
• Sort - Rearranges the selected data in ascending or descending order.
• View Data - Opens a window showing the highlighted data in more detail.

To return to a report's full view, click Reset on top of the report window. Click Refresh to reload the report using the latest data available.

Quickly filtering and sort data

You can quickly filter and sort the data in a visualization using different control options.

Filter options

Reports can feature different types of filters which let you narrow down the visualizations to show only the data that you want to see.

The common types of filter controls featured in IBM® Maximo Inventory Optimization reports include:

• Sliders
• Drop-down menus and checklists
• Radio buttons

Quick sorting

You can quickly change the sort order of the items in view using the Sort buttons that appear when you hover over an axis, field label or header.

Date drill down

Reports that feature dates can have a Drill Down or Drill Up option when you hover your cursor near the left-most corners of a chart.

Using legends to highlight data

Click any legend description to quickly select and interact with all the corresponding data points that belong to the same category.

On the tooltip that appears, you can select Keep Only to isolate the data from the rest of the group, or Exclude to remove the selected data from view.

You can also press and hold Ctrl while selecting legend icons to highlight several data sets at a time.

Two-way highlighting

Click the icon to switch to two-way highlighting. The icon switches to whenever two-way mode is active.

Two-way mode lets you highlight subsets of data using either the legends or the marks themselves.

You can also press and hold Ctrl while clicking either the data subsets or legend icons to select multiple items at a time.

When you highlight a mark, the matching legend will also be highlighted, and vice versa.

Click Reset to undo all changes made to a report and return to its default view.