# Kibana JSON input to exclude data in one chart
**URL:** https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800
**Category:** Kibana
**Created:** [April 28, 2019, 1:27pm UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800 "2019-04-28T13:27:24Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@landy](https://discuss.elastic.co/u/landy)
#### Post date: [April 28, 2019, 1:27pm UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/1 "2019-04-28T13:27:24Z")
Hello!
I am using ES, Kibana version - 6.6.1
I want to exclude 'Men's clothing' & 'Women's clothing' data in the attached chart. Is it possible to use JSON input to realize this? Is there any way to exclude certain data in one chart? In other words, is there any way to use part of datasets to create charts?
(I don't want to use filter bar because it will filter data for all charts)
Many thanks!
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [April 29, 2019, 4:29am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/2 "2019-04-29T04:29:20Z")
You can crease a saved search which includes the filters you want to add and then base the visualization on this. This allows you to apply filtering to just some visualizations in a dashboard.
---
### Author:  [@landy](https://discuss.elastic.co/u/landy)
#### Post date: [April 29, 2019, 7:12am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/3 "2019-04-29T07:12:17Z")
Thanks for your reply! What does 'seven search' mean? Do you mean 'save search'?
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [April 29, 2019, 7:17am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/4 "2019-04-29T07:17:45Z")
Spellcheckers.... I meant "saved search". 🙂
---
### Author:  [@landy](https://discuss.elastic.co/u/landy)
#### Post date: [April 29, 2019, 9:57pm UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/5 "2019-04-29T21:57:54Z")
"Saved Search" looks nice. I found 'Open' button above toolbar in 'Discover'. But i can't find it in 'Visualization' and 'Dashboard'. Could you tell me how to use 'Saved Search' in 'Visualization'?
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [April 30, 2019, 5:12am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/6 "2019-04-30T05:12:20Z")
In the Discover view you add the filters you want and then store it as a saved search. When you create the visualisation you then choose this saved search instead of an index pattern when specifying what it is based on.
---
### Author:  [@landy](https://discuss.elastic.co/u/landy)
#### Post date: [April 30, 2019, 7:26am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/7 "2019-04-30T07:26:01Z")
Sorry for my unclear description. I saved 'saved search' in Discover view and I can find it in 'Management-\>Settings'. Could you tell me how to 'choose this saved search' in visualisation? Because I didn't find open button above toolbar in visualization.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [April 30, 2019, 7:31am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/8 "2019-04-30T07:31:38Z")
It is the first step when you create a new visualisation. Select the saved search instead of an index pattern. I do not think you can change an existing visualisation.
---
### Author:  [@landy](https://discuss.elastic.co/u/landy)
#### Post date: [April 30, 2019, 7:45am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/9 "2019-04-30T07:45:48Z")
Found it. Thanks a lot!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 28, 2019, 7:45am UTC](https://discuss.elastic.co/t/kibana-json-input-to-exclude-data-in-one-chart/178800/10 "2019-05-28T07:45:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.