# Change column name in saved query

**URL:** <https://discuss.elastic.co/t/change-column-name-in-saved-query/106489>\
**Category:** Kibana\
**Created:** [November 6, 2017, 8:59am UTC](https://discuss.elastic.co/t/change-column-name-in-saved-query/106489 "2017-11-06T08:59:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![yde](https://avatars.discourse-cdn.com/v4/letter/y/8e7dd6/32.png) [@yde](https://discuss.elastic.co/u/yde)\
**Post date:** [November 6, 2017, 8:59am UTC](https://discuss.elastic.co/t/change-column-name-in-saved-query/106489/1 "2017-11-06T08:59:42Z")

</div>

Hello,

I want to show in my dashboard a saved query (like the picture i pasted in this message).  
I have created this saved query in "discover"  
My question, is it possible to change the column name (in yellow) with a label I will choose.  
For exemple change event\_data.SubjectUserName to User.

I know it is possible when i create some visualize, but i don't know if it is possible in my case.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/a/6a82a375d26159d5e5365cbc5f3b67d84bed8bba.png)

Thank you for your response.

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [November 6, 2017, 11:37pm UTC](https://discuss.elastic.co/t/change-column-name-in-saved-query/106489/2 "2017-11-06T23:37:55Z")

</div>

hey @yde,

that isn't possible when you create a table from a saved search in Discover.

Maybe that's what you meant, but you can always recreate the saved-search with the Data Table visualization and then rename the column there.

Otherwise, I'd open a feature request here: [https://github.com/elastic/kibana/issues/new](https://github.com/elastic/kibana/issues/new)

thx!

---

<div class="post-metadata">

**Author:** ![yde](https://avatars.discourse-cdn.com/v4/letter/y/8e7dd6/32.png) [@yde](https://discuss.elastic.co/u/yde)\
**Post date:** [November 7, 2017, 8:46am UTC](https://discuss.elastic.co/t/change-column-name-in-saved-query/106489/3 "2017-11-07T08:46:04Z")

</div>

Hi thank you for your answer, this is what I wanted.

So is it possible to make a Data Table Visualization without aggregation (count) ?  
In my Data Table Idon't want any aggregation only show data.  
That is why I ask my question.

yves

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [November 7, 2017, 10:45pm UTC](https://discuss.elastic.co/t/change-column-name-in-saved-query/106489/4 "2017-11-07T22:45:04Z")

</div>

hi @yde, yes, you can do that in a DataTable visualization, if you have an id-field that uniquely identifies a document. Then, you can do a terms-aggregation on that field as your top-level bucket-aggregation. That gives you back a table, which each row corresponding to a single document.

You can then select other terms or values you want to see in your subbuckets and/or metrics.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 5, 2017, 10:45pm UTC](https://discuss.elastic.co/t/change-column-name-in-saved-query/106489/5 "2017-12-05T22:45:07Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.