User Help > Displaying Item Data Graphically > Creating a Chart > Detailed Chart Examples
  
Detailed Chart Examples
This section provides details on defining the key components of sample charts of each type.
Trend Chart
To create a trend chart that shows the number of defects created over the current year and their resolution (by state), summarized on a daily basis, do the following:
1. On the Charting Values panel, define the following values:
Field
Value
Start Date
Date, Jan 1, 2010
End Date
Run Chart Date
Interval Type
Day
State
State
Values
In Review [alias Submitted]
Assigned [alias Submitted]
In Development [alias In Development]
Inactive
Completed [alias Completed]
In Testing [alias In Testing]
Accepted [alias Submitted]
Proposed [alias Submitted]
Ready for Automated Testing
Started
Unavailable
Include Future Values
enabled
2. On the Graph tab, click the line graph icon for Graph Style.
For example, the following chart is generated:
Item Fields Trend Chart
To create an item fields trend chart that reports on the progression of test authoring activity over a period of weeks, do the following:
1. On the Query tab, select a query that shows the project items that you want to chart.
2. On the Charting Values tab, under Time Values, define the following values:
Field
Value
Start Date
Select Item Date Field and then Created Date in the field to the right.
End Date
Select Calculated Date.
Interval Type
Select Week. In the field to the right, you specify the interval value. Type52.
3. Under Item Field Values, define the following expressions:
Numeric Field
Expression Label
Test Case Content Count - Open
Draft
Test Case Content Count - In Review
In Review
Test Case Content Count - Published
Published
For all expressions, Axis Label is Test Cases and Display Pattern is #,###.
4. Under Display Attributes, for Display chart values as, select Values.
5. On the Graph tab, select the vertical bar graph icon for Graph Style.
6. On the Graph tab, select the Colors tab in the lower panel. Then, define custom colors for the Draft, In Review, and Published data.
7. Click OK.
For example, the following chart is generated:
Distribution Chart
To create a distribution chart that shows the health and status of active projects per product, do the following:
1. On the Query tab, select a query that shows active project items.
2. On the Charting Values tab, under Values To Chart, select Product as the Field, and then choose active products from the Values list.
3. Enable Include Future Values and Show Zero Count Values.
4. On the Charting Values > Aggregation tab, define the following expressions:
Aggregate Expression
Expression Label
Axis Label
Display Pattern
count()
# of Projects
Count
#,###
max("Product Health Value")
Health
Count
none
sum("Total Estimated Effort")
Total Estimated Effort
Days
#,##0 days
sum("Total Actual Effort")
Total Actual Effort
Days
#,##0 days
sum("Total Estimated Effort")-sum("Total Actual Effort")
Effort Variance
Days
#,##0 days
5. On the Graph tab, choose the table rendering icon for Graph Style.
6. On the Graph > Table tab, define the following Range Definitions for the Health computed expression:
Label
From
To
Icon
Text Style
Display Format
Green
-1.0
-1.0
green circle image
Plain
Icon
Yellow
0.0
0.0
yellow circle image
Plain
Icon
Red
1.0
1.0
red circle image
Plain
Icon
Define the following Range Definitions for the Effort Variance computed expression:
Label
From
To
Icon
Text Style
Display Format
Red
-Infinity
0.0
red circle image
Plain
Icon & Value
Yellow
1.0
10.0
yellow circle image
Plain
Icon & Value
Green
11.0
Infinity
green circle image
Plain
Icon & Value
7. Click OK.
For example, the following chart is generated:
Item Fields Charts
To create an item fields chart that shows effort, budget, and schedule metrics for all active projects, do the following:
1. On the Queries tab, select a query that shows active Project items.
2. On the Charting Values tab, define the following expressions:
Field Name/Expression
Expression Label
Display Pattern
“Health Value”
Health
“Estimated Budget”
Est. Budget
$#,###
“Actual Budget”
Act. Budget
$#,###
“Budget Variance”
Budget Variance
$#,###
“Estimated Effort”
Est. Effort
#,###.#hrs
“Actual Effort”
Act. Effort
#,###.#hrs
“Effort Variance”
Effort Variance
#,###.#hrs
3. In the Item Identifier field, specify {Project} ({Product}).
4. On the Graph > Table panel, define the following Range Definitions for the Health computed expression:
Label
From
To
Icon
Text Style
Display Format
Green
-1.0
-1.0
green circle image
Plain
Icon
Yellow
0.0
0.0
yellow circle image
Plain
Icon
Red
1.0
1.0
red circle image
Plain
Icon
Define the following Range Definitions for the Budget Variance computed expression:
Label
From
To
Icon
Text Style
Display Format
Red
-9.99999999E8
-100001.0
red circle image
Plain
Icon & Value
Yellow
-10000.0
10.0
yellow circle image
Plain
Icon & Value
Green
10000.0
9.99999999E8
green circle image
Plain
Icon & Value
Define the following Range Definitions for the Effort Variance computed expression:
Label
From
To
Icon
Text Style
Display Format
Red
0.15000000000001
9999.0
red circle image
Plain
Icon & Value
Yellow
1.0E-13
0.15
yellow circle image
Plain
Icon & Value
Green
-9999.0
0.0
green circle image
Plain
Icon & Value
5. Click OK.
For example, the following chart is generated: