---
title: "Functional Overview"
slug: "functional-overview-3"
updated: 2022-09-01T15:12:43Z
published: 2022-09-01T15:12:43Z
canonical: "docs.datajet.app/functional-overview-3"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Profile - Measure

## Measure

The measure refers to *what is being calculated* and is analogous to the value option in an excel pivot table.

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/ProfileMeasure(1).PNG)

By default, the measure box will be empty, and so what will be calculated is the count of records on the table that provides the dimensions.

## Types of measure

In general, numeric fields are added as measures – this is because various mathematical functions can be applied to measures - for example, Sum, Min, Max, Avg, StDev. A measure can be discrete or continuous (i.e., there is no limit on the number of discrete values in the field).

Adding a field of a *non-numeric data-type* will mean that there are some limitations on the calculations that can be performed. Non-numeric measure fields are not supported when calculating crosstabs, and only the COUNT function is supported for single and multi-dimensional profiles.

Date and DateTime fields are treated as numeric fields when added as measures.

## Functions

The function determines the type of calculation that is performed.

By default, the function is COUNT, which means what is counted are either the non-null records in the table (when there is no measure) or the number of *non-null records* for the provided measure.

Other statistical functions can be applied to numeric dimensions or measures:

| Count | Returns the count of the set of records |
| --- | --- |
| Sum | Sums the measures for the set of records |
| Min | Returns the minimum measure value for the set of records |
| Max | Returns the maximum measure value for the set of records |
| Avg | Returns the measure sum/count for the set of records |
| StDev | Returns the dispersion of data relative to the Avg for the set of records |