alteryx Community

# Alteryx Designer Discussions

SOLVED

## Group & Count Values to Make Bar Graph

8 - Asteroid

Hello Alteryx Community,

I have a new question for today, I will show you the data and what I am trying to create and explain the steps I have tried on alteryx (i think I am messing up the tile tool).  This is the final graph I am trying to create:

The raw data:

 Last Fusion Gained 1 1 2 0 3 0 4 1 5 4 6 1 7 4 8 -1 9 -1 10 2 11 3 12 4 13 1 14 0 15 -2 16 4 17 1 18 0 19 3 20 0 21 5 22 1 23 1 24 0 25 2 26 1 27 4 28 2 29 2 30 1 31 0 32 0 33 3 34 1 35 1 36 0 37 2 38 0 39 0 40 1 41 5 42 0 43 2 44 2 45 2 46 1 47 1 48 1 49 0 50 5 51 2 52 0 53 1 54 0 55 2 56 2 57 5 58 0 59 3

And this is the step I am having trouble creating to make the bar graph: I need alteryx to go through the fusion gained column of the raw data, group by cohorts (-2, -1, 0, 1, 2, 3, 4, 5) and count for those numbers to create a similar chart:

 Fusion Level Gained Number of Children -2 1 -1 2 0 20 1 20 2 12 3 4 4 5 5 4

I have tried using the tile tool & summarize but I am not getting the correct counts.  Always appreciate if you attach a workspace since it greatly helps me understand my mistakes.  Thank you in advance as always!

Nick

7 REPLIES 7
16 - Nebula

Hello @Faronnj ,

You shared with us a table with 59 rows but the count summs 68.

Is there something I am missing?

Edit: I get the following

 -2 1 -1 2 0 16 1 16 2 11 3 4 4 5 5 4

Regards

Alteryx Alumni (Retired)

@Faronnj Attached is the workflow that uses the interactive tool to create the graph. You can use the summarize tool to aggregate the 'fusion gained' and then graph it. Does this help?

Digan
Alteryx
8 - Asteroid

I apologize, I was using the wrong summarized count: here is the correct number and chart that I am trying to make:

 Fusion Level Gained Number of Children -2 1 -1 2 0 16 1 16 2 11 3 4 4 5 5 4
16 - Nebula

Hello @Faronnj ,

Grouping by Fusion Level and doing a count of the Fusion Level values should give you the right number, like using a pivot table on excel

Regards

8 - Asteroid

@DiganP This is exactly what I was trying to do, I must have been trying to make it too confusing with the tile tool.

thank you also @afv2688

8 - Asteroid

@DiganP when the chart is configuring on the x-axis it does not use all the values and skips some?  Is there a way to make it post every value on the x-axis? so it doesnt skip -1, 1, 3, 5.