Calendars are a frequent chart type that we see folks creating off of standard heat maps. It's simply having the right date aggregations to arrange it to a calendar look and formatting the cells to look more like a Calendar. One of the blog article includes a walk through on how to create this:
I actually used bars instead because I was using it to track of my activity like you. I would keep things relatively simple on your shelf such that
Columns: [Month] [Weekday]
Rows:[Week Number] [Duration] (Depending on how much this varies, [%of Total Duration] can be used instead of [Duration] since it will allow you to fix you axis)
Color: [Group Size]
It depends on the view but it might be worth consider either applying [Professionals] as a text label or a filter for your data. I would steer clear of using Gantt bars as horizontal bars don't make good calendar views.
Thanks, this is useful, but not exactly what I was looking for. I'm only interested in showing a typical week's worth of data (it's the same schedule repeating every week), so it's a weekly view with days at top and hours on the left. One issue is that the time slots are not all the same length. For example, monday may be 8:45 - 9:00, 9:00 - 9:30, 9:30, 10:15, etc. and different for each day of the week. So the calendar needs to show different size boxes for each time slot.
By some chance, it almost looks like that, because the squares overlap each other, but it seems that the square is centered on the start time instead of top aligned.
As for the professionals, I've used them as an additional left axis, so each individual calendar is grouped by professional. That part works well.
I've been trying all sorts of things, but maybe it just can't be done. Too bad because that would have been a very useful visualization for my project. Now it looks like I'm going to have to create this by hand in Excel or something. Ugh!
Well rviard, you could go with bars, or you could use a calculated field of "start + (end - start)/2" so the center of the box being the middle of your time period would work out right?
I actually have a duration field which was a field I had in excel, so I tried:
[Start time] + ([Duration]/2)
Except I get an error: "Can't divide a date time by a integer"
I also tried the end - start and got the same result. Any idea how I can convert the date? I didn't find any function that looked like it could do it.
Sorry for all the newbie questions...
A duration shouldn't be a date. A duration should be a number (of seconds, hours, whatever). Right click on that field in the Data pane, select "Describe", then "Load" the domain to see what what's in there.
For end - start, you'll need to use the DATEDIFF. For adding a number to a date, you'll need to use DATEADD.
And for the duration to give you the length of your gantt bars correctly you'll need it to be expressed in (fractional) days so 12 hours = 0.5, etc.