Generic Echarts - Prompt

Hi,
I have a problem with Generic Echarts in this exemple.
KNIME_GECHARTS.knwf (88.1 KB)

Here is a small dataset. In the first example, we can see the graphical evolution of A50 over time. What I am trying to do in more detail is to insert two curves:
Line 1 => A50 if column list = Piste Sable CD-Souple
Line 2 => A50 if column list = Piste Sable CG-Souple

Does anyone know how to do or simply if it’s possible.
Thanks
Br

data
SW DATA 092024.xlsx (10.1 KB)

1 Like

Hey there,

I think what makes this a bit difficult in this case is that there are a lot of data gaps in the data. I have pivoted your data to get columns for each value in List column:

With some prompting K-AI I managed to get it to look like this:

After first prompt it only showed dots, except when there were values on consecutive dates in a series.

I then asked K-AI to connect the dots regardless and it did.

Then it looked odd as the value range of y-axis was 0-6 whereas your data is between ~5.5 and 6 so I asked K-AI to adjust the visible range, and it did.

Screenshot above is the final outcome…

Here is the WF:
KNIME_GECHARTS.knwf (106.4 KB)

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.