I have a dataset where sites reported data monthly, or they were supposed to. So, some sites didn't submit data for some months. I'd like to count up the number of valid reports by site to see if compliant sites differed from non-compliant sites. The data are in long format, such that...
SITE REPORT MONTH DATA
A ABC June 10
A ABC JULY .
A ABC Aug 3
A XYZ June .
A XYZ June 15
B ABC June 6
B ABC June 2
I'd like to end up with a data so I can say that Site A 2 valid ABC measures, and 1 valid XYZ measure, and then take those numbers and compare them to Site B.
Thank you, but this solution only gives me the number of potential data points, not the number of valid entries. For example, there were 15 opportunities for Site C to submit data for Report X (15 rows per site). Site C submitted 3 of 15 reports. The Summary Table solution you offered gave me Site C=15. It should be Site C=3.
If you subgroup on Site, it will create a new column for each value of Site. You then can create a new column which is the Delta for Site A and Site B