# cfxdm - dm:describe

**dm:describe:** This cfxdm tag allows the user to select one or more columns and provides below summarized statistics on the values within them.

* **count:** Total count of the values within a column
* **unique:** Total unique count of the values within a column
* **top:** The top value out of all unique values which is repeated compared to others
* **freq:** The number of times the top unique is repeated
* **mean:** The mean out of all of the values (applies to rows that only has numeric values)
* **std:** The standard deviation out of all of the values (applies to rows that only has numeric values)
* **min:** The minimum value out of all of the values (applies to rows that only has numeric values)
* **25%:** 25% percentile out of all of the values (applies to rows that only has numeric values)
* **50%:** 50% percentile out of all of the values (applies to rows that only has numeric values)
* **75%:** 75% percentile out of all of the values (applies to rows that only has numeric values)
* **max:** The maximum value out of all of the values (applies to rows that only has numeric values)

**dm:describe** syntax**:** 

* **columns (**optional**)**. Specify a column or columns (comma separated) on which '**describe**' to be applied.

In the below example, for a reference, we are going to use **VMware vROps** as an extension to query the data and ingest it into **dm:selectcolumns** to select specific columns using include/exclude or both together.

Enter the below command to select **VMware vROps Alerts tag (@vrops:alerts**). (In this example, vrops name is used as a label to identify VMware vROps extension and it's tags. The label is defined while adding the extension in cfxdx configuration file or through UI)

```
tag @vrops:alerts
```

![](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MVi1J-o3X92eod9Zbws%2F-MVi2SEZYVnklETBKvgq%2FScreen%20Shot%202021-03-13%20at%204.05.37%20PM.png?alt=media\&token=5e00c0a0-f9d3-4172-bcc2-191702893ac6)

**Example 1:** Show describe statistics on all of the columns from the selected tag.

Get the data from VMware vROps Alerts tag (**@vrops:alerts**) and ingest the data into the **dm:describe** tag to see the statistics. (above mentioned in this document). Below are the columns from the **vrops:alerts** extension tag**.**

* alertDefinitionId
* alertDefinitionName
* alertId
* alertImpact
* alertLevel
* cancelTimeUTC
* controlState
* links
* resourceId
* startTimeUTC
* status
* subType
* suspendUntilTimeUTC
* type
* updateTimeUTC

```
data --> dm:describe
```

![](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MVisQShl118AnjWZC2n%2F-MViuIBUmtQtq4C8FXB8%2FScreen%20Shot%202021-03-13%20at%208.05.25%20PM.png?alt=media\&token=1b1da09a-d951-483e-b920-8fa4316eadca)

**Example 2:** Show describe statistics on selective columns from the selected tag.

Get the data from VMware vROps Alerts tag (**@vrops:alerts**) and ingest the data into the **dm:describe** tag to see the statistics on the below selected columns. (above mentioned in this document)

* alertDefinitionName
* startTimeUTC

```
data --> dm:describe columns = 'alertDefinitionName,startTimeUTC'
```

![](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-MVj-Yin6-yXk2CvaMoF%2F-MVj03Ku-llBEKPePVDI%2FScreen%20Shot%202021-03-13%20at%208.34.29%20PM.png?alt=media\&token=c5bde9b4-6d5c-44b9-a3fa-8e90ab9758d9)