# Json input
**URL:** https://discuss.elastic.co/t/json-input/77389
**Category:** Kibana
**Created:** [March 4, 2017, 4:38pm UTC](https://discuss.elastic.co/t/json-input/77389 "2017-03-04T16:38:33Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@avivc](https://discuss.elastic.co/u/avivc)
#### Post date: [March 4, 2017, 4:38pm UTC](https://discuss.elastic.co/t/json-input/77389/1 "2017-03-04T16:38:33Z")
Hi,
I have a field from type float in my document. I want to filter in my aggregation data using json input.
when running `GET my_index/ _search`, I'm getting this:
> "kpi": {
> "mappings": {
> "Defect": {
> "PlanEstimate": {
> "full\_name": "PlanEstimate",
> "mapping": {
> "PlanEstimate": {
> "type": "float"
> }
> }
> }
> },
> "HierarchicalRequirement": {
> "PlanEstimate": {
> "full\_name": "PlanEstimate",
> "mapping": {
> "PlanEstimate": {
> "type": "float"
> }
> }
> }
> }
> }
> }
> }
I've tried to create the next json input query, both in my viz and in script field:
> "query": {"script": {"script": "doc['PlanEstimate'].value"}}}
I read all the tutorial that ES has to offer ([Painless](https://www.elastic.co/guide/en/elasticsearch/reference/5.2/modules-scripting-painless.html#_accessing_doc_values_from_painless), [Script field](https://www.elastic.co/guide/en/elasticsearch/reference/5.2/search-request-script-fields.html#search-request-script-fields), [How to use script](https://www.elastic.co/guide/en/elasticsearch/reference/5.2/modules-scripting-using.html#modules-scripting-using), [Metric](https://www.elastic.co/guide/en/kibana/current/metric-chart.html)) but I can't filter what I wish in my viz/ dashboard.
**BTW - running this query in dev tool return data**
Any idea ?
Tnx
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 1, 2017, 4:38pm UTC](https://discuss.elastic.co/t/json-input/77389/2 "2017-04-01T16:38:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.