Sankey Plugin confuiguration with more than two steps

Grafana
1

Hello everyone,
I am new to Grafana and tried to create a sankey panel with plugin netsage-sankey-panel.

For data source, I use MySQL with a table:

| Source | Step1 | Step2 | Target | Value |
| KategorieA | KategorieB | KategorieC | KategorieD | 10 |
| KategorieB | KategorieC | KategorieC | KategorieF | 5 |
| KategorieB | KategorieB | KategorieE | KategorieD | 5 |
| KategorieB | KategorieD | KategorieE | KategorieF | 5 |

Now I want to visualize the step from left to right as sankey chart. Expected Result:

image
image3430×1806 382 KB

But my chart visualizes the steps only in two layers:

image
image1165×438 40.9 KB

With this code:

SELECT Source AS source, Step1 AS target, Value AS value
FROM sankey2_data
UNION ALL
SELECT Step1 AS source, Step2 AS target, Value AS value
FROM table
UNION ALL
SELECT Step2 AS source, Target AS target, Value AS value
FROM table;

How can I transform the data, so Grafana notices that “KategorieB” is only one connection?