# How to show the aggregation result in kibana?
**URL:** https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236
**Category:** Kibana
**Created:** [March 21, 2019, 12:48am UTC](https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236 "2019-03-21T00:48:41Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Sky\_Iprd](https://discuss.elastic.co/u/Sky_Iprd)
#### Post date: [March 21, 2019, 12:48am UTC](https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236/1 "2019-03-21T00:48:41Z")
Hi , i have follow script do aggregation of the production year revenue. However, I dunno how can I use the visualization to present the result. Please help or point me some direction please and thanks.
> POST elk\_all/sales\_daily
> {
> "code": 2,
> "name": "RedTB",
> "year": 2018,
> "sales": 1000
> }
> POST elk\_all/sales\_daily
> {
> "code": 1,
> "name": "BlueTB",
> "year": 2018,
> "sales": 1000
> }
> POST elk\_all/sales\_daily
> {
> "code": 2,
> "name": "RedTB",
> "year": 2017,
> "sales": 600
> }
> POST elk\_all/sales\_daily
> {
> "code": 1,
> "name": "BlueTB",
> "year": 2017,
> "sales": 920
> }
> POST elk\_all/sales\_daily
> {
> "code": 2,
> "name": "RedTB",
> "year": 2016,
> "sales": 800
> }
> POST elk\_all/sales\_daily
> {
> "code": 1,
> "name": "BlueTB",
> "year": 2016,
> "sales": 900
> }
> GET elk\_all/\_search
> {
> "size": 0,
> "query": {
> "bool": {
> "must": {
> "range": {
> "year": {
> "gte": "2016",
> "lte": "2018"
> }
> }
> }
> }
> },
> "aggs": {
> "group\_by\_code": {
> "terms": {
> "field": "code"
> },
> "aggs": {
> "first\_sale": {
> "filter": {
> "term": {
> "year": "2016"
> }
> },
> "aggs": {
> "sales\_value": {
> "max": {
> "field": "sales"
> }
> }
> }
> },
> "mid\_sale": {
> "filter": {
> "term": {
> "year": "2017"
> }
> },
> "aggs": {
> "sales\_value": {
> "max": {
> "field": "sales"
> }
> }
> }
> },
> "last\_sale": {
> "filter": {
> "term": {
> "year": "2018"
> }
> },
> "aggs": {
> "sales\_value": {
> "max": {
> "field": "sales"
> }
> }
> }
> },
> "filter\_positive": {
> "bucket\_selector": {
> "buckets\_path": {
> "first": "first\_sale\>sales\_value",
> "mid": "mid\_sale\>sales\_value",
> "last": "last\_sale\>sales\_value"
> },
> "script": "params.last \> params.mid && params.mid \< params.first"
> }
> }
> }
> }
> }
> }
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [March 22, 2019, 11:52am UTC](https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236/2 "2019-03-22T11:52:50Z")
For start, create a line chart with a SUM metric (anything actually if you're showing them by year), a terms aggregation on the `year` field or a histogram one, depending on what you want to do with it.
And if you want show them for RedTB and BlueTB separately, just click on Split Chart and then select either a terms aggregation on the name or a filter aggregation with the name as terms.
---
### Author:  [@Sky\_Iprd](https://discuss.elastic.co/u/Sky_Iprd)
#### Post date: [March 24, 2019, 8:42am UTC](https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236/3 "2019-03-24T08:42:38Z")
Thanks for guiding me. The line chart contains both product now. However, I try to put my aggregation script in the filter DSL it's doesn't help me to filter out the product ( code:1 ) I don't want to show in graph because code 1 is not match in my scenario. Am I missing something ?
The script work well in the dev tools ...
---
### Author:  [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [March 25, 2019, 12:31pm UTC](https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236/4 "2019-03-25T12:31:34Z")
Can you show me a screenshot of your chart and the options that you set? It would be easier to troubleshoot that way.
---
### Author:  [@Sky\_Iprd](https://discuss.elastic.co/u/Sky_Iprd)
#### Post date: [March 26, 2019, 12:41pm UTC](https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236/5 "2019-03-26T12:41:34Z")
Yes, here it is. Thanks..
1st jpg is the line chart output
2nd Y-Axis Metric
3rd X-Axis Metric
4th The result come from the aggregation script query I post in previous thread
Thanks in advance
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 23, 2019, 12:41pm UTC](https://discuss.elastic.co/t/how-to-show-the-aggregation-result-in-kibana/173236/6 "2019-04-23T12:41:37Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.