Group & Count Values to Make Bar Graph
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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?
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
