2 Replies Latest reply on Jul 9, 2016 6:15 AM by talkersw

    Bar Chart Help

    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?