RELATED IDEAS
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:
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 |
-
-
-
-
-
-
-
-
-
-
- +1
© 2025 Aha! Labs Inc.•All rights reserved
We want to create a report that shows the average time spent in each phase of the epic workflow. We’ve built formulas to calculate the number of days between workflow statuses, with variables named “Development,” “Planning,” and “Design.” Each variable measures the days between two specific workflow statuses.
When we generate the report, it aggregates all statuses together and displays a combined average, rather than showing the average time for each status separately. Adding these variables to the X-Axis results in a combined average, and placing them in the Series field does not calculate the averages as needed.
To work around this, we’ve created individual charts for each variable, but our goal is to display all the data in a single, aggregated report.
Our request is to add the ability to calculate and display the average for each variable in the “Series” field within the report.
There is a new example report that may be what you are looking for. Go to Roadmaps > Overview then toggle to the Example reports and choose Ideas in the filter. The report is called Column chart: Idea status average time by month.
Yes, we're facing the same issue. What would be even better is if we could somehow track trends - one of the questions we are trying to answer is whether we are getting better at moving ideas out of "Reviewing" status into "Likely/Unlikely to Implement".