Documentation and SupportV5 User Manual Using Fix (Table Grid View) ConfiguratorWhat are all possible Value, Counts, or Aggregates available?

What are all possible Value, Counts, or Aggregates available?

1. Text Field Type

Text Field Type

1.1. Value

This will give you the exact value that is entered into this field.

1.2. Count

This will give you a count on how many entries there are in this field.

1.3. Count Distinct

This will give you a count on how many distinct entries there are in this field.

1.4. Distinct

This will give you distinct values that are entered in this field.

2. Number Field Type

Number Field Type

2.1. Value

This will give you the exact value that is entered into this field.

2.2. Count

This will give you a count on how many entries there are in this field.

2.3. Count Distinct

This will give you a count on how many distinct entries there are in this field.

2.4. Distinct

This will give you distinct values that are entered in this field.

2.5. Sum

This will give you a sum of the entries in this field.

2.6. Avg

This will give you an average of the entries in this field.

2.7. Min

This will give you the minimum value that has been entered into this field.

2.8. Max

This will give you the maximum value that has been entered into this field.

3. Date Field Type

Date Field Type

3.1. Value

This will give you the exact value that is entered into this field.

3.2. Distinct

This will give you distinct values that are entered in this field.

3.3. Day of Week

This will break the date down by the day of the week.

3.4. Week

This will break the date down by the week.  This will give week numbers, starting the first week of January as 1.

3.5. Month

This will break the date down by the Month.

3.6. Month+Year

This will break the date down by the Month and Year.

3.7. Quarter

This will break the date down by the quarter.

3.8. Year

This will break the date down by year.

3.9. Date

This will break the date down by the exact date, i.e. 2014-11-10.