Charts in WISdom provide two controls for adjusting the time range and plot granularity directly on the chart without reopening the Date Picker: the Chart Time Widget and the plot granularity selector. These are independent controls and may not both be present on every chart.
Charts also support direct time range selection by clicking and dragging. This is available on histogram and activity charts across the following screens, among others:
- Performance › Workload Activity
- Performance › Query Analysis
- Blocking
- Deadlocks
Flyout panels do not include these controls.
Chart Time Widget
The Chart Time Widget is the navigation bar displayed above some charts. It controls the time range displayed on the chart.
Interval Selector
The interval selector in the center of the widget displays the approximate time range (7d is the default). This may be updated to a preset time range, anchored on the end date and time. Available options are:
1h, 6h, 12h, 1d, 3d, 7d, 14d, 30d
Use the back and forward arrows on either side of the interval selector to move the displayed range backward or forward by one interval block. Use the double arrows to move backward or forward by two blocks.
Return Arrow
The return arrow (the curved arrow to the right of the double-forward arrow) resets the chart to the default last 7 days, regardless of what range is currently displayed.
Plot Granularity Selector
The plot granularity selector is available on most charts and controls how much data is grouped under each bar or data point. The current granularity is displayed in parentheses next to Auto, for example, Auto (1h) or Auto (3h), depending on the screen and date range selected. It is independent of the Chart Time Widget and may appear on charts where the Chart Time Widget is not present.
Click the selector to choose a specific granularity or leave it on Auto. When set to Auto, WISdom selects the most appropriate granularity based on the active date range:
| Date Range | Auto Granularity |
|---|---|
| Under 3 hours | 1 minute |
| Under 24 hours | 15 minutes |
| 7 days or less | 1 hour |
| Several weeks | 12 hours |
On the Blocking and Deadlocks screens, the default 7-day range uses Auto (3h). Other screens in WISdom display Auto (1h) for the same 7-day range.
The granularity can also be set manually. Available options range from 1m up to 30d depending on the selected date range. Finer granularities are only available when the date range is short enough to make them meaningful.
Selecting a Range by Clicking and Dragging
To zoom into a specific period of interest without reopening the Date Picker:
- Identify the start point of the desired range on the chart
- Click and hold at that point
- Drag left or right to the desired endpoint
- Release to apply the selection
The Date Picker updates to match the boundaries of the selected region, and all data on the screen refreshes. Start and end times snap to the nearest plot points as determined by the current plot granularity.
To return to a prior range after a drag selection, use the return arrow on the Chart Time Widget if available, or reapply a range using the Date Picker.