# VariableStatistics ## Get definition ```javascript { "kind": "variableStatistics", "uri": string, "url": string, "variable": { "kind": variable, "name": str, "type": str (enum variable_type) }, "status": string("queued","running","completed","failed"), "count": integer, "numDistinct": integer, "min": number, "max": number, "mean": number, "approxMedian": number, "frequencyDistribution": null | [ { value: number | string | boolean, count: number, label: string | null } ], "geoCentroid": { "longitude": number, "latitude" number }, "geoBBox": { "westLongitude": number, "eastLongitude": number, "northLatitude": number, "southLatitude": number } } ``` ## Documentation | Fields | | | | | ---------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | -------------------------------------------------------------------------------------- | | **Get** | | | | | kind |

string

The resource type. Will always be "variable".

| | | | uri |

The fully qualified reference to these statistics, for use in generating calls to this API.

For example, /tables/demo.example:123.test:456/variables/var1/statistics

| | | | url |

string
The variable's discoverable url through a web browser interface, which also displays the variable's statistics.

| | | | variable |

object
The corresponding variable for the statistics, with properties corresponding to the variable.base definition.

Useful for accessing the variable type when parsing statistic values.

| | | | status |

string

The current status of the statistic's computation. Will be one of completed, running, queued, or failed. If the statistic is failed, it can only be recomputed in the UI.

Other statistic fields will only be populated once status == "completed"

| | | | count |

integer

The number of non-null values for this variable.

| | | | numDistinct |

integer

The number of distinct values for this variable.

| | | | min |

number

The minimum value of this variable.

Will be null for variables of boolean type.

If the variable is of type date or dateTime, this number represents the number of milliseconds since the epoch (1970-01-01). If the variable is of type time, this number represents the number of milliseconds since 00:00:00.

If the variable is of type string, will be the minimum string length.

If the variable is of type geography, will be the minimum number of vertices encountered.

| | | | max |

number

The maximum value of this variable.

See statistic.min for information about different variable types.

| | | | mean |

number

The average value of this variable.

See statistic.min for information about different variable types.

| | | | approxMedian |

number

The approximate median of this variable. Uses the BigQuery APPROX\_QUANTILES function.

See statistic.min for information about different variable types.

| | | | stdDev |

number

The sample (unbiased) standard deviation of this variable.

Will be null for variables of string and boolean type. For all other variable types this will be a number.

If the variable is of type date , time, or dateTime, this number measures the standard deviation in milliseconds.

| | | | frequencyDistribution\[] |

object
The frequencyDistribution, if present, is an array of values observed and their respective counts.

Note that frequency distribution may not always be present (e.g., for variables with high heterogeneity of values), and is limited to the 10,000 most common values – meaning that it may only represent a subset of values on the variable.

| | | | frequencyDistribution.value |

number | string | boolean
The observed value. Type will correspond to the variable type.

| | frequencyDistribution.count |

number
The count of observations that match this value

| | | | frequencyDistribution.label |

string
Included if the variable has specified valueLabels in its metadata, and there is a corresponding label for this value.

| | | | geoCentroid |

object
An object containing longitude and latitude properties, representing the weighted centroid of all geometries.

| | | | geoBBox |

object
An object describing the geographic bounding box of the variable. Will only be present for variables of "geography" type.

| | | |

geoBBox
.westLongitude
.eastLongitude
.northLatitude
.southLatitude

|

number
Each property represents one side of the bounding box, expressed in numeric degrees.

| | | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.redivis.com/api/resource-definitions/variablestatistics.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.