A.1 DUPLICATE cases Ratio of resolved cases with resolution DUPLICATE
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<transition field="resolution">
<to>DUPLICATE</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<transition field="status">
<to>RESOLVED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>


A.2 INVALID cases Ratio of resolved cases with resolution INVALID
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<transition field="resolution">
<to>INVALID</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<transition field="status">
<to>RESOLVED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

A.3 Defect reports without Version Open cases without specified erroneous version
<metric>

<baseFilter>
<value field="type">bug</value>
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<and>
<create/>
<stateFilter>
<or>
<value field="version">-</value>
<value field="version">unspecified</value>
</or>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<create/>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

A.4 Comments beforeleaving status NEW Average number of comments before transition to ASSIGNED
<metric>

<baseFilter>
<value field="status">NEW</value>
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<divide>
<sum caseValueCalculator="FirstCalculation" />
<countUnique caseValueCalculator="FirstCalculation" />
</divide>
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
</groupEvaluations>
<caseValueCalculators>
<countEventsUntil id="FirstCalculation">
<event>
<commentAdded />
</event>
<until>
<transition field="status">
<from>NEW</from>
</transition>
</until>
</countEventsUntil>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2003-05-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2004-06-30</aggregateAt>
<aggregateAt>2005-06-30</aggregateAt>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields />
</metric>

B.1 CRs with no reaction within 2 days Ratio of unanswered cases 2 days after creation
<metric>

<baseFilter>
<none/>
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="TimeUntilFirstComment">
<divide>
<multiply>
<constant>100.0</constant>
<sum caseValueCalculator="default" />
</multiply>
<count caseValueCalculator="default" />
</divide>
</calculation>
<!-- <details name="details" caseValueCalculator="default"/>-->
</groupEvaluations>
<caseValueCalculators>
<intervalLength id="default">
<from>
<create />
</from>
<to>
<or>
<commentAdded />
<transition field="status" />
<transition field="assignee" />
<transition field="priority" />
<transition field="component" />
<transition field="targetMilestone" />
<transition field="summary" />
<transition field="product" />
</or>
</to>
<threshold thresholdInDays="2" useThresholdWeight="true" />
</intervalLength>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2003-05-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2004-06-30</aggregateAt>
<aggregateAt>2005-06-30</aggregateAt>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields />
</metric>

B.2 Reopened Rate rejected CRs Percentage of reopened cases
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<and>
<transition field="resolution">
<from>INVALID</from>
<from>WONTFIX</from>
<from>DUPLICATE</from>
<from>WORKSFORME</from>
<from>MOVED</from>
<from>NOT_ECLIPSE</from>
</transition>
<stateFilter>
<value field="status">REOPENED</value>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<and>
<transition field="resolution">
<to>INVALID</to>
<to>WONTFIX</to>
<to>DUPLICATE</to>
<to>WORKSFORME</to>
<to>MOVED</to>
<to>NOT_ECLIPSE</to>
</transition>
<stateFilter>
<value field="status">RESOLVED</value>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields>
<field>product</field>
</fixedFields>
</metric>

B.3 Priority of severe bugs Average Priority of blocker and critical CRs
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<none />
</groupingParameters>
<groupEvaluations>
<calculation name="averagePriorityOfSevereCases">
<divide>
<sum caseValueCalculator="FirstCalculation" />
<count caseValueCalculator="FirstCalculation" />
</divide>
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<and>
<transition field="status">
<to>RESOLVED</to>
</transition>
<stateFilter>
<or>
<value field="severity">blocker</value>
<value field="severity">critical</value>
</or>
</stateFilter>
</and>
</event>
<weight>
<mapping field="priority">
<map from="P1" to="1" />
<map from="P2" to="2" />
<map from="P3" to="3" />
<map from="P4" to="4" />
<map from="P5" to="5" />
</mapping>
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2008-03-12</start>
<end>2009-03-12</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<month />
</timePeriodGranularity>
<fixedFields />
</metric>

