Pie/Donut Chart

[Prag_Mor]

Dear Knimers,

Please need help to get this output in Knime if the count is scattered like below

A	B	C	D	E	F	G	H	K
11								3
6	1	5	1
12		6	2	1				8
								15
3								1
1								1
3		2						2
1
2		2		2	1	1		1
1		1	1					1
								1
								1
1
2
13		2						12

Thank you

[ipazin]

Hello @Prag_Mor,

can you explain it a bit more? Are columns (A,B,C…) your nominal values? What aggregation method you need? Should missing values be taken into account?

Br,
Ivan

[Prag_Mor]

Its sum of all the values

Please check below for the correct input

A	7000
B	300
C	900
D	300
E	10
F	5

[ipazin]

Hello @Prag_Mor,

if I got it right use Unpivoting node and include all columns as value columns and none are retained. Then simply configure Pie/Donut Chart node with ColumnNames as category column with aggregation method sum with ColumnValues as frequency column.

Br,
Ivan

[Prag_Mor]

Thank you @ipazin

it worked

is there a way we can download the pie-chart as a excel from knime?

[ipazin]

Hello @Prag_Mor,

glad you made it. It’s is possible to have images from KNIME in Excel. See here:

Export Charts on an Excel sheet

Hello there, I have been trying to export several charts on an Excel file, but it appears that this does not work. At least not in my way. I managed to export the chart as an image (i used the image writer node), but, is it possible to export it on an excel sheet instead?

(Tip: there’s a forum search you can use like I just did to find above linked topic. And maybe you’ll find answer faster )

Br,
Ivan

[Prag_Mor]

Thank you @ipazin

Yes you are correct, its not working for me as well to export as an excel files.

Will check in forum.

[ipazin]

Hello @Prag_Mor,

it’s not working? You get some error or?

Br,
Ivan

[Prag_Mor]

@ipazin mean to say no option to download/export as an excel

[ipazin]

Hello @Prag_Mor,

you mean download/export chart from View? If so that can not be done but you can export it to Excel as explained in above linked topic.

Br,
Ivan