Aggregated Count of Survey Responses by

[dsims]

I have a pivot table that counts survey responses in a single field that is aggregated by case manager assignment. The purpose is to compare average improvements in client health status across case managers. On occasion, a client may have completed the survey twice during the reporting period. In these cases, the latest survey response should be counted. So far, the pivot table is counting these clients twice.

I do not have access to the script editor for changing the load script. I have found and tried several solutions for similar problems on the forum without success. 

[Or]

In this case, it looks like you could use count(distinct PatientID) if you need the count of patients for each response (response being the dimension).

[dsims]

Thanks, I'll give that a try. 

[dsims]

Thanks, I'll give that a try. 

[dsims]

Can you say more about flags? I need to familiarize myself with the concept. 

[dsims]

Never mind--I found a resource on flags in the forum. Thanks!

[dsims]

Thank you for the assist!