# Exclude by other field **URL:** \ **Category:** Kibana\ **Created:** [November 28, 2018, 8:04am UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494 "2018-11-28T08:04:29Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![ilanas](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@ilanas](https://discuss.elastic.co/u/ilanas)\ **Post date:** [November 28, 2018, 8:04am UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/1 "2018-11-28T08:04:29Z")
Hello, i have one question. I have a register for example like this: DEPARTMENT YEAR RECORDABLE PEOPLE AAAA 2015 YES 7 BBBB 2016 NO 15 AAAA 2015 NO 7 ccccc 2016 YES 10 I want to do a chart where the agregation field is the sum of people, x-axis is the year and i want split series by department. Now the question, can i exclude in the split series the field No of recordable? in this example only i want to plot the first department AAAA and the ccccc department. In the dashboard i cant insert a filter of recordable ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [November 28, 2018, 2:45pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/2 "2018-11-28T14:45:31Z")
Hey @ilanas, the Dashboard application can add filters for any fields that are defined in your index-pattern. Would you mind elaborating upon "I can't insert a filter of recordable"? Have you tried refreshing your index-pattern by going to Management -\> Index Patterns, selecting the appropriate index pattern, and then clicking the 'refresh' button highlighted below: ![09%20AM](https://us1.discourse-cdn.com/elastic/original/3X/4/9/49579b4ca1dac3d63f4a6c8a5cd01b904110ac38.png) ---
**Author:** ![ilanas](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@ilanas](https://discuss.elastic.co/u/ilanas)\ **Post date:** [November 28, 2018, 2:55pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/3 "2018-11-28T14:55:59Z")
When I say that I can not create a filter with recordable is not because the tool does not leave me, but because I want to have two graphics in a dashboard in one graphic when I filter by aaaa that shows me all data and in the other only those that are recordable yes. That's why I want to exclude in a graph the series of departments that recordable is no. ---
**Author:** ![ilanas](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@ilanas](https://discuss.elastic.co/u/ilanas)\ **Post date:** [November 28, 2018, 2:56pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/4 "2018-11-28T14:56:33Z")
Now do you understand me? Thank you ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [November 28, 2018, 2:58pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/5 "2018-11-28T14:58:24Z")
Hey @ilanas, I'm with you now. If you edit the visualization itself, you can add a filter to the visualization which will apply only to that visualization, instead of the whole Dashboard. ---
**Author:** ![ilanas](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@ilanas](https://discuss.elastic.co/u/ilanas)\ **Post date:** [November 28, 2018, 2:59pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/6 "2018-11-28T14:59:29Z")
Thanks, i try it ---
**Author:** ![ilanas](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@ilanas](https://discuss.elastic.co/u/ilanas)\ **Post date:** [November 28, 2018, 3:17pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/7 "2018-11-28T15:17:16Z")
trying it i show a problem, if is any department only have no in recordable field, in the first chart is ok but in the second appears not result found. So this not work fine to me. is there any option to exclude in the second chart any option of the filter? for example if i don't plot the department aaaa but if i filter by aaaa the second chart doesn't change? ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [November 28, 2018, 3:18pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/8 "2018-11-28T15:18:59Z")
Hey @ilanas, would you mind posting a screenshot to illustrate what you're seeing? ---
**Author:** ![ilanas](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@ilanas](https://discuss.elastic.co/u/ilanas)\ **Post date:** [November 28, 2018, 3:27pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/9 "2018-11-28T15:27:00Z")
Sorry but i can't post any real data here. I will try to say it clearly the objective that I have in case you can find me a solution. I have created a sql that collects my data. there appears data of department, year, group, and people. then I make a union with 'All'. In this way, in the first graph where x is year, the aggregate is the sum of the person and I make a split by department, all departments with their respective people are shown per year. to this the department is added all to compare. In a second graphic it is the same but instead of split series by department it is by group. In this case, if I do not filter for anything, the data of each group is duplicated because the corresponding amount of the all is added to the sum. I want to be able to tell you in some way that I exclude the all in the second graph but that if I filter by all in the control I do not leave it result no found ---
**Author:** ![ilanas](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@ilanas](https://discuss.elastic.co/u/ilanas)\ **Post date:** [November 28, 2018, 3:27pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/10 "2018-11-28T15:27:17Z")
now? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 26, 2018, 3:27pm UTC](https://discuss.elastic.co/t/exclude-by-other-field/158494/11 "2018-12-26T15:27:26Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.