Forum Discussion
Solved
Defect aging pivot chart
Need help in reflecting days in <10 days, < 20 days, etc. in Pivot chart (see attached)? Ultimately, the desired output is the Active Defect Age Analysis chart included in attachment. Thanks
See the attached version. I added a helper column to the source data, and changed the status to be able to sort it.
The solution might involve some creative grouping of the 'age of defect' in the row labels. It's difficult to get the desired chart because the data is not all there and there are no records for "critical", for example.
Please see updated attachment. Thanks