Count Function in Report Designer

AndrewRoberts2 — Wed, 08 Feb 2017 15:08:59 GMT

I have a feature layer which I hope to summarize using the report designer. This feature layer has two fields, one called 'Completion Status' which can be one of three things: Completed, In Progress, or Not Started. The second field is a standard date field.

In the report designer I want to create a text boxes which show several summary parameters including:

- A count for the number of features where Completion Status = Completed

- A count for the number of features where Completion Status = In Progress

- A count for the number of features where Completion Status = Completed and fall within two specific dates

Edit: If I could do this solely within the data field that would be great, maybe something like =COUNT(CompletionStatus == Completed)

The only thing I have managed to do at this point is create a box which counts the total number of features in the feature layer.

Any help is appreciated!

-Andrew

topic Count Function in Report Designer in Data Management Questions

Count Function in Report Designer