Chart returning wrong data from Running Total 1

[jstepsfs]

Hi all! This is my first post here and I'm a definite CR n00b, so please be gentle.

I'm using CR9.

I have a database record that is a list of numbers: it's the number of times a call has been received on a help desk ticket. I'm trying to make a stacked bar chart which displays all of the instances where there is more than 1 call on a ticket. I've excluded everything with only one call and I've created a running total as follows:

Summary: Field to Summarize: Ticket.#ofCalls
Type of Summary: Count
Evaluate: For each record
Reset: On change of group: Ticket.Open Date & Time

All the data returns fine but when I try to put it into a stacked chart I get what seems to me to be an off error. Instead of each column showing the count of each individual data point, it adds them all together (ie it shows 29 '2' calls; then 32 '3' calls (there are actually 3 '3' calls); then 34 '4' calls (of which there are, obviously, 2), etc, etc. I have the chart set up as follows:

Stacked Bar Chart:
On change of: Ticket.Open Date & Time
Ticket.#ofCalls
Show Value: #RTotal0

What I would like it to show is 29 '2' calls, then 3 '3' calls, then 2 '4' calls, etc.

Any help is greatly appreciated!

 

[lbass]

I see no reason to use a running total. Instead, add a count of {ticket.#ofcalls} as your show value field. The "on change of" fields will create the group breaks.

-LB

 

[jstepsfs]

Thank you lbass!! That worked perfectly. I guess I was just over muscling it.