...
It is often useful to filter the data that appear on many graphs. You can hover over data elements in the legend of our graphs and the graph will highlight that element. You can also click to turn those elements on or off. In the below example, it maybe be useful to turn the two average lines off so we can focus on the data for our Tier 1 storage.
...
Turning Off Data Labels
Some of our graphs allow you to turn off the data labels, which are the numbers that appear with each data point. This can be useful when you run daily data collection and have many points on a graph. The numbers tend to run together making them difficult to read.
...
In these cases, you can turn off the data labels by simply clicking the data labels toggle. The data labels will disappear but you can still hover over the line to see individual values.
Working with Time Series Graphs
Time series graphs allow the same basic filtering as most other graphs, but they also allow you to interactively change the time periods under review. You ca accomplish this two three different ways.
First, you can use the slider at the bottom of the screen. Using your mouse, grab the handles at either end of the blue time graph at the bottom and drag them to include the time periods that interest you. You can scrub the time area while dragging back and forth along the grid.
...
Secondly, you can precisely set the dates for the start and end of the series that interests you by using the time settings. Click the start and end dates and set them to the dates you’d like to see.
...
The third way is to use the quick zoom buttons on the upper left corner of the graph. You can select 1 day, 1 week, 1 month, or zoom all the way out to show all data points.
...
In either any case, the graph zooms to allow you to see more granular data.
...
Let’s look at the major features on the Customizable Data Grid.
Drilling Down for More Detail
Some data grids, particularly those displayed in enterprise reports, all you to double click a row on the report to view more detailed reports. You can tell which grids support this by finding the notification next to the search field. If the grid displays this message (below), it supports drilling down. If there isn’t a level of detail below your current report, this badge will be absent.
...
Searching the Data Grid
You can search the data within the grid using the search field. Type in your search term, and if it is found within any cell in the grid, you’ll see the grid limited to the results. To clear the search result and view all data again, just clear out the search field by clicking the X button next to the field.
...
Sorting Data
Most columns are sortable. To accomplish this, simply over your mouse over the column. When you do this, a hamburger menu shows up which will allow you to access more features available on that column. Sorting, though, doesn’t use the hamburger menu. Instead, click anywhere in the column header, except for the hamburger menu. Clicking a column once sorts the data in the grid in ascending order. An upward facing arrow will appear in the column header to indicate this is happening. Click again and the data are sorted in descending order, and the arrow will change to a downward facing arrow. Click one more time and the data goes back to being unsorted.
Filtering Data in a Column
The Customizable Data Grid in VSI allows for sophisticated filtering on column data. The controls that are available are different depending on what kind of data are in the column. In any case, you can access the filtering options by hovering your mouse pointer over any column header. When you do this, a hamburger icon (three horizontal lines) appears in the left side of the column header. Clicking the hamburger opens the menu.
...
To clear a filter, perform the same steps in reverse.
Grouping Data
Many reports allow you to group your data by one or more categories taking from column on the data grid. Grouped data are generally subtotaled by the grouping you select.
To group data in a report, first make sure the report supports grouping. You can tell grouping is supported when you see the grouping bar at the top of the data grid.
...
To group data, select a relevant column and drag it by the column header, then drop it in the grouping bar.
...
Once the grouping is in place, you’ll find numerical columns have been summarized:
...
You can close up the groups to see all the groups together with their summary lines, or you can expand a group to see what’s inside it. You can do this group by group by using the + / - markers next to the group.
...
If you’d like to open and close all the groups at once, use the Expand All and Collapse All buttons above the grid.
...
To clear the grouping, just click the x in the grouped field in the group bar to remove it. Once you’ve remoted all the groupings, your data will appear as it was originally displayed.
...
Units of Measure
By default, all size numbers on all reports are expressed as the SI unit gigabytes, expressed as GiB. You can change this during the onboarding process. You can tell what unit you’re using by checking the display above the data grid.
...
Rearranging Columns
You can rearrange the columns if you’d like. Simply drag the column header, and drop it wherever you’d like it on the grid.
...
Showing and Hiding Columns
What you see on most grids isn’t always all that is available. Many grids have hidden fields. Similarly, not all our users care about every field on our standard reports. You have the ability to customize most of the reporting grids in VSI. To do this, click the wrench button above the data grid. This will show the Grid’s configuration drawer. Once it’s open, you check and uncheck any column you’d like to show or hide respectively.
...
Once you have the fields you want, click the wrench again to close the drawer.
Saving and Resetting the Column Configuration
Deleting the Column ConfigurationLet’s say you spent the last 30 minutes obsessing over the perfect grid layout. Who can blame you? We certainly won’t judge. The problem is, if you navigate away from the report and navigate back, all your hard work is for naught. The report defaults back to it’s original configuration.
Fear not, intrepid data slicer! You can save your layout by pinning your columns with the pin button.
...
If you’d like to reset back to the original layout, click the eraser button right next to the pin.
Pro Tip: Customizations are saved at the user level, so the customizations you make, are only visible to you.