Data Details

To add data to a view, from the left menu, click Visualize > Views. From the Views panel, click Create. In the New View dialog box, on the left, click Data. If you create a view, complete the required previous steps.

How to Add Data to a View

If you selected more than one subject, specify the subject for which you add data. Double-click the data from the tree in the left panel to add it to the view. For each subject the data available to add might be different. For List views ,when you enable Business Hours in the Advanced > Time Settings mode, you can apply Business Hours for the selected data type, if the transformation that you choose is supported by the Business Hour.

How to Configure the Data Transformation

The data configuration options depend on the view and data type that you select. Most of the options are available for all views.

Table 1. Data Configuration Options
Configuration Option	Description
Metric name	Default metric name. Available for all views.
Metric label	Customizable label as it appears in the view or report. Available for all views.
Units	Depends on the added metric or property. You can select in what unit to display the values. For example, for CPU\|Demand(MHz) from the Units drop-down menu, you can change the value to Hz, KHz, or GHz. If you select Auto, the scaling is set to a meaningful unit. Available for all views.
Sort order	Orders the values in ascending or descending order. Available for List view and Summary view.
Transformation	Determines what calculation method is applied on the raw data. You can select the type of transformation: Minimum. The minimum value of the metric over the selected time range. Maximum. The maximum value of the metric over the selected time range. Average. The mean of all the metric values over the selected time range. Sum. The sum of the metric values over the selected time range. First. The first metric value for the selected time range. Last. The last value of a metric within the selected time range. If you have selected Last as the transformation in versions before vRealize Operations6.7, and the end of specified time range is not before the last five minutes, use the Current transformation. Current. The last available value of a metric if it was last updated not before five collection cycles were complete, otherwise it is null. Standard Deviation. The standard deviation of the metric values. Metric Correlation. Displays the value when another metric is at the minimum or maximum. For example, displays the value for memory.usage when cpu.usage is at a maximum. Forecast. Performs a regressive analysis and predicts future values. Displays the last metric value of the selected range. Percentile. Calculates the specified percentile for the data range. For example, you can view the 95th percentile, 99th percentile, and so on. Expression. Allows you to construct a mathematical expression over existing transformations using minus, plus, multiplication, division, unary minus, unary plus, and round brackets. For example, `sum/((max + min)/2)`. You can use the operands of some of the existing transformations such as, max, min, avg, sum, first, last, current. You cannot use standard deviation, forecast, metric correlation, and percentile. You can customize the metric unit label when you select the Expression transformation. For example, some of the metric units available are, vCPUs, Bps, KBps, Mbps, and MBps. Available for all views, except Trend. Timestamp: You can choose between Absolute Timestamp or Relative Timestamp. If applied to a numeric metric/property defined with a time-unit definition, the actual value is converted to a human readable timestamp. The metric value is rounded-off to an hour. Applicable for Absolute Timestamp. In the remaining cases, a timestamp is displayed when metrics and properties are added or modified. In this case, the behavior is the same as the Timestamp option selected for a non-Timestamp transformation. Applicable for Absolute Timestamp and Relative Timestamp. Available for List view and Minimum, Maximum, Current, First, and Last transformations.
Ranges for metric coloring	You can associate colors to metrics by entering a percentage, range, or specific state. For example, you can enter Powered Off in the Red Bound field when you select virtual machine as an object. You can set the colors only for views and not for csv or pdf formats.
Data Series	You can select whether to include historical data, trend of historical data, and forecast for future time in the trend view calculations. Available for Trend view.
Series Roll up	The time interval at which the data is rolled up. You can select one of the available options. For example, if you select Sum as a Transformation and 5 minutes as the roll-up interval, then the system selects 5-minute interval values and adds them. This option is applicable to the Transformation configuration option. Available for all views.
Threshold Lines	You can set a threshold for a single metric: None. You have not set a threshold. By Symptom Definition. You can set a threshold value based on a symptom definition. Custom. You can set the threshold value as Warning, Critical, or Immediate. These options are available only for the Custom option. Available for Trend view.

How to Configure Time Settings

Use the time settings to select the time interval of data transformation. These options are available for all view types, except Image.

You can set a time range for a past period or set a future date for the end of the time period. When you select a future end date and no data is available, the view is populated by forecast data.

Table 2. Time Settings Options
Configuration Option	Description
Time Range Mode	In Basic mode, you can select date ranges. In Advanced mode, you can select any combination of relative or specific start and end dates. You can also enable the Business Hour option and select business hours/days for weekdays.
Relative Date Range	Select a relative date range of data transformation. Available in Basic mode.
Specific Date Range	Select a specific date range of data transformation. Available in Basic mode.
Absolute Date Range	Select a date or time range to view data for a time unit such as a complete month or a week. For example, you can run a report on the third of every month for the previous month. Data from the first to the end of the previous month is displayed as against data from the third of the previous month to the third of the current month. The units of time available are: Hours, Days, Weeks, Months, and Years. The locale settings of the system determine the start and end of the unit. For example, weeks in most of the European countries begin on Monday while in the United States they begin on Sunday. Available in Basic mode.
Relative Start Date	Select a relative start date of data transformation. Available in Advanced mode.
Relative End Date	Select a relative end date of data transformation. Available in Advanced mode.
Specific Start Date	Select a specific start date of data transformation. Available in Advanced mode.
Specific End Date	Select a specific end date of data transformation. Available in Advanced mode.
Currently selected date range	Displays the date or time range you selected. For example, if you select a specific date range from 5/01/2016 to 5/18/2016, the following information is displayed: `May 1, 2016 12:00:00 AM to May 18, 2016 11:55:00 PM`.
Select Business Hours	Select business hours from Monday to Sunday by moving the sliders on the left and right sides to set the start and end time for each day of the week. For example, as a VM owner, you can track the average utilization of VMs over a week (business days), during specified hours of the day (business hours). This option is available for Minimum, Maximum, Average, Sum, and Percentile transformations Available in Advanced mode for List Views.

How to Break Down Data

You can break down data in List views by adding interval or instance breakdown columns from the Breakdown By tab.

Table 3. Breakdown By Options
Option	Description
Add interval breakdown column (see data for column settings)	Select this option to see the data for the selected resources broken down in time intervals. In the Data tab, select Interval Breakdown to configure the column. You can enter a label and select a breakdown interval for the time range.
Add instance breakdown column (see data for column settings)	Select this option to see the data for all instances of the selected resources. In the Data tab, select Instance Name to configure the column. You can enter a label and select a metric group to break down all the instances in that group. Deselect Show non-instance aggregate metric to display only the separate instances. Deselect Show only instance name to display the metric group name and instance name in the instance breakdown column. For example, you can create a view to display CPU usage by selecting the metric CPU:0\|Usage. If you add an instance breakdown column, the column CPU:0\|Usage displays the usage of all CPU instances on separate rows (0, 1, and so on). To avoid ambiguity, you can change the metric label of CPU:0\|Usage to `Usage`.

How to Add a Filter

The filter option allows you to add additional criteria when the view displays too much information. For example a List view shows information about the health of virtual machines. From the Filter tab, you add a risk metric less than 50%. The view displays the health of all virtual machines with risk less than 50%. For selected criteria you can also apply Business Hours, if the selected transformation type you add as a filter is supported by the business hours functionality.

To add filter to a view, from an existing or new view dialog box, click Data from the left pane and then click the Filter tab in the right pane. Fill in the details for each row and click Add. You can enable Business Hours for the metric selected.

Each subject has a separate filter box. For Alerts Roll up, Alert, and Symptom subjects not all applicable metrics are supported for filtering.

Table 4. Filter Add Options
Option	Description
Add	Adds another criteria to the criteria set. The filter returns results that match all the specified criteria. If you add a filter for an instance metric, all the instances of the object for which the criteria is met, will be displayed in the preview screen. For instance metrics, you can filter based on transformations such as, Current, Average, First, Last, Maximum, Minimum, and Sum.
Add another criteria	Adds another criteria set. The filter returns results that match one criteria set or another.

How to Add a Summary Row or Column to a View

The summary option is available only for List and Summary views. It is mandatory for the Summary views. You can add more than one summary row or column and configure each to show different aggregations. In the summary configuration panel, you select the aggregation method and what data to include or exclude from the calculations.

To add a summary row or column to a view, from an existing or new view dialog box, click Data from the left pane and then click the Summary tab in the right pane. Click the plus sign to add a summary row.

For the Summary view, the summary column shows aggregated information by the items provided on the Data tab.