I’m working with the Apex Charts plugin, and I have submitted this question over at ZeroQode but I suspect this may be a situation where I can be using bubble differently to get the result…

The principle problem I need to solve is: How do I aggregate the list of date intervals by user.

The “Group” Function doesn’t seem to work in this case (as demonstrated below)

Hello, I need some help with creating charts.

The charts I need to create are all displaying time data from a Date Interval field type in my data base.

The data is a list of a Time Entries.

So for example, if I want to create a pie chart that shows the cumulative hours of 5 employees…

Then the employee names would be the “Label” and the data is the sum of time entries for each employee.

If I just use the list of time entries, then the problem is that an employee “Mike” appears in the pie chart each time he appears in the list.

I can group my data by employee though - So that all time entries for “Mike” are grouped together…

HOWEVER - I can’t figure out how to “Sum” the groups “Elapsed Time” (which is a date interval) - Bubble doesn’t seem to allow this.

In this screenshot you can see that the only field available for sum is “Revision Round” because it’s a number type.

You can’t sum date intervals.

Any idea how I can display time data?