# Add statistical mode and median
**URL:** https://discuss.elastic.co/t/add-statistical-mode-and-median/13328
**Category:** Elasticsearch
**Created:** [August 26, 2013, 3:07pm UTC](https://discuss.elastic.co/t/add-statistical-mode-and-median/13328 "2013-08-26T15:07:11Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@sakuragi](https://discuss.elastic.co/u/sakuragi)
#### Post date: [August 26, 2013, 3:07pm UTC](https://discuss.elastic.co/t/add-statistical-mode-and-median/13328/1 "2013-08-26T15:07:11Z")
Hi! I'm using elasticsearch with a big dataset (over 17000000 row in a mysql database) and I have to find the median value and the mode on a specific field. I've watched the facets and the sort but it's not useful for me. With the sort I've to return all the values and it is very slow, in the statistical facets there aren't the median and the mode. Sorry for my bad english, thank u all!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:19am UTC](https://discuss.elastic.co/t/add-statistical-mode-and-median/13328/2 "2017-07-06T02:19:47Z")