Looker Sankey Diagram - Cycle Found in Data. What Cycle??

[BUSLKEEN]

I am trying to create a Sankey for the first time (I don't use looker much, so be nice :))

The data I have is

Source                             Target                              Measure

DSP REC                        A/AS Revise SP               100

A/AS Revise SP             DSP REC                          50

DSP REC

A/AS Revise SP

It keeps throwing up this "Cycle found in data. This chart does not support cycles in the data"
Where is the cycle?? I don't understand.
I even tried keeping just the first 2 lines and still it errors!
Thanks in advance.

[Lobo-Google · Accepted solution]

Hi @BUSLKEEN, thanks for your post!

It looks like there are repeated values (DSP REC, A/AS Revise SP) in both the Source and Target dimensions.The chart nodes would be self linking, which triggers the error you are encountering. Maybe try using a different dimension for the Source or Target? 

This is called out in the Google Sankey Diagram docs: 

Note: Avoid cycles in your data: if A links to itself, or links to B which links to C which links to A, your chart will not render.

The Looker Studio Sankey documentation page also mentions that the data between the Source and the Target dimensions must be unique. 

Both of the documentation pages above also include some examples, which I hope might help as well! 

[BUSLKEEN]

Thank you! That makes sense