In 1 pie chart i want to see how many cases are Resolved vs Unresolved. In the 2nd pie (same chart), i want it to create a pie of the unresolved cases and show the buckets of how many days they have been open.
I have attached the sample data set and tried to draw what i expect. In the drawn pie chart i want to see that of the unresolved cases, 3 are in the "Less than 5 days" range, then 1 in the "5-10 days range" m 10 in the "10-20 days days" range, then 3 in the "20+ days" range.
Any assistance would be helpful.
Bookmarks