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
June 8, 2021, 11:09am
2
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
1 Like
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
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
2 Likes
Thank you @ipazin
it worked
is there a way we can download the pie-chart as a excel from knime?
1 Like
ipazin
June 9, 2021, 10:34am
6
Hello @Prag_Mor ,
glad you made it. It’s is possible to have images from KNIME in Excel. See here:
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
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
June 11, 2021, 8:27am
8
Hello @Prag_Mor ,
it’s not working? You get some error or?
Br,
Ivan
@ipazin mean to say no option to download/export as an excel
ipazin
June 15, 2021, 10:12am
10
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
system
Closed
December 14, 2021, 10:13pm
11
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.