Running Count

[slickBT]

I need to create a running count for each status type in a group like the following. The Count Column is what I need. I have tried to do this but have failed thus far. Can someone help me out with this?

Defect Status Days Count
8968 Asmbly Test Failed 0.15 1
8968 Asmbly Test Failed 0.20 2
8968 Asmbly Test Failed 0.74 3
8968 Asmbly Test Failed 1.12 4
8968 Asmbly Test Passed 0.60 1
8968 Code Review Approved 7.06 1
8968 Code Review Complete 1.80 1
8968 Code Review Req 0.00 1
8968 Migration Requested 0.13 1
8968 Ready for Retest 0.67 1
8968 Ready for Retest 7.05 2
8968 Ready for Retest 0.93 3
8968 Ready for Retest 4.96 4
8968 Ready for Retest 0.35 5

 

[bdreed35]

Create a Running Total that:
Counts Your Status field, Evaluates for each record, and Resets on change of your Status field.

~Brian

 

[lbass]

Choose {table.status}, count, evaluate for every record, reset on change of field {table.status}.

-LB

 

[ThaGooch]

How would you do this for a group? I want to place them in a count order from 1-100.

 

[lbass]

ThaGooch--

What do you mean by "place them in a count order"?

If you want a running total of your groups, you might be able to use the field explorer->special field->groupnumber. Try placing that in the group. This will count all group instances, but if you have multiple groups, this may not be what you are looking for, so a little more explanation would help.

-LB