Can't split bar chart as needed with Interactive charting

[MoatazMohamedd]

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.

[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 · Accepted solution]

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!