Skip to main content

When to use Statistics

Choose Statistics when you need summary measures that explain a dataset.

Statistics is most useful when the central question is about counts, totals, averages, ranges, distributions, or comparisons.

Strong signs that Statistics is the right Tool​

Statistics is a strong fit when:

  • you need to summarize numeric Fields
  • you want counts or totals by group
  • you need to compare values across categories or periods
  • you want to inspect unusual highs, lows, or blanks
  • the result should support review, reporting, reconciliation, or quality checks

Typical business situations​

Statistics is commonly used in situations like these:

Summarize activity​

Examples:

  • total sales by region
  • count of cases by status
  • average processing time by team
  • minimum and maximum transaction amounts

Review file reasonableness​

Examples:

  • confirm that total dollars are close to expectation
  • check whether Record counts changed unexpectedly
  • identify unusually high or low values
  • compare a new output to a prior run

Support reconciliation or operational review​

Examples:

  • count exceptions by category
  • summarize balances by account type
  • compare totals by vendor
  • review distribution of scores or ratings

Good fit vs poor fit​

Good fit​

Use Statistics when the goal can be described as:

  • "Calculate summary metrics for these fields."
  • "Show totals or counts by these groups."
  • "Help me understand whether these values look reasonable."

Poor fit​

Statistics is probably not the first Tool to use when:

  • values need cleaning or standardization first
  • duplicate records could distort the summary
  • files need to be joined before the needed fields are together
  • Records need to be split or filtered before the summary scope is correct

Ask this before you start​

Finish this sentence:

"I need to summarize ..."

If you can name the fields, measures, and groups clearly, Statistics is often a good fit.

If the summary scope is unclear, define the business question before building the configuration.

Start with the question​

Before choosing measures, decide what the summary should help answer.

Ask:

  • Which numeric fields matter?
  • Do results need to be grouped?
  • Are blanks or zeros meaningful?
  • Are outliers expected or suspicious?
  • What result would be surprising enough to investigate?

Rule-of-thumb decision guide​

Use Statistics when the central task is summarizing values.

Use another Tool first when the central task is cleaning, deduplicating, joining, filtering, or splitting the underlying Records.