Can't split bar chart as needed with Interactive charting

I'm having a problem where I need to draw a bar chart as follows but however I split the data I can't recreate this using Interactive charting tool.

Dataset has columns for Exited which is 0 or 1 based on Churn or non Churn and also gender is available either Male or Female.

Developer Tools

Accepted answers

FinnCharlton

Hi @MoatazMohamedd, it looks like your Y axis is set to your Churn field. This field should be the 'Count' field. To plot this graph, aggregate your data first:

Before the Interactive Chart tool, add a summarize tool. Group by Gender and Exited, and add a count of any field.
Now in the Interactive Chart tool, Put Gender on the X axis and Count on the Y axis.
Go to the Transformations tab and add a 'Split' on the Exited field.

Give us a shout if you run into more trouble!

All comments

Christina_H

You need to use the Transform option to split the data by churn

MoatazMohamedd

Your output is the exact graph I'm looking for but when I try splitting by Churn it doesn't produce the required output.

What data types are you using or what are the X & Y Axis set to?

MoatazMohamedd

I think the problem is that the 0 (non-churn) layer is not visible and I don't know why.

FinnCharlton

Hi @MoatazMohamedd, it looks like your Y axis is set to your Churn field. This field should be the 'Count' field. To plot this graph, aggregate your data first:

Before the Interactive Chart tool, add a summarize tool. Group by Gender and Exited, and add a count of any field.
Now in the Interactive Chart tool, Put Gender on the X axis and Count on the Y axis.
Go to the Transformations tab and add a 'Split' on the Exited field.

Give us a shout if you run into more trouble!

MoatazMohamedd

Thank you so much, this worked perfectly!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703