1 Reply Latest reply on Nov 17, 2011 1:16 PM by philmodjunk

    Counting different values in one field by month

    hannahcho

      Title

      Counting different values in one field by month

      Post

      I have a drop down list in a field and there are 8different categories that I can select (extension, new, amend, cancel, etc)

      I want to count the total numbers for each value by month.

      There is another field in which I enter the creation date.

       

      How can I count the total number by month?

       

      thank you so much for all your kind help in advance.

        • 1. Re: Counting different values in one field by month
          philmodjunk

          add a calculation field that computes the date of the first day of the same month as the date in the creation date field:

          Call it cMonth for our example:

          CreationDateField - Day ( CreationDateField ) + 1

          specify date as it's return type.

          Now you can sort your records by cMonth, then by the category field.

          If you define a summary field; cRecordCount as the "count of" a nevery empty field such as a primary key field, you can put this field in a sub summary layout part "when sorted by" your category field and it will give you the monthly count for each category value.

          If you remove the body layout part from this layout, you can list just the counts for each category instead of every single record.