Skip to main content
Announcements
Happy New Year! Cheers to another year of collaboration, connections and success.
cancel
Showing results for 
Search instead for 
Did you mean: 
CA2
Contributor II
Contributor II

Chart with multiple criteria

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.

 

StatusPriorityRequirement Category
In ProgressHighNew Functional requirement
In ProgressMediumBug
In ProgressLowEnhancement
In ProgressHighBug
   

 

 

Labels (1)
2 Replies
Anil_Babu_Samineni

Perhaps you can introduce multiple criteria with in analysis like

=Avg({<Status = {"In Progress"}, Field={'Value'}>} NetWorkDays(Created, Today(), Priority))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
CA2
Contributor II
Contributor II
Author

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