This would be ideal, but I am extracting multiple data as follows:
I'm trying to track a dozen workers delivery statuses or Turn Around Time (TAT) on a week-to-week &/or month-to-month basis & determine if individuals are delivering "on-time", "late" or may be over-loaded with work.
My main criteria or parameters to track are:
Individuals - 12 - 15
Duration - Weekly &/or monthly
Task Deliverable status - "On-time", "Late" & perhaps, some others, but I'll keep it to these to begin with
Once defined, be able to chart it, which I should be able to do. This information will be extracted from a log sheet that I already created.
My issue is that I can define 2 parameters well, but struggling to get in the 3rd parameter into a "clean" table format & then be able to chart these results. Additionally, I would like to have all this defined simultaneously both in some type of table format & in a chart.
In my data table, it's extracting data from my log worksheet, seeking:
Date Range Specified
TAT Status - On-Time, Late, etc.
Just curious if anyone out here was trying or did something similar & how they defined or created their spreadsheets & charts. Examples would be appreciative.
I attached an example file in which I have a chart started on the "Weekly Metrics" worksheet.
If you have other suggestions to condense these tables &/or charts, feel free to do so.