# Scripted fields in vega visualization - Getting Bad request as error
**URL:** https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395
**Category:** Kibana
**Created:** [November 5, 2020, 11:54am UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395 "2020-11-05T11:54:01Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Pranusha119](https://discuss.elastic.co/u/Pranusha119)
#### Post date: [November 5, 2020, 11:54am UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/1 "2020-11-05T11:54:01Z")
```auto
{
$schema: "https://vega.github.io/schema/vega-lite/v2.json"
data: {
url: {
%context%: true
index: index_ssd_2
body: {
size: 10000,
_source: ["mediatype","pred_comp_sem","Gender","PhotoOfPerson"],
script_fields : {
photo : {
script : {
lang: 'painless',
source: (doc['PhotoOfPerson'].value) / 2
}
}
}
}
}
format: { property: "hits.hits" }
},
"transform": [
{
"joinaggregate": [{
"op": "sum",
"field": "fields.photo",
"as": "a_pop"
}]
}
],
"mark": {
"type": "text",
"fontSize": 32,
"align":"center",
"dx": -240,
"dy": 12
},
"encoding": {
"text": {"field": "a_pop", "type": "quantitative"}
}
}
```
In vega visualzation I tried to create a scripted field....it's showing bad request as error, may I know where exactly I went wrong
---
### Author:  [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)
#### Post date: [November 5, 2020, 1:54pm UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/2 "2020-11-05T13:54:13Z")
Is `PhotoOfPerson` a number?
Open up developer tools in your browser (usually F12) and go to the Network tab. Update your Vega visualization and click the Update button to trigger a new request. Look for `es` in red if it failed and click the response tab like I've shown below. That is the full error that could help determine what is going on.
But syntax wise it looks good besides wondering if `PhotoOfPerson` is a mapped and stored as a number in order to do some math on it.
---
### Author:  [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)
#### Post date: [November 5, 2020, 1:56pm UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/3 "2020-11-05T13:56:17Z")
Also you can go to Dev Tools and run the below and see if it works or gives an error also.
```auto
GET index_ssd_2/_search
{
"query": {
"match_all": {}
},
"script_fields": {
"photo": {
"script": {
"lang": "painless",
"source": "doc['PhotoOfPerson'].value * 2"
}
}
}
}
```
---
### Author:  [@Pranusha119](https://discuss.elastic.co/u/Pranusha119)
#### Post date: [November 5, 2020, 2:46pm UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/4 "2020-11-05T14:46:54Z")
I tried the query in dev tools, the error was regarding not filtering out null values.
This is the new query
```auto
{
$schema: "https://vega.github.io/schema/vega-lite/v2.json"
data: {
url: {
%context%: true
index: index_ssd_2
body: {
size: 10000,
_source: ["mediatype","pred_comp_sem","Gender","PhotoOfPerson"],
script_fields : {
photo : {
script : {
lang: 'painless',
source: if(doc['PhotoOfPerson'].size() != 0){return doc['PhotoOfPerson'].value/1} else{return 0}
}
}
}
}
format: { property: "hits.hits" }
},
"transform": [
{
"joinaggregate": [{
"op": "sum",
"field": "fields.photo",
"as": "a_pop"
}]
},
{
"joinaggregate": [{
"op": "sum",
"field": "_source.PhotoOfPerson",
"as": "a_p"
}]
}
],
"mark": {
"type": "text",
"fontSize": 32,
"align":"center",
"dx": -240,
"dy": 12
},
"encoding": {
"text": {"field": "a_pop", "type": "quantitative"}
}
}
}
```
Here, I filtered out null values, its not showing any error in dev tools. But its showing Invalid specification Vega visualization
---
### Author:  [@Pranusha119](https://discuss.elastic.co/u/Pranusha119)
#### Post date: [November 16, 2020, 5:42pm UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/5 "2020-11-16T17:42:32Z")
Any thoughts on this @aaron-nimocks
---
### Author:  [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)
#### Post date: [November 16, 2020, 6:26pm UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/6 "2020-11-16T18:26:21Z")
I don't use vega-lite so not as familiar with it. But the error does not recognize the `mark` element so something is off with your formatting.
---
### Author:  [@Pranusha119](https://discuss.elastic.co/u/Pranusha119)
#### Post date: [November 16, 2020, 6:29pm UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/7 "2020-11-16T18:29:47Z")
Okay, thanks @aaron-nimocks
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 14, 2020, 6:29pm UTC](https://discuss.elastic.co/t/scripted-fields-in-vega-visualization-getting-bad-request-as-error/254395/8 "2020-12-14T18:29:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.