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?

Advertisement

This entry was posted in BI.