WPS Statistics Fields on macOS FAQ

Last updated:July 21, 2026

When using WPS Statistics Fields, the most common questions focus on summary methods, field setup, and result display, with 3 FAQ items and a glossary included.

FAQ

What summary methods are available in a statistics field?

  1. Right-click the statistics field title and select Field Settings.
  2. Open the Summary Method list.
  3. Choose Sum, Count, Average, Max, Min, Distinct, Distinct Count, or Concatenate based on your data type.

Why does the statistics field not show the result I expected?

  1. Check whether the target data table and field are selected correctly.
  2. Confirm that the related field has already been established and contains data that can be summarized.
  3. Review whether filter conditions are excluding some records from the calculation.

Can I change the statistics field configuration after creating it?

  1. Right-click the title of the statistics field.
  2. Select Field Settings.
  3. Adjust the target field, summary method, or conditions, then review the updated result.

Glossary

TermDefinition
Statistics fieldA field type used to automatically aggregate related records.
Related fieldA field that connects records or tables and provides the basis for aggregation.
Filter conditionA rule used to limit which records are included in the summary.
Distinct CountA count of non-duplicate values after deduplication.