Visualising Transfers on a Sankey Chart
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):
Pretty sweet huh?