C.1 Assigned without Milestone Ratio of assigned cases without valid target milestone
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="resolved cases without target milestone">
<sum caseValueCalculator="resolved cases without target milestone" />
</calculation>
<calculation name="all_resolved cases">
<sum caseValueCalculator="all_resolved cases" />
</calculation>
<calculation name="PercentageWithoutTargetMilestone">
<divide>
<multiply>
<constant>100.0</constant>
<sum caseValueCalculator="resolved cases without target milestone" />
</multiply>
<sum caseValueCalculator="all_resolved cases" />
</divide>
</calculation>
<details name="BugsList_resolved cases without target milestone" caseValueCalculator="resolved cases without target milestone" />
<details name="BugsList_all_resolved cases" caseValueCalculator="all_resolved cases" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="resolved cases without target milestone">
<event>
<and>
<transition field="status">
<to>ASSIGNED</to>
</transition>
<stateFilter>
<or>
<value field="targetMilestone">---</value>
<value field="targetMilestone">--</value>
<value field="targetMilestone">-</value>
<value field="targetMilestone" />
<value field="targetMilestone">Future</value>
<value field="targetMilestone">future</value>
</or>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="all_resolved cases">
<event>
<transition field="status">
<to>ASSIGNED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields />
</metric>

C.2 Fixed without Milestone Ratio of resolved/fixed cases without assigned target milestone
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="resolved cases without target milestone">
<sum caseValueCalculator="resolved cases without target milestone" />
</calculation>
<calculation name="all_resolved cases">
<sum caseValueCalculator="all_resolved cases" />
</calculation>
<calculation name="PercentageWithoutTargetMilestone">
<divide>
<multiply>
<constant>100.0</constant>
<sum caseValueCalculator="resolved cases without target milestone" />
</multiply>
<sum caseValueCalculator="all_resolved cases" />
</divide>
</calculation>
<details name="BugsList_resolved cases without target milestone" caseValueCalculator="resolved cases without target milestone" />
<details name="BugsList_all_resolved cases" caseValueCalculator="all_resolved cases" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="resolved cases without target milestone">
<event>
<and>
<transition field="resolution">
<to>FIXED</to>
</transition>
<stateFilter>
<or>
<value field="targetMilestone">---</value>
<value field="targetMilestone">--</value>
<value field="targetMilestone">-</value>
<value field="targetMilestone" />
<value field="targetMilestone">Future</value>
<value field="targetMilestone">future</value>
</or>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="all_resolved cases">
<event>
<transition field="resolution">
<to>FIXED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields />
</metric>

C.3 Frequency of Milestone changes Average changes of defined target milestone before closing
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="MilestoneChanges">

<divide>
<multiply>
<constant>100.0</constant>
<sum caseValueCalculator="FirstCalculation" />
</multiply>
<count caseValueCalculator="FixedCRs" />
</divide>
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<and>
<transition field="targetMilestone" />
<stateFilter>
<and>
<not>
<value field="targetMilestone">---</value>
</not>
<not>
<value field="targetMilestone">--</value>
</not>
<not>
<value field="targetMilestone">-</value>
</not>
<not>
<value field="targetMilestone" />
</not>
<not>
<value field="targetMilestone">Future</value>
</not>
<not>
<value field="targetMilestone">future</value>
</not>
</and>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="FixedCRs">
<event>
<transition field="resolution">
<to>FIXED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2007-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields />
</metric>

D.1 Time until fixed Median lifetime of open cases until resolution
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<median caseValueCalculator="FirstCalculation" />
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
</groupEvaluations>
<caseValueCalculators>
<intervalLength id="FirstCalculation">
<from>
<create />
</from>
<to>
<transition field="resolution">
<to>FIXED</to>
</transition>
</to>
<considerToEvent>firstTime</considerToEvent>
</intervalLength>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields>
<field>product</field>
</fixedFields>
</metric>

D.2 High priority lifetime ratio Ratio of P1 resolution time compared to total resolution time
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="Average P1 lifetime">
<divide>
<sum caseValueCalculator="Average P1 lifetime" />
<count caseValueCalculator="Average P1 lifetime" />
</divide>
</calculation>
<calculation name="Average total lifetime">
<divide>
<sum caseValueCalculator="Average total lifetime" />
<count caseValueCalculator="Average total lifetime" />
</divide>
</calculation>
<calculation name="P1 lifetime ratio">
<divide>
<divide>
<sum caseValueCalculator="Average P1 lifetime" />
<count caseValueCalculator="Average P1 lifetime" />
</divide>
<divide>
<sum caseValueCalculator="Average total lifetime" />
<count caseValueCalculator="Average total lifetime" />
</divide>
</divide>
</calculation>
<details name="BugsList_Average P1 lifetime" caseValueCalculator="Average P1 lifetime" />
</groupEvaluations>
<caseValueCalculators>
<intervalLength id="Average P1 lifetime">
<from>
<or>
<transition field="priority">
<to>P1</to>
</transition>
<and>
<create/>
<stateFilter>
<value field="priority">P1</value>
</stateFilter>
</and>
</or>
</from>
<to>
<transition field="resolution">
<to>FIXED</to>
<to>INVALID</to>
<to>WONTFIX</to>
<to>DUPLICATE</to>
<to>WORKSFORME</to>
<to>MOVED</to>
<to>NOT_ECLIPSE</to>
</transition>
</to>
</intervalLength>
<intervalLength id="Average total lifetime">
<from>
<create />
</from>
<to>
<transition field="resolution">
<to>FIXED</to>
<to>INVALID</to>
<to>WONTFIX</to>
<to>DUPLICATE</to>
<to>WORKSFORME</to>
<to>MOVED</to>
<to>NOT_ECLIPSE</to>
</transition>
</to>
</intervalLength>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

