Group & Count Values to Make Bar Graph

[Faronnj]

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 

[afv2688]

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

[DiganP · Accepted solution]

@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?

[Faronnj]

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

[afv2688 · Accepted solution]

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

[Faronnj]

@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 

[Faronnj]

@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.

Thank you in advance,

Nick 

[DiganP · Accepted solution]

@Faronnj You can do it in the spacing section. See below: