Combining and Correlating Charts

by Community Manager on 07-06-2011 01:02 PM - last edited on 07-11-2011 10:47 AM

Charts with similar data can be combined or correlated using drag and drop. This includes the out-of-the-box charts provided in the Widget Type list's Charts or Monitors category, as well as from an external data source.

  • For Combined charts the target chart keeps both its x and (left) y-axis and the source chart creates a new right y-axis. You can drop more charts on the newly combined chart, as long as the source chart has a y-axis that matches, in unit-type, either the left or right y-axis of the combined chart.
  • For Correlated charts the user will get a chart that shows how the source chart’s data set statistically correlated to the target chart’s data set. This is done by matching each point from both charts based on their common time x-axis, and plotting each pair of values on a new axis system that has the source chart’s y-axis and the target chart’s x-axis.

Drop icon

Once a widget is successfully dropped onto a second widget, the following menu options appear. Choose Combine, Correlate, or Cancel (to abandon the resulting chart).

The default title for the combined widget will be the title of Widget 1 vs. the title of Widget 2. You can rename the widget in the Edit Widget panel. The default title for the correlated widget with is the title of Widget 1 over Widget 2.

    • Combine

Use this option to show the resulting data concurrently with a separate axis for each data set.

Combine or Correlate box

    • Correlate

Use this option to create a statistical correlation between two datasets using time to join the two datasets. For example, to see how the number of errors changes as the number of virtual users increases, drop an Error Count chart on top of a Virtual User chart. Or, to see how response time degrades as the number of virtual users increases, drop the Average Response Time chart onto the Virtual Users chart.

    • Cancel

Click Cancel to abandon the widget combination.

Combine or Correlate two charts on the dashboard

  1. From within a dashboard, locate two widgets with like data. For example, two per minute charts.
  2. If Dashboard Edit Mode is active, toggle it off.
  3. Place the mouse cursor over the title bar of the first widget until the Drag icon  appears.
  4. Drag the widget onto widget two until the Drop icon appears.

Drop icon

When a chart cannot be combined or correlated a drop target a Stop icon appears.

Stop icon

For example, in the Average Response Time vs. Bytes Sent and Received chart shown above, the Bytes Sent and Received chart was dropped onto the Max Response Time chart and assigned the specified colors as a line chart. Click the Legend to review the color assignment and to toggle either chart on/off.

Combining a Widget Type Selection with a Dashboard Widget

Widgets from the Widget Type list can be dropped onto like widgets already on the dashboard. Previously, only widgets already in a dashboard could be combined or correlated using drag and drop.

Combining a Widget Type Selection with a Dashboard Widget

  1. Select or position the first widget (the one to drop onto) so that it is visible in the dashboard.

 

    1. In the Widget Type list, locate and then drag the widget over the first widget until the Drop icon appears.

  1. Drop the widget from the list (e.g. Bytes Sent and Received) onto the dashboard widget (e.g. Virtual Users) and then select Combine.

The combined widget appears in the position of the dashboard widget.

Correlating a Widget Type Selection with a Dashboard Widget

  1. Select or position the widget to drop onto so that it is visible in the browser.

    1. Locate, click, and then drag the widget to combine over the first widget until the Drop icon appears.

  1. Drop the widget and then select Correlate.

The correlated widget appears in the position of the dashboard widget.

To correlate results with monitors

Once a widget displays a single resource set it can be easily combined with a Monitor widget. You can select one or more result items in the Composition Editor, Results tab to display data for the selection and then create a correlated chart using drag and drop.

 
  1. Toggle on the Widget Selection Panel.
  2. Add one or more monitoring widgets to the dashboard by selecting from the Widget Type list, Monitor widget category.
  3. Locate the Chart or other resource, such as Average Min Max Response Time, to drag.
  4. Position the widget to drop on. For example, IO Kbytes Read.
  5. Drag the Chart or other resource onto the monitor widget and then select Correlate from the options.

Correlate a Monitor with Monitors

It is possible to correlate monitor data to monitor data that is present on a dashboard, and where the data can be combined or correlated.
Refer to Creating Monitor Server Groups and/or Creating a New Monitor for full server and monitor configuration. CloudTest provides out-of-the-box Default Monitors for many resources.
Refer to Adding a Widget to a Dashboard and to Adding a Monitor Container to a Dashboard for full instructions about adding monitor widgets to a dashboard via the Data Source, Monitor type.

  1. From within a dashboard, locate two monitor widgets. For example, two input/output charts, IO Kbytes Read and IO Kbytes Sent.
  2. If Dashboard Edit Mode is active, toggle it off.
  3. Place the mouse cursor over the title bar of the first widget until the drag icon appears.
  4. Drag the widget onto widget two until the Drop icon appears. If the Stop icon appears, the two charts cannot be combined.
  5. Once the widget is successfully dropped onto the second widget, choose Correlate. The widget is created with the default title Widget 1 over Widget 2 and the results are correlated.
 

Combining and Correlating External Data Widgets

Widgets from external data can be combined and correlated using the same techniques used with other CloudTest widgets. When both widgets are already in a dashboard, drag a neighboring widget onto the drop target. Widgets from external data can be dropped from the Widget Type list on to a widget in the dashboard just as with any other type of widget. In either case, the Combine box appears.

Setting Data Types for External Data Widgets

Additional Data type settings are available for the CA Wily Introscope widgets that use data types.

  1. Select an external widget in the dashboard. Note the data type in the y-axis for the widget, or for each y-axis in a combined widget.

  1. Click Toggle Dashboard Edit Mode on the dashboard toolbar. The Edit Panel appears below with the Widget node selected.

Toggle Dashboard Edit Mode

  1. In the Contained Widgets list, select the widget name. In the case of a combined or correlated widget more than one name appears. Data Type can be set separately for each widget.

  1. In the Data Type drop-down, change the Default selection to the new selection.
 

Selecting a data type other than the default for a given widget will change the y-axis for that chart. In the screenshot below, the default Bytes (Binary) data type used in its y-axis (red) for Bytes Total has been changed to Percent.

CA Wily Introscope Data Types

The available data types for Introscope widgets are:

  • Percent
  • Count
  • Time
  • Bytes (Primary)
  • Bytes (Decimal)
  1. Click Apply after making any changes and OK to exit the Edit Panel.
 
   

Delete a Chart from a Combined or Correlated widget

  1. Toggle Dashboard Edit Mode on.
  2. Select the combined or correlated widget.
  3. In the Edit Panel, Click Contained Widgets in the list on the left.
  4. In the Widget Order list, select the chart name and click Delete.
  • Reorder the widgets in a combined widget by selecting the Widget(s) node in the Edit Widget panel and then using the up/down arrows on the right to apply to a selection.
  • Specify left or right axis per chart using the Axis drop-downs.