---
schema_version: "1"
id: ac75f496fadd202aa3da47fa5a394264dd0ec841f1da1c162e1f61ae97773157
title: median()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-fn-agg-med.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-med.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: cf2a46b7c5c3d96b0c9ca5b85419bc9eb69738d5fa09b99927e63cd22ece6bc4
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# median()

Returns the median value of a measure field.

## Example - Find the Median Time to Close a Case

Use `median()` to find the median amount of time it takes to resolve a case, grouped by company.

```nolang
q = load "Case";
q = group q by 'Account_Name';
q = foreach q generate 'Account_Name' as 'Account_Name', median('CallDuration') as 'median_CallDuration';
q = order q by 'Account_Name' asc;
```

**See Also**

- [avg() or average()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-avg.md)