Playing with new tools...

I'm trying to create a visualization that shows student submissions, differences between full-time and part-time students in a 24 hour clock...

I'm having trouble setting the 2 data sets, beside each other, or stacking them so both are visible. Part time student numbers are less than full time student numbers in most cases, but you can see that little sliver of Orange at 1AM. I want to be able to see both all the time. Can anyone guide me to either rotate 1 data set a few degrees so both are visible or stack the smaller bar on top of the larger bar?

*edited, because my x and y were backwards, now 12AM is at the top center.*

- 3AM was removed, an LTI we use sent all submissions back in batch in the middle of the night

- The issue has been fixed but these are SY17-18 submissions - Represents about 585K rows of student submissions from Canvas Data
- Corrects for PDT/PST from UDT
- Does not correct for individual students who were traveling out of local time

Robert Carroll

I'm still figuring out Tableau myself, but from a mathematical perspective, I'd look at the formula that determined what angle to put things at.

If the bars are 360/24 = 15 degrees apart, then you could make the angles 7.5 degrees apart and not have any gap between them, making it harder to tell them apart. So what I would probably do subtract and add a small offset to each

Note this is pseudo code

In Tableau, you won't need a loop, you'll just need the calculation. For each hour, you'll back up 3 degrees counterclockwise to get the full time and 3 degrees clockwise to get the part time. Now that I think about it, 3 degrees is probably 2 much as they will be separated by 6 degrees of space with only 9 degrees between hours. Making the offset 2 gives you 4 degrees between full/part time for one hour and then 11 degrees to the next hour. That spreads it out a little and lets you make your segments wider if you like.

So, here's my take in Tableau. In this calculation, [Hour] is a decimal part of the hour: 0 = 1 = midnight.

I called this Angle, it includes the rotation by 90 degrees and the clockwise motion as well as conversion to radians so you don't have to do that in every sin() and cos() calculation. You could leave the Radians() off if you want to work with degrees. But I teach calculus and everything we do in calculus is in radians and most computer software requires angles to be in radians, so that's where I went.

Here's an example of the data I was working from (the Amount is totally made up using Excel's =RANDBETWEEN(100,500) just so I would have some numbers)