Good news, everyone!
I think I've finally designed The Ultimate Chart I've been looking for, - it's a pinnacle of FSW statistics visualization ;D
It's now available on the Charts sheet.
On this chart, all applications are sorted by their received date, from left to right, with their statuses shown. May 1 is on the left, and currently May 8 is on the right (you can hover your mouse over the chart in the spreadsheet to see exact app. received dates).
Bar length is proportional to application count (not percents, like on the older chart), so it's easy to see how many applications it's left to process for a given App. Received date, - AND it's also easy to extrapolate trends into the future, because the chart shows application status dynamics (on the vertical axis), not just a static picture for today.
Moreover, all abandoned (inactive) spreadsheet entries are also clearly visible, with no fee encashed for a long time. I suppose, these entries also include some percentage of returned applications, which just didn't get back to applicants yet, and maybe some rare applications which for some reason take significantly longer time to process.
See some additional examples on this screenshot (clickable):
As a bonus, here's another version of this chart. It includes all applications with "At CIO" status, for an overview. You can't find this version in the spreadsheet, but it helps to visualize the huge pile of applications CIC has to process now : ;D
I think I've finally designed The Ultimate Chart I've been looking for, - it's a pinnacle of FSW statistics visualization ;D
It's now available on the Charts sheet.
On this chart, all applications are sorted by their received date, from left to right, with their statuses shown. May 1 is on the left, and currently May 8 is on the right (you can hover your mouse over the chart in the spreadsheet to see exact app. received dates).
Bar length is proportional to application count (not percents, like on the older chart), so it's easy to see how many applications it's left to process for a given App. Received date, - AND it's also easy to extrapolate trends into the future, because the chart shows application status dynamics (on the vertical axis), not just a static picture for today.
Moreover, all abandoned (inactive) spreadsheet entries are also clearly visible, with no fee encashed for a long time. I suppose, these entries also include some percentage of returned applications, which just didn't get back to applicants yet, and maybe some rare applications which for some reason take significantly longer time to process.
See some additional examples on this screenshot (clickable):
As a bonus, here's another version of this chart. It includes all applications with "At CIO" status, for an overview. You can't find this version in the spreadsheet, but it helps to visualize the huge pile of applications CIC has to process now : ;D