Two strings-types columns and the frequency of their values' combination. How can I plot them?

Hi all,

I would like to plot the attached table, but I do not find a smart way to do it...

I would like to have the "Value 1" in the x-axis and the "Value 2" in the y-axis, reporting also the frequency of their combination.
I figured out two possible methods:
- A bubble chart with the bubble size representing the frequency:
    I didn't manage to do it, being the x- and the y- values string-types
- A matrix/table (MxN values) were every cell has a gradient of color related to the frequency:
    Is there something similar in the KNIME nodes/ BIRT Reporting?

Does anybody have a better idea how can I plot my table or can anyone answer my questions?
Thank you very much for your help,

Hey lulu,

does the attached workflow do the job?


Hi Ferry,

thank you very much for your help!

It is a great idea! At the beginning didn't work, maybe because the too huge amount of data I had. I tried to use a "Edit Nominal Domain" instead of a "Size Manager" node, and now seems to work.



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