Visualising Transfers on a Sankey Chart

Posted on Updated on

Earlier this month I posted a method of getting a Doughnut Chart in HCM Cloud despite only the traditional pie chart being supported – with the cunning use of Google Charts, as first shown by Damien Roux and Julian Challenger.

Google Charts can do a lot more than just doughnuts though. Have a look at Gallery 1 and Gallery 2 for a broader range.

One that particularly caught my eye was the Sankey Chart, which I thought would be an excellent way of visualising Global Transfers in your organisation. It took a little fiddling and some Logical SQL to get the data just right, but displaying the data by calling out to Google Charts is essentially using the same method as Damien/Julian first did.

Here’s my Sankey Chart showing the transfer of workers around an organisation (LE names on the chart are blurred):

Sankey

Pretty sweet huh?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s