Color manager: application to more than one column

Hi

In my data for polling places in the USA, I count how many polling places are in each county over time/poll instances. I want to display the data in a line plot, for each county a line, and I would like the lines to get coloured according to the value it represents.

Therefore, I pivoted the data and wanted to apply a Color Manager node on it. However, I only can apply the colours to one single column. Therefore, I created a colour model with the min/max value of the count data and the Color Manager node and tried to apply it to the pivoted data by a Color Appender node. However, there too, I can apply the colour only to one single column.

In a second attempt, I pivoted the data coming out of the Color Manager node, to realise, the colouring was erased by the pivot node.

Is there a solution to my problem? Please find the workflow at US polling places – KNIME Community Hub

Kind regards

Thiemo