Add aggregated series support to pivots and charts

What is the challenge?

We've recently added 'time in status' functionality to our reporting system. It would be useful to be able to visualize something like:

"average amount of time features have spent in a given status by workspace."

it could make sense to see this on a stacked bar chart, for example, where each workspace would have a column containing:

• not started: 2 days

• in progress: 5 days

• etc

This currently isn't possible to do with aggregated values (sum, avg, count, etc).

What is the impact?

Describe your idea

Add support for aggregated values