Dashboard Examples

This example shows how to create a chart that shows the active incidents for a team by owner and drills down to the active incidents by priority.

1.

Within the chart wizard under the Standard tab, enter the following information:

Field	Description
Chart Title	My Team's Active incidents by Priority.
Type	Select Vertical Bar.
Object	Select incident.
Header Footer	Optional. Enter information. and select the Show Legend option.
Aggregate by	Select Count.
Group By	Select Owner.
Order By	Select Aggregation Field, then select Ascending.
Results	Select All.

2.

Under the Drill Downs tab and enter the following information:

Field	Description
Type	Select Vertical Bar or Pie Chart.
Header	Enter By Priority.
Aggregate by	Select Count.
Group By	Select Priority.
Order By	Select Aggregation Field, then select Ascending.
Results	Select All.

3.

Click Add to add another drill down.

Field	Description
Type	Select Table.

4.

Under the Advanced tab, select a saved search. For example, select My Team's Active incidents.

The saved search must have previously been created.

5.

Click Refresh to preview the results.

6.

Click Save.

Tree - Software Manufacturer

Using the tree designer, create a tree that shows all the software manufacturers and drills down to software by manufacturer, software versions, and the machines on which the software is installed.

1.

Within the tree designer, enter the following data into the fields:

Field	Description
Tree Title	Enter Software Manufacturer.
Show Node Name	Keep selected.

2.

Right click Root, then from the drop-down list, select Add Node. The fields become active.

3.

Design the first node:

Field	Description
Node Name	Enter Manufacturers.
Object	Select Manufacturer.
Field	Select Manufacturer.
Object Icon	Select an icon from the drop-down list.

4.

Click Update.

5.

Right-click the manufacturer node that you just created and select Add Node. Enter the following data:

Field	Description
Node Name	Enter Software.
Relationship	Select SoftwareIdentityAssocManufacturer.
Object	Automatically filled in with the value SoftwareIdentity.
Field	Select SoftwareName.
Object Icon	Select an icon from the drop-down list.

6.

Click Update.

7.

Right-click the software node you just created and select Add Node. Enter the following data.

Field	Description
Node Name	Enter Versions.
Relationship	Select FRS_CIComponentInstalledApplicationAssocSoftwareIdentity.
Object	Automatically filled in with the value Installed Software.
Field	Select VersionNumber.
Object Icon	Select an icon from the drop-down list.

8.

Click Update.

9.

Right-click the versions node you just created and select Add Node. Enter the following data:

Field	Description
Node Name	Enter Installed On.
Relationship	Select CIAssociatedFRS_CIComponent.
Object	Automatically filled in with the value CI.
Field	Select Name.
Object Icon	Select an icon from the drop-down list.

10.

Click Update.

11.

From the Tree Actions drop-down list, select Preview Tree to view the tree results in the right preview pane.

12.

Click Save.

Tree - Software by Vendor

This example takes the previous tree (Tree - Software Manufacturer) and applies a filter to show software from a specific vendor.

Use the tree created in the previous example (Tree - Software by Vendor).

1.

Within the tree designer, right-click Manufacturers and select Edit Node. The node fields become active.

2.

In the Filter Criteria section:

In the first field, select Manufacturer.
In the second field, select CreatedBy.
In the operator field, select Contains.
In the last field, enter Microsoft.

3.

Click Update.

4.

Click the Tree Actions drop-down list and select Preview Tree.

The tree now shows only software from Microsoft, the software versions, and the machines on which they are installed.

Simple Pivot Table - Total Count by Status of Priority 1 through 5 Incidents by Categories and Services

1.

Within the pivot table wizard, enter the following data into the fields:

Field	Definition
Title	Enter Total Count by Status.
Object	Select incident.
Template	Select 2 Row 1 Column (the third button from the right).
Aggregate by	Select Count.
Measure	Select Priority.
Left Axis 1	Select Category.
Left Axis 2	Select Service.
Top Axis 1	Select Status.

2.

Click Refresh to view the table.

3.

Click Save.

Simple Pivot Table - Total Count by Owner of Priority 1 through 5 Incidents by Categories and Locations

1.

Within the pivot table wizard, enter the following data into the fields:

Field	Description
Title	Enter Total Count by Owner.
Object	Select incident.
Template	Select 2 Row 1 Column (the third button from the right).
Aggregate by	Select Count.
Measure	Select Priority.
Left Axis 1	Select Service.
Left Axis 2	Select Location.
Top Axis 1	Select Owner.

2.

Click Refresh to view the table.

3.

Click Save.

Hybrid Table - Using 3 Data Points and Aggregates

Within the pivot table wizard, enter the following data into the fields:

Field	Description
Title	Enter incident Total Times.
Object	Select incident.
Template	Select the hybrid template (the button on the right).
Aggregate by	Select Average.
Measure	Select Total Time Spent.
Left Axis 1	Select Service.
Left Axis 2	Select Category.
Top Axis 1	Select Impact.
Field Title	Enter Incident time by Impact.

1.

Click the blue Plus button. A new data set section appears.

2.

Enter the following data into this new section:

Field	Description
Aggregate by	Select Sum.
Measure	Select Total Time Spent.
Top Axis	Select Priority.
Field Title	Enter Incident time by Priority.

3.

Click the blue Plus button to add another data set.

4.

Enter the following data into this new section:

Field	Description
Aggregate by	Select Maximum.
Measure	Select Total Time Spent.
Top Axis	Select Owner.
Field Title	Enter Incident time by Owner.

5.

Click Refresh to view the table.

6.

Click Save.