-
15. Re: Sankey diagram made of dynamically generated polygons
John Dixon May 11, 2015 5:55 AM (in response to Scott Avery)Hi Scott,
Thanks for the update. This was my issue as well and I was able to resolve
it after working through the sorts and advanced table calculations.
Thanks,
John
On Fri, May 8, 2015 at 4:16 PM, Scott Avery <
-
16. Re: Sankey diagram made of dynamically generated polygons
andrew.li May 21, 2015 12:32 AM (in response to Olivier CATHERIN)Hi @Olivier CATHERIN,
Thanks for great contribution to the community! I was trying to replicate your design but I got stuck at Step 3: Build dynamic aggregated steps
We will first build the dynamic aggregated steps using parameters and sets. Basically, we want to show Top N Step 1 sorted by the SUM of Size:
- Create a "Top N Step 1" parameter: it should be an Integer with a min and a max
- Create a "Top Step 1" set: right-click on "Step 1" pill / create a set and sort it using Top / By Field / Top / Top N Step 1 (parameter) / Size (indicator) / Sum
- Create an "Agg Step 1" dimension: this should be
IF [Top Step 1]* THEN [Step 1] ELSE 'x Other' END
I use the x in order to easily sort the flows alphabetically.
*the set
Do you mind showing me in screenshots how this is done?
In addition, what does the size column do? How do you determine the size for each row in your data excel?
Thank you so much!
-
17. Re: Sankey diagram made of dynamically generated polygons
Olivier CATHERIN May 21, 2015 12:45 AM (in response to andrew.li)Hi Andrew,
"Step 1", "Step 2" and "Step 3" refer to the dimensions you want to use as nodes in your dataset. In my example, it the name of a column.
The "Size" is also the name of a column in the dataset that is a measure. It could be the number of clicks or an amount. This measure is used to determine the size of the flows in the view. This is described at step 5.
Hope this helps.
Cheers
Olivier
-
18. Re: Sankey diagram made of dynamically generated polygons
andrew.li May 21, 2015 2:05 AM (in response to Olivier CATHERIN)Hi Olivier CATHERIN,
Thanks for the quick response! It was really helpful!
However, my final graph that I came up with after dragging T and Curve polygon to the columns and row respectively, is blank. I have attached the image below. Would you mind enlightening me in this final step?
Thank you!
-
19. Re: Sankey diagram made of dynamically generated polygons
Olivier CATHERIN May 21, 2015 2:09 AM (in response to andrew.li)Could you send me your the twbx so I can take a look at it ?
ocatherin at actinvision.com
-
20. Re: Sankey diagram made of dynamically generated polygons
Rien van Leeuwen May 29, 2015 8:42 AM (in response to Olivier CATHERIN)This is a fantastic viz!
When trying to recreate it, I ran into a problem.
I couldnt reproduce your result; my canvas stayed empty, even though I followed all the steps.
To rule out a an import error, I tried to refresh the data source of your original Workbook using your original Excel file.
After the refresh, your workbook also produced an empty canvas. Also I couldnt see any data in the import screen (only headers)
Can somebody explain this behaviour?
-
21. Re: Sankey diagram made of dynamically generated polygons
andrew.li May 29, 2015 9:10 AM (in response to Rien van Leeuwen)Hello,
i encountered a similar issue. go to the data sheet, under the column "Link", change all the "Link" on every row to "link" (except the header), this is to ensure that the Link column on the data sheet is the same as the model sheet. That ought to fix it.
-
22. Re: Sankey diagram made of dynamically generated polygons
Rien van Leeuwen Jun 1, 2015 2:29 PM (in response to andrew.li)Thanks for the tip. It did the trick.
-
23. Re: Sankey diagram made of dynamically generated polygons
Ricky Wong Jun 9, 2015 7:21 PM (in response to Olivier CATHERIN)Thanks for this post.
couple questions:
1. How to remove the extra white spaces on both sides of the bar charts? (Probably very easy but I can't find the place)
2. Highlighting (I think someone else has the same question). Since we are using different measures on each segment of sankey, is there any easy way to set this up so that hovering on a bar or curve will highlight ALL possible connections? Instead of only the two adjacent (curve or bar) set up with the same measures?
thanks in advance.
-
24. Re: Sankey diagram made of dynamically generated polygons
andrew.li Jun 9, 2015 9:05 PM (in response to Ricky Wong)
Hi Ricky,1) Go the bar chart worksheet, click Size in the Marks card, drag the slider all the way to the end. This would increase the width of the bar chart to the max.
2) not sure if you mean this but perhaps u can try this out:
Go to the top menu bar, select Dashboard, choose Actions, click Add Actions, select Highlight.
In the Highlight dialog box, under Source sheets, select all the sheets (there should be 3).
Under Target sheets, select all sheets (there should be 3)
Under Target highlighting, select All Fields.
Hope this helps.
-
25. Re: Sankey diagram made of dynamically generated polygons
Ricky Wong Jun 10, 2015 3:10 AM (in response to andrew.li)Hi Andrew:
1) That did the trick. Thanks so much.
2) I had already tried your method before but the hover only highlights the adjacent measures (see pic attached below). I am hoping that the areas I circled will also be highlighted.
I think it may have something to do with the fact that the other measures were not used on that segment of the Sankey I highlighted (the brown part above):
I'm not sure if it is possible to add the other measure to the sankey chart that would allow the highlighting to work on them without impacting the chart itself.
cheers!
Ricky
-
26. Re: Sankey diagram made of dynamically generated polygons
Cameron Boy Jun 10, 2015 10:48 AM (in response to Olivier CATHERIN)1 of 1 people found this helpfulFor those who need sql to create the data model with MIN_MAX and descending path for the Max portion:
SELECT 1 AS link,
-6 + 0.25 * (LEVEL - 1) AS t,
LEVEL - 1 AS path,
'Min' AS min_max
FROM dual
CONNECT BY LEVEL <= 49
UNION
SELECT 1 AS link,
6 - 0.25 * (LEVEL - 1) AS t,
(LEVEL - 1) + 49 AS path,
'Max' AS min_max
FROM dual
CONNECT BY LEVEL <= 49
order by 4 desc,2
-
27. Re: Sankey diagram made of dynamically generated polygons
Nevena Lalic Jun 15, 2015 1:13 PM (in response to Olivier CATHERIN)Thanks for this!
One question: how do you get rid of the silly white space at the top of the bar graphs on the sides of the polygon graph? I can't seem to find the right "cheat" for that.
Olivier, in case you're interested, I intend to modify your standard dashboard in two ways:
1) Allow users to specify only one origin point at the left (so they can see all the outflows from that point) or at the right (so they can see all the inflows to that point) - I think I should be able to do that using a parameter-driven set.
2) Allow users to specify the level of granularity of each of the "Steps", instead of the number of items in each step - or maybe both? For some applications, it makes more sense to allow users to choose between levels of aggregation like Region/State/City than to choose how many items they see in each Step.
I hope that made sense!
N.
-
28. Re: Sankey diagram made of dynamically generated polygons
Selvarajan Kandasamy Jun 15, 2015 11:25 PM (in response to Nevena Lalic)Hi Nevena,
For your question, did you try fixing the vertical axis scale, 0-100? Hope this helps.
Selva
-
29. Re: Sankey diagram made of dynamically generated polygons
Nevena Lalic Jun 19, 2015 12:19 PM (in response to Selvarajan Kandasamy)Yes - thanks! There's still a bit of a misalignment, but at least the space at the top is gone now!