-
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?
-
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
Thanks
sankar
-
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
-
-
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.
-
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
-
-
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.