2 x-variables bar chart

[zetitan77]

Hi all,
I’m a newbie here.
I’d like to generate a bar chart with TWO x-variables.
My original dataframe is made up two groups : gender (2) and work department (6).
Each specific combination of gender and department displays a promotion rate.
I would like to display the promotion rate (Y-axis) for each combination of gender and department (12 in total).
My table after pivoting is as follows (12 rows, 3 columns) :
Gender Department Promotion rate
W Marketing 0.14
W Sales 0.2
… … …
M Marketing 0.28
M Sales 0.23
… … …
I can not do that currently as I can select only one category dimension within the Bar Chart node.
Thanks a lot.

[rfeigel]

Could you use a stacked bar chart as described in this post?

How to create a stacked bar chart for Male/Female from a GroupBy node in KNIME?

I am working with KNIME and trying to create a stacked bar chart that shows the distribution of males and females across different departments in my company. Here’s a snapshot of my DataFrame after applying a GroupBy node: insert screenshot here I would like to transform this data into a stacked bar chart where each bar represents a department, and the bar is split into two sections (one for males, one for females) based on the count of each gender in the department. However, I am not sure h…

[tqAkshay95]

Hello @zetitan77 ,

You can use a generic echart node.

Generic ECharts View

[zetitan77]

Thank you very much for your quick reply, that was helpful.
After rearranging my df, I could get what I want with the Bar Chart node !
I proceeded as follows :

Eventually obtained this :

Problem solved !