Vjylku

What is the most triangles you can make from a capital "H" and 3 straight lines?

How to apply float precision (type specifier) in a conditional f-string?

Would these multi-classing house rules cause unintended problems?

Difference between two quite-similar Terminal commands

How to acknowledge an embarrassing job interview, now that I work directly with the interviewer?

Using only 1s, make 29 with the minimum number of digits

Disable the ">" operator in Rstudio linux terminal

Isn't using the Extrusion Multiplier like cheating?

Process to change collation on a database

Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?

How can animals be objects of ethics without being subjects as well?

Explain the objections to these measures against human trafficking

Cryptic with missing capitals

A minimum of two personnel "are" or "is"?

Can you combine War Caster, whip, and Warlock Features to Eldritch Blast enemies with reach?

Why Normality assumption in linear regression

A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?

Does fast page mode apply to ROM?

Book where aliens are selecting humans for food consumption

Word or phrase for showing great skill at something without formal training in it

Avoiding morning and evening handshakes

Does Windows 10's telemetry include sending *.doc files if Word crashed?

Can a person refuse a presidential pardon?

How to prevent users from executing commands through browser URL

Pivoting Tables and using Frequency in ArcGIS Desktop?

Calculate frequency of a attribute field per polygonArcGIS median value from layer?Creating iterative Select by Location, Summary Statistics tool using ModelBuilder?Summarizing Table on 2 fieldsCreating summary table using ArcMap 10.2 Report Wizard?Proper Use of QGIS tool: “Frequency analysis”ArcGIS frequency analysis toolCalculating area of polygon within Buffers in ArcGIS for Desktop?Calculating max and average distance from point to points in ModelBuilder?Calculating statistics for defined grid cells in ArcMapSum polygon areas by class in ArcMap?

0

I have a points layer of specimen samples. They have a field called "RESULT" which is a string field containing the results of a test, "Positive" and "Negative"(you can only see negative in the pic but trust me they're there).

I would like to determine how many positives and negatives are in each county, with each county having a COUNT_POSITIVES and COUNT_NEGATIVES column.

I've tried the Summary Statistics, Table Intersect, Pivot, and Frequency tools in ArcToolBox. The closest I've gotten is the output from the Frequency Tool:

but I'd like to "unstack" the results column so that for each county the table has a column for negatives and positives with their respective counts by county.

You can do this in about 2 seconds in Excel. Is there an easy way to do this in ArcGIS that I'm missing? This is the only response I could find but the case field in summary statistics won't work due my fields being strings (Calculate frequency of a attribute field per polygon)

arcgis-desktop summarizing frequency

share|improve this question

edited 9 mins ago

PolyGeo♦

53.6k1780240

asked 1 hour ago

BenWBenW

127119

add a comment | 

0

I have a points layer of specimen samples. They have a field called "RESULT" which is a string field containing the results of a test, "Positive" and "Negative"(you can only see negative in the pic but trust me they're there).

I would like to determine how many positives and negatives are in each county, with each county having a COUNT_POSITIVES and COUNT_NEGATIVES column.

I've tried the Summary Statistics, Table Intersect, Pivot, and Frequency tools in ArcToolBox. The closest I've gotten is the output from the Frequency Tool:

but I'd like to "unstack" the results column so that for each county the table has a column for negatives and positives with their respective counts by county.

You can do this in about 2 seconds in Excel. Is there an easy way to do this in ArcGIS that I'm missing? This is the only response I could find but the case field in summary statistics won't work due my fields being strings (Calculate frequency of a attribute field per polygon)

arcgis-desktop summarizing frequency

share|improve this question

edited 9 mins ago

PolyGeo♦

53.6k1780240

asked 1 hour ago

BenWBenW

127119

add a comment | 

I have a points layer of specimen samples. They have a field called "RESULT" which is a string field containing the results of a test, "Positive" and "Negative"(you can only see negative in the pic but trust me they're there).

I would like to determine how many positives and negatives are in each county, with each county having a COUNT_POSITIVES and COUNT_NEGATIVES column.

I've tried the Summary Statistics, Table Intersect, Pivot, and Frequency tools in ArcToolBox. The closest I've gotten is the output from the Frequency Tool:

but I'd like to "unstack" the results column so that for each county the table has a column for negatives and positives with their respective counts by county.

You can do this in about 2 seconds in Excel. Is there an easy way to do this in ArcGIS that I'm missing? This is the only response I could find but the case field in summary statistics won't work due my fields being strings (Calculate frequency of a attribute field per polygon)

arcgis-desktop summarizing frequency

share|improve this question

edited 9 mins ago

PolyGeo♦

53.6k1780240

asked 1 hour ago

BenWBenW

127119

share|improve this question

edited 9 mins ago

PolyGeo♦

53.6k1780240

asked 1 hour ago

BenWBenW

127119

share|improve this question

edited 9 mins ago

PolyGeo♦

53.6k1780240

asked 1 hour ago

BenWBenW

127119

edited 9 mins ago

PolyGeo♦

53.6k1780240

edited 9 mins ago

PolyGeo♦

53.6k1780240

asked 1 hour ago

BenWBenW

127119

asked 1 hour ago

BenWBenW

127119