# Dataview with some columns excluded
**URL:** https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942
**Category:** Kibana
**Created:** [March 30, 2023, 1:07pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942 "2023-03-30T13:07:44Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@joerg55](https://discuss.elastic.co/u/joerg55)
#### Post date: [March 30, 2023, 1:07pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/1 "2023-03-30T13:07:44Z")
Hi community,
I want to create a data view of an index without some columns. The background is that these columns lead to the display of 'no results' with certain filters. I only have this one index and I don't have the option to change it to or create a new one.
How can I get such a 'reduced' dataview?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [March 30, 2023, 1:53pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/2 "2023-03-30T13:53:30Z")
Hi @joerg55
Deleting or removing fields in a data view is not supported they are dynamically created.
My question is what visualization are you using? Typically you can remove fields from tables or discover etc. And only show the fields you want.
Can you show us what you're trying to do? And Perhaps we can help.
---
### Author:  [@joerg55](https://discuss.elastic.co/u/joerg55)
#### Post date: [March 30, 2023, 2:39pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/3 "2023-03-30T14:39:40Z")
hi @stephenb,
that's really difficult for me to explain. I have 2 dashboards with charts which have all the same index. One drilldown of dashboard 1 leads to dashboard 2. Now in dashboard 2 some charts show 'no result' because of the filter set by the drilldown. But these charts dont't need the filtered column. That's why I want to get a dataview without these columns.
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [March 30, 2023, 2:45pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/4 "2023-03-30T14:45:12Z")
> [@joerg55](#):
>
> But these charts dont't need the filtered column. That's why I want to get a dataview without these columns.
Yes apologies I don't understand Exactly Which Visualization... I do not believe Kibana has visualizations with Dynamic Columns... you pick columns / fields or don't pick columns....
If you removed fields from a Data View how would that help if the field needs to be there sometimes and other times not? Not sure what you mean
But in short, can not fields from a data view
Perhaps you could create a filtered Alias and then create another data view
> **[Aliases API | Elasticsearch Guide \[8.11\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-aliases.html)**
---
### Author:  [@joerg55](https://discuss.elastic.co/u/joerg55)
#### Post date: [March 30, 2023, 2:53pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/5 "2023-03-30T14:53:38Z")
> [@stephenb](#):
>
> If you removed fields from a Data View how would that help if the field needs to be there sometimes and other times not? Not sure what you mean
So I could use differnt dataviews for different charts. But in the backgroung is always the same index.
> Perhaps you could create a filtered Alias and then create another data view
I think that is what I try to do. But how?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [March 30, 2023, 2:54pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/6 "2023-03-30T14:54:54Z")
> [@joerg55](#):
>
> So I could use differnt dataviews for different charts. But in the backgroung is always the same index.
Why Not the Same Data View with Different Columns?
What VIZ are you using... Not Kibana? Vega? D3? something else? Kibana Vizs are not Dynamic...
---
### Author:  [@joerg55](https://discuss.elastic.co/u/joerg55)
#### Post date: [March 30, 2023, 3:01pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/7 "2023-03-30T15:01:41Z")
I use elastic stack 8.6.2 and kibana lens charts.
the problem is that the the filter of the drilldown affects the entire data view of dashboard 2, even if I only take a few columns for a chart. . The filtered rows are missing...
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [March 30, 2023, 3:04pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/8 "2023-03-30T15:04:36Z")
> [@joerg55](#):
>
> the problem is that the the filter of the drilldown affects the entire data view of dashboard 2, even if I only take a few columns for a chart. . The filtered rows are missing...
I ~~think~~ hope Ignore Global Filter is coming soon...
I still don't see how a different data view will help... the data will still not exist... but I will just say OK. 🙂
---
### Author:  [@joerg55](https://discuss.elastic.co/u/joerg55)
#### Post date: [March 30, 2023, 3:10pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/9 "2023-03-30T15:10:12Z")
first of all, thank you very much for your help.
Let me try it once more again (sorry it's difficult for me, because my english is not the best)
So if I set 'courier:ignoreFilterIfFieldNotInIndex' and I had a second dataview where the filtered column is missing than my chart would be shown
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [March 30, 2023, 3:16pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/10 "2023-03-30T15:16:35Z")
No worries about the English... I only speak 1 language!
Here is the issue that would support your use case
>
>
> \*\*Describe the feature:\*\*
> Add something similar to TSVB's "ignore global filter…s" to Lens
>
> \*\*Describe a specific use case for the feature:\*\*
> \*\*When\*\* I am building a dashboard that's dynamic (user can input time / input controls)
> \*\*I need\*\* to configure certain reference or "fixture" visualizations to ignore filters
> \*\*So I can\*\* have increased flexibility and advanced behavior in my dashboards--choosing what is affected by cross-filtering
>
> Seen in https://discuss.elastic.co/t/apply-filter-for-individual-visualization-in-dashboard/284275
`'courier:ignoreFilterIfFieldNotInIndex'` I am not familiar with that / usage.
I think your best bet may be to try the filtered alias ... although I am not sure that will work or not.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 27, 2023, 3:17pm UTC](https://discuss.elastic.co/t/dataview-with-some-columns-excluded/328942/11 "2023-04-27T15:17:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.