6 Replies Latest reply on Dec 7, 2018 10:09 AM by Ken Flerlage

Building a simple 2-step sankey

Jason Kim Dec 6, 2018 7:17 AM

Hi,

I want to construct a simple 2-step sankey that looks like this:

I've taken a look at this great tutorial on sankeys in Tableau but I have no idea how to modify it to work with a measure (revenue) as the starting point, nor how to turn it into a 2-step sankey.

If you have any alternative ideas besides a sankey to best illustrate different revenue streams (excluding pie chart), I'm also interested to hear what might my easier alternatives in Tableau might be.

Thanks!

1. Re: Building a simple 2-step sankey

Ken Flerlage Dec 6, 2018 8:32 AM (in response to Jason Kim)

Do you have any sample data you can share?
Like Show 0 Likes(0)

Actions
2. Re: Building a simple 2-step sankey

Sankarmagesh Rajan Dec 6, 2018 9:00 AM (in response to Jason Kim)

Hi Jason,

Please refer below link and build it
https://www.theinformationlab.co.uk/2018/03/09/build-sankey-diagram-tableau-without-data-prep-beforehand/

Thanks
sankar
Like Show 0 Likes(0)

Actions
3. Re: Building a simple 2-step sankey

Jason Kim Dec 7, 2018 7:25 AM (in response to Ken Flerlage)
Thanks for the help Ken - here's a sample data source for two months. I'd like the sankey to display 1 month at a time, but the extra month gives the option to change months or show a MOM comparison in a label

Sankey Datasource.csv.zip 318 bytes
Like Show 0 Likes(0)

Actions
4. Re: Building a simple 2-step sankey

Ken Flerlage Dec 7, 2018 7:59 AM (in response to Jason Kim)

Sankey's typically show flow from one thing to another, but I don't see any such flow in the data.
Like Show 0 Likes(0)

Actions
5. Re: Building a simple 2-step sankey

Jason Kim Dec 7, 2018 9:35 AM (in response to Ken Flerlage)
Maybe I should use a different visualization to illustrate where revenue comes from? Any ideas?

I thought a sankey would do this since we are talking about streams of revenue from various sources (the below diagram in reverse) all contributing to one big pot (total revenue), which contains 3 buckets (ads, syndication, subscriptions), one bucket which is further divided into 2 silos (TV ads, internet ads).

But I'm open to suggestions - I'm not hellbent on making a sankey; just thought it would be a good way to show the different revenue streams' contribution to total revenue without using pie chart / default treemap which I don't think work very well.

sankeymatic_600x600 (3).png 41.7 KB
Like Show 0 Likes(0)

Actions
6. Re: Building a simple 2-step sankey

Ken Flerlage Dec 7, 2018 10:09 AM (in response to Jason Kim)

One of the problems is that your data does not show the subdivisions of TV and Internet Ads. To address that, you'd need some changes to your data. Something like this perhaps:
From there, I'd probably just use good old fashioned bar charts.
If you wanted to see the breakdown of Advertising, you could do a couple of things:

1) Create a hierarchy which includes the Type and Sub-Type. That will give you a little + sign on the type which will allow you to drill down.
Another option would be to do a stacked bar by Sub-Type.
Like Show 0 Likes(0)

Actions