AnsweredAssumed Answered

Count Function in Report Designer

Question asked by AndrewRoberts on Feb 8, 2017

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

Outcomes