For this blog post, I’m going for a bit of a rewind: my application. During the first week of dataschool, I had to reviz my application viz and one part which I focused on improving was the intuitiveness of my clock chart. I split it into two 12 hour clocks and utilised floating and shapes to clarify order to read each.

 

Creating New Axes with Trigonometry

First thing I need to create my clock is a calculation of the portion that a given minute is to the whole. To do this I need to first create a “Minutes since Midnight” field to track what each minute is into a day.

Minutes since Midnight
DatePart(“hour”,[Date/Time])*60 + Datepart(“minute”,[Date/Time])

Then I need to calculate the total possible minutes for half the day, this is just a constant.

Minutes in half a day
60*12

Next, I need to convert this into the proportion of the circle.

Angle
2*PI()*([Minutes since Midnight]/[Minutes in half a day])

Now all that’s left is to create my new axes to impose on Tableau.

X
COS([Angle])

Y
SIN([Angle])

Place X on rows, Y on columns, minute on detail (and any other fields you need to disaggregate records on detail), hour on label and set label to min/max->min on minute field. Set an hour filter to 0-11.

 

Duplicate this sheet and then change the filter to exclude on the second. Now build a dashboard and add whatever elements you want to guide your user in using your clocks!