Thursday, February 18, 2010

Radial Charts

shown below are the calculations for generating a cartesian X and Y coordinate system based upon a "direction" measured in degrees from 1 to 360 and a "speed" measured in wind speed. The result is a powerful mechanism to display wind charts which can be combined with time series or other analysis types, and in general can leverage the rest of the Tableau features.

You only need to know the direction (in degrees) and the wind speed.

The excel file which this book is connected to contains 100% ficticious data. No Wind Farm Corporations were harmed in the making of this workbook.

The X calculation for showing "east west" is:


And the Y calculation for "north south" is:


No comments: