talkersw

Bar Chart Help

Discussion created by talkersw on Jul 8, 2016
Latest reply on Jul 9, 2016 by talkersw

Here is my scenario, although a bit differently explained...I have a set of tasks and each has a specified time spent on it each day.

 

For example, here is a set of records:

 

Item 1: 20 Minutes

Item 1: 10 Minutes

Item 2: 30 Minutes

Item 3: 30 Minutes

Item 2: 15 Minutes

Item 1: 10 Minutes

 

So I created a relationship table occurrence and linked them up, sorted by a total field, etc. In the graph it shows everything great under individual record data. I see each of the records as specified above.

 

CLM.png

 

I assumed Summarized Group of Records would simply show the same thing but with the total for each.Unfortunately, what I am seeing is the time for the last record entered, not the summed times for each item:

 

Item 3: 30 Minutes

Item 2: 15 Minutes

Item 1: 10 Minutes

 

When I click "summarized groups of records" under the data source tab,  I want is each to be summed in the bar graph. For Example:

 

Item 2: 45 Minutes (summing the time for Item 2's records)

Item 1: 40 Minutes (summing the time for Item 1's records)

Item 3: 30 Minutes (summing the time for Item 3's records)

 

Any ideas on how I should fix this?

Outcomes