# Creating a visualization from a script query
**URL:** https://discuss.elastic.co/t/creating-a-visualization-from-a-script-query/94899
**Category:** Kibana
**Created:** [July 28, 2017, 5:13am UTC](https://discuss.elastic.co/t/creating-a-visualization-from-a-script-query/94899 "2017-07-28T05:13:34Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Nikhil\_Utane](https://discuss.elastic.co/u/Nikhil_Utane)
#### Post date: [July 28, 2017, 5:13am UTC](https://discuss.elastic.co/t/creating-a-visualization-from-a-script-query/94899/1 "2017-07-28T05:13:34Z")
I need to create visualizations after doing some math on the indexed data.
I went through this: [https://www.elastic.co/guide/en/elasticsearch/painless/5.5/painless-examples.html](https://www.elastic.co/guide/en/elasticsearch/painless/5.5/painless-examples.html)
where it shows the usage using REST APIs.
Now I want to do the same using Kibana.
If we take the same example, how can I generate a bar chart where I can see the player name on X-axis and total number of goals scored on the Y axis?
Thanks.
---
### Author:  [@Nikhil\_Utane](https://discuss.elastic.co/u/Nikhil_Utane)
#### Post date: [July 28, 2017, 5:21am UTC](https://discuss.elastic.co/t/creating-a-visualization-from-a-script-query/94899/2 "2017-07-28T05:21:26Z")
Ohh. Actually i was using the wrong Aggregation for X-axis due to which I wasn't getting the option to 'run' the visualization.
With this configuration I was able to generate the chart.
Y-axis: Aggregation: Max, Field: Goals.
JSON Input:
{
"script": {
"lang": "painless",
"inline": "int total = 0; for (int i = 0; i \< doc['goals'].length; ++i) { total += doc['goals'][i]; } return total;"
}
}
X-axis: Aggregation Terms, Field: first.keyword
---
### Author:  [@pjanzen](https://discuss.elastic.co/u/pjanzen)
#### Post date: [July 28, 2017, 5:21am UTC](https://discuss.elastic.co/t/creating-a-visualization-from-a-script-query/94899/3 "2017-07-28T05:21:57Z")
I would try (I am using ELK5.4)
Create a query where you select those event you need. Then visualisations -\> vertical bar
Change the Y-Xasis to Sum() and select the field that hold the goals for the users. Select bucket type X-Axsis -\> term aggr and select the users name.
Paul.
---
### Author:  [@Nikhil\_Utane](https://discuss.elastic.co/u/Nikhil_Utane)
#### Post date: [July 28, 2017, 6:16am UTC](https://discuss.elastic.co/t/creating-a-visualization-from-a-script-query/94899/4 "2017-07-28T06:16:06Z")
Yes, this works too and is the proper way for such a query. Thanks.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 25, 2017, 6:16am UTC](https://discuss.elastic.co/t/creating-a-visualization-from-a-script-query/94899/5 "2017-08-25T06:16:07Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.