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
