Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Group & Count Values to Make Bar Graph

Faronnj
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:

 

Faronnj_0-1579040460258.png

 

The raw data: 

LastFusion Gained
11
20
30
41
54
61
74
8-1
9-1
102
113
124
131
140
15-2
164
171
180
193
200
215
221
231
240
252
261
274
282
292
301
310
320
333
341
351
360
372
380
390
401
415
420
432
442
452
461
471
481
490
505
512
520
531
540
552
562
575
580
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 GainedNumber of Children
-21
-12
020
120
212
34
45
54

 

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
afv2688
16 - Nebula
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

 

-21
-12
016
116
211
34
45
54

 

Regards

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

DiganP_0-1579041463244.png

Digan
Alteryx
Faronnj
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 GainedNumber of Children
-21
-12
016
116
211
34
45
54
afv2688
16 - Nebula
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

Faronnj
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 

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

 

Thank you in advance,

 

Nick 

DiganP
Alteryx Alumni (Retired)

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

DiganP_0-1579046694531.png

Digan
Alteryx
Labels