Reformat data for Line Chart

KNIME Analytics Platform
1

Hi,
I have the following table
image
And I want to create a line chart to show the value per country overtime in the quarters.
I think to do so, the structure of my table should be

country | Q1 | Q2 | Q3 | Q4
Exampe | 100 | 150 | 125 | 35

Right? Is there a fast way in knime to format my data source in this way?

2

Sounds like a use case for the Pivoting node: group by Country, pivot on Quarter, aggregate on Count using “first”.

image

2 Likes
3

Thanks, @elsamuel! That’s why I love the Knime Community! :+1:t2:

1 Like
4

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