Group By Question

[ccano3]

Hello,

I am a beginner in Alteryx and I am attempting to prepare my data for analysis. I have a 'county of harvest' column and a 'result' column that displays whether the lab result was positive for CWD or not detected. I am attempting to group the counties together and formulate new rows that sum up the number of 'positive' cases and a row that sums up the number of 'not detected' (aka negative) cases. I would appreciate any assistance! Thank you in advance. 

[Qiu]

@ccano3 
A Summarize tool will be a good fit for your case, if I understand correctly 

[ccano3]

Hello!

My mistake! The "Count" column is the population count for each county. I probably should adjust the name of that column. I do need to compute the number of positive cases and the number of not detected (negative) cases per county. When I perform the Summarize query, I am able to see the separation however, it does not count the total number of positive cases and the total number of negative cases. I hope this makes sense. Thank you! 

[Qiu]

@ccano3 
Can you give a sample output? so I can match.
And would apprecaite you can post the data instead of a snapshot. :)

[ccano3]

Hi,

I have added my .yxmd. I hope it helps! I'm posting a reference photo of how I would ideally like my output to look. Thank you for your assistance and patience. 

[flying008 · Accepted solution]

Hi,@ccano3 

If Below data is input,

Country of Harvest	Result
Dekalb	Not Detected
Decatur	Not Detected
Fayette	Not Detected
Dyer	Not Detected
Fayette	Not Detected
Fayette	Positive
Fentress	Not Detected
Franklin	Not Detected
Gibson	Not Detected
Gibson	Positive

then you need flow :

[ccano3]

Thank you all for your assistance! Everything worked out great!