D.3 Reopened Rate of fixed CRs Percentage of fixed, reopened cases to all fixed cases
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<and>
<transition field="resolution">
<from>FIXED</from>
</transition>
<stateFilter>
<value field="status">REOPENED</value>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<and>
<transition field="resolution">
<to>FIXED</to>
</transition>
<stateFilter>
<value field="status">RESOLVED</value>
</stateFilter>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

D.4 High Priority Percentage of resolved cases Percentage of open P1/P2 cases
<metric>

<baseFilter>
<none/>
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<and>

<transition field="resolution">
<from></from>
</transition>

<stateFilter>
<value field="priority">P1</value>
</stateFilter>

</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<transition field="resolution">
<from></from>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

D.5 Average Assignee Changes Average changes of assignee during case lifecycle
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="AvgChanges">
<divide>
<sum caseValueCalculator="FirstCalculation" />
<countUnique caseValueCalculator="FirstCalculation" />
</divide>
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<transition field="assignee" />
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

D.6 Endgame Enhancements Ratio of enhancements resolved later than one month before release
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="Ratio">
<divide>
<countUnique caseValueCalculator="FirstCalculation" />
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<and>
<transition field="resolution">
<to>FIXED</to>
</transition>
<stateFilter>
<value field="type">enhancement</value>
</stateFilter>
<eventDateRegExp>\d{4}-06-\d{2}</eventDateRegExp>
</and>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<transition field="resolution">
<to>FIXED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2007-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>

<aggregateAt>2006-06-30</aggregateAt>

<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>

</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>



E.1 Closed vs Resolved Ratio Ratio of cases going to CLOSED compared to those going to RESOLVED
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
<details name="BugsList_SecondCalculation" caseValueCalculator="SecondCalculation" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<transition field="status">
<from>RESOLVED</from>
<from>VERIFIED</from>
<to>CLOSED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<transition field="status">
<to>RESOLVED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

E.2 Closed without Verified Percentage of cases that go to CLOSED without being VERIFIED
<metric>

<baseFilter>
<none />
</baseFilter>
<groupingParameters>
<fieldGrouping>product</fieldGrouping>
</groupingParameters>
<groupEvaluations>
<calculation name="FirstCalculation">
<countUnique caseValueCalculator="FirstCalculation" />
</calculation>
<calculation name="SecondCalculation">
<countUnique caseValueCalculator="SecondCalculation" />
</calculation>
<calculation name="CombinationCalculation">
<divide>
<multiply>
<constant>100.0</constant>
<countUnique caseValueCalculator="FirstCalculation" />
</multiply>
<countUnique caseValueCalculator="SecondCalculation" />
</divide>
</calculation>
<details name="BugsList_FirstCalculation" caseValueCalculator="FirstCalculation" />
<details name="BugsList_SecondCalculation" caseValueCalculator="SecondCalculation" />
</groupEvaluations>
<caseValueCalculators>
<countEvents id="FirstCalculation">
<event>
<transition field="status">
<from>UNCONFIRMED</from>
<from>NEW</from>
<from>ASSIGNED</from>
<from>REOPENED</from>
<from>RESOLVED</from>
<to>CLOSED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
<countEvents id="SecondCalculation">
<event>
<transition field="status">
<to>CLOSED</to>
</transition>
</event>
<weight>
<default />
</weight>
</countEvents>
</caseValueCalculators>
<evaluationTimePeriod>
<timePeriod>
<start>2005-07-01</start>
<end>2008-06-30</end>
</timePeriod>
</evaluationTimePeriod>
<timePeriodGranularity>
<customGranularity>
<aggregateAt>2006-06-30</aggregateAt>
<aggregateAt>2007-06-30</aggregateAt>
<aggregateAt>2008-06-30</aggregateAt>
</customGranularity>
</timePeriodGranularity>
<fixedFields/>
</metric>

generated 2009-11-02 14:11:55 by HeidiSQL 3.2 Revision: 1129