Create split bar chart by category

mizzou541

Can Alteryx create a split bar chart like the one pictured below (done in Tableau)?  I've been able to create a stacked bar by category but what I'm being asked to create is like the below.  So I want the x-axis split on category.  The grand total is great but I could do without that if I could figure out how to split the x-axis like below.  Is this possible in Alteryx?

danilang

Hi @mizzou541 

You can do this by taking advantage of the batch capability of the Interactive chart

The color table maps the category to a color

The interactive tool will accept standard named colors, "Blue", "Green", "Silver" but you can also specify RGB values.  This is the only non-dynamic part of the process.  You need to one color defined for each of your categories or the category wont show up in the output.  The join tool matches color colors to the corresponding category in the input.   

The Interactive Chart tool is set to batch on "Name" since that's column that comes out of the transpose tool.  In batch mode it produces one record for each unique value of the Batch field. The horizontal bar color is set to "Variable" with [Color] field as the value.  The Layout tool takes all the records that come out of the batched Interactive Chart and aligns them horizontally, to give you something that looks like this

The output isn't perfect(especially the colors), but it should be enough to get you started

Dan

HorizontalStackedGraphs.yxmd