Count Function in Report Designer

398
0
02-08-2017 07:08 AM
AndrewRoberts2
New Contributor III

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

Tags (1)
0 Kudos
0 Replies