1 2 3 4 113 Replies Latest reply on Feb 13, 2019 7:29 PM by Selvi velraj Go to original post
• ###### 15. Re: Sankey diagram made of dynamically generated polygons

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

Hi @,

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

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

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

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

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

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

Thanks for the tip. It did the trick.

• ###### 23. Re: Sankey diagram made of dynamically generated polygons

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?

• ###### 24. Re: Sankey diagram made of dynamically generated polygons

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

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

For those who need sql to create the data model with MIN_MAX and descending path for the Max portion:

-6 + 0.25 * (LEVEL - 1) AS t,

LEVEL - 1 AS path,

'Min' AS min_max

FROM dual

CONNECT BY LEVEL <= 49

UNION

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

1 of 1 people found this helpful
• ###### 27. Re: Sankey diagram made of dynamically generated polygons

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.

N.

• ###### 28. Re: Sankey diagram made of dynamically generated polygons

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

Yes - thanks! There's still a bit of a misalignment, but at least the space at the top is gone now!

1 2 3 4