Group By Question

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.

Data Investigation

Accepted answers

flying008

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 :

录制_2022_04_25_12_34_52_185.gif

All comments

Qiu

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

0425-ccano3.yxmd

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.

cwd.yxmd

ccano3

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703