Problem with Sankey Diagram

[MatteoSerafino]

I created a test mysql table as follow:

**s	t	c**
X	i	1
X	j	2
X	k	3
Y	i	3
    Y	j	3
Y	k	8

However, also with this simple input, after I selected as dimensions s and t and metric=c I get the error:
Error. This Sankey diagram will not render if the 2 dimensions share a value. Try selecting data fields that do not share a value.

Any Idea why?

[jmcmurry]

I had this question too and played around. I got it to work by flattening the data to one pair per row and then leveraging record count. There's probably a better way, but I couldn't get it to work either.

source	destination
X	i
X	j
X	j
Y	i
Y	i
Y	k
Y	k
Y	k
Y	k
Y	a
a	k
X	a
a	k

If helpful you can copy here and resulting viz here