# Advanced JSON input
**URL:** https://discuss.elastic.co/t/advanced-json-input/322366
**Category:** Kibana
**Created:** [January 3, 2023, 11:52am UTC](https://discuss.elastic.co/t/advanced-json-input/322366 "2023-01-03T11:52:29Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@imsudo](https://discuss.elastic.co/u/imsudo)
#### Post date: [January 3, 2023, 11:52am UTC](https://discuss.elastic.co/t/advanced-json-input/322366/1 "2023-01-03T11:52:29Z")
I have a data table with data, Metrics, aggregation as count. ( as it shows all the log count)
see attached image(if avl)
i wish to get only the count of 5xx errors (500-599) in downstreamStatus data field using advanced json input field.
i have downstreamStatus as data field in filter field, but do not wish to apply that in "add filter" section.
is this achievable using advanced JSON input field ?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [January 3, 2023, 11:25pm UTC](https://discuss.elastic.co/t/advanced-json-input/322366/2 "2023-01-03T23:25:58Z")
Hi @imsudo Welcome to the community!
What version of the Stack...
Lens you can put the KQL filter in the aggregation formulas.
In general if you are on a newer version you should start with Lens
Or using the legacy Table you can base the viz on a saved search
---
### Author:  [@imsudo](https://discuss.elastic.co/u/imsudo)
#### Post date: [January 11, 2023, 1:17pm UTC](https://discuss.elastic.co/t/advanced-json-input/322366/3 "2023-01-11T13:17:38Z")
hi @stephenb
It's v 7.7.0
so how can i base the viz on saved search.. ?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [January 11, 2023, 2:42pm UTC](https://discuss.elastic.co/t/advanced-json-input/322366/4 "2023-01-11T14:42:30Z")
Go to Discover
set the index pattern
Set the filters
Save
Then use that saved search when creating the visualization.
BTW 7.7 is incredibly old and you should upgrade as soon as possible.
---
### Author:  [@imsudo](https://discuss.elastic.co/u/imsudo)
#### Post date: [January 18, 2023, 7:26pm UTC](https://discuss.elastic.co/t/advanced-json-input/322366/5 "2023-01-18T19:26:20Z")
i did google version 7.7.0 is on 13th May 2020...
i tried but in Visualization - new Visualization - data table - choose source and .......... same place.. no option to use the saved one
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [January 19, 2023, 2:08am UTC](https://discuss.elastic.co/t/advanced-json-input/322366/6 "2023-01-19T02:08:05Z")
> [@imsudo](#):
>
> i did google version 7.7.0 is on 13th May 2020...
Yes, that is nearly 3 Years old and over 15+ Significant Releases behind... just a suggestion.
Hmmm Right Here in the 7.7 [Docs](https://www.elastic.co/guide/en/kibana/7.7/most-frequent.html)
> The most frequently used visualizations allow you to plot aggregated data from a \>\>[saved search](https://www.elastic.co/guide/en/kibana/7.7/save-open-search.html)\<\< or [index pattern](https://www.elastic.co/guide/en/kibana/7.7/index-patterns.html).
>
> The most frequently used visualizations include:
>
> - Line, area, and bar charts
> - Pie chart
> - Data table
> - Metric, goal, and gauge
> - Tag cloud
So here is my 7.7 works fine
Discover
Data Table
Pick the Saved Search
Build Table off Saved Search
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 16, 2023, 2:08am UTC](https://discuss.elastic.co/t/advanced-json-input/322366/7 "2023-02-16T02:08:21Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.