Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'd like to create a chart that shows the average number of working days that items in the column called Requirement Category are in progress and also by their priority.
So far I've managed to create a bar graph where I used Status as a dimension and for the measure I've used this formula =Avg({<Status = {"In Progress"}>} NetWorkDays(Created, Today(), Priority)) just to see what the graph would look like but I don't know how to include the additional criteria. Any help would be greatly appreciated.
Status | Priority | Requirement Category |
In Progress | High | New Functional requirement |
In Progress | Medium | Bug |
In Progress | Low | Enhancement |
In Progress | High | Bug |
Perhaps you can introduce multiple criteria with in analysis like
=Avg({<Status = {"In Progress"}, Field={'Value'}>} NetWorkDays(Created, Today(), Priority))
Hi I tried your suggestion, how do I get it to display multiple items in the chart?
I tried adding multiple measures but it doesn't show the same requirement category which has different priorities.
I'm expecting to see for example,
- medium bugs that have an average of 20 days in progress, but high bugs with an average of 10 days in progress
- low enhancements with an average of 20 days in progress,
- Medium enhancements with an average of 15 days in progress,
- High enhancements with an average of 8 days in progress etc