# Data table visualization - display other value then matric value
**URL:** https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465
**Category:** Kibana
**Created:** [June 19, 2018, 10:24am UTC](https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465 "2018-06-19T10:24:27Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Shneor\_Asa](https://discuss.elastic.co/u/Shneor_Asa)
#### Post date: [June 19, 2018, 10:24am UTC](https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465/1 "2018-06-19T10:24:27Z")
Hi,
I have a question, how can i display some value on data table visualization based on other field matric?
For example I have Max matric on 'date' field
But i want to display some other value from the Document returned by metric.
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [June 19, 2018, 2:30pm UTC](https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465/2 "2018-06-19T14:30:33Z")
Hi,
I am not sure I understand your question? But this is an example of how you can use the data table visualization.
I am doing a max(metric aggregation) on bytes and splitting it over buckets of terms.
This is our documentation on data table aggregation: [https://www.elastic.co/guide/en/kibana/6.2/data-table.html](https://www.elastic.co/guide/en/kibana/6.2/data-table.html)
Also this video explains how Kibana uses ES aggregations: [https://www.youtube.com/watch?v=j-eCKDhj-Os](https://www.youtube.com/watch?v=j-eCKDhj-Os)
Let me know if this helps?
Thanks,
Bhavya
---
### Author:  [@Shneor\_Asa](https://discuss.elastic.co/u/Shneor_Asa)
#### Post date: [June 19, 2018, 2:57pm UTC](https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465/3 "2018-06-19T14:57:23Z")
Hi
let me rephrase...
lets say i have metric aggregation by Max on timestamp.
and i also have bucket aggregation by terms of some string field
So now i have a table of data which every row is group of documents that show the Max value of timestamp. am i right?
my question is, there is a way to get the specific document that hold the max value of timestamp within the group?
because i want display some other field's value in the specific document that have the Max value of 'timestamp' key.
right now i don't know how, because buckets are groups of documents, and I need a single one. the one who have the Max value of 'timestamp' in the bucket.
i hope this is more clearer.
thanks!
---
### Author:  [@Shneor\_Asa](https://discuss.elastic.co/u/Shneor_Asa)
#### Post date: [June 24, 2018, 1:39pm UTC](https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465/4 "2018-06-24T13:39:28Z")
any idea?
---
### Author:  [@Shneor\_Asa](https://discuss.elastic.co/u/Shneor_Asa)
#### Post date: [June 25, 2018, 9:11am UTC](https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465/5 "2018-06-25T09:11:14Z")
I know how to do it by query,
POST automationmonitoring/\_doc/\_search
{
"size": 0,
"aggs": {
"by\_district": {
"terms": {
"field": "description.keyword",
"size": 50
},
"aggs": {
"max\_date": {
"max": {
"field": "timestamp"
}
},
"include\_source": {
"top\_hits": {
"size": 1,
"\_source": {
"includes": [
"successrate"
]
}
}
}
}
}
}
}
So, all i need now is to figure out how to do that on dashboard visualization.
Any suggestions?
thanks.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 23, 2018, 9:11am UTC](https://discuss.elastic.co/t/data-table-visualization-display-other-value-then-matric-value/136465/6 "2018-07-23T09:11:15Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.