Forum Discussion
College Class Schedule Analysis
hi, Anonymous
Consider only END-TIME for your review.
And use YEAR and MONTH filter for your controls.
Download the visual
Histogram Chart - Microsoft Corporation
Download sample
Histogram.1.1.2.0.pbix
Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.
Best Regards,
Rfranca
I could be wrong, but I do not think this custom visual will solve the problem I have describe. The custom histogram visual shows two dimensions of: Bin and frequency (count of occurrences). If the Bin is defined as the start or end time and then we use count of occurrences for the values, we end up with a visual of time usage but it does not account for the days in the week. For example, most 3-credit courses meet Monday, Wednesday and Friday. By not including the day name, we will not see time openings on Tuesday and Thursday because we are looking at the entire year, term or month.
I keep thinking about a calendar type component or heat map visual of day/time but maybe I'm not going about this the right way.
To reintegrate the challenge, I am attempting to identify high and low usage time blocks throughout the week (Monday-Friday). The data contain everything needed to identify the blocks but how to visually represent this in an intuitive fashion has eluded me.
Thanks!
Hi Anonymous,
What's the expected outcome? Maybe you can assign an ID for each usage.
Best Regards,
Dale
The outcome desired is to identify low use time blocks so as to best schedule faculty meetings for professional development. Because not all time blocks are the same duration, it is a bit more challenging. A heatmap grid might work well but again, I'm not sure what would be most useful as a visual tool for those who will be utilizing it.
On a related note, I also believe solving this problem may help me work throught the next challenge which is classroom utilization.
Thanks!
