# Can we change the view that currently seeing in discover section of kibana?

**URL:** https://discuss.elastic.co/t/can-we-change-the-view-that-currently-seeing-in-discover-section-of-kibana/185538
**Category:** Kibana
**Created:** [June 13, 2019, 5:09am UTC](https://discuss.elastic.co/t/can-we-change-the-view-that-currently-seeing-in-discover-section-of-kibana/185538 "2019-06-13T05:09:09Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![pyerunka](https://avatars.discourse-cdn.com/v4/letter/p/d6d6ee/32.png) [@pyerunka](https://discuss.elastic.co/u/pyerunka)
#### Post date: [June 13, 2019, 5:09am UTC](https://discuss.elastic.co/t/can-we-change-the-view-that-currently-seeing-in-discover-section-of-kibana/185538/1 "2019-06-13T05:09:09Z")

</div>

Hello,

I want my search results should display in below format:

 ![Example_search_results](https://us1.discourse-cdn.com/elastic/original/3X/0/9/09129c35e2fa560b17ba23646acf2e47d3009e9a.jpeg)  
From above image we can see that, I have searched drilling and I am getting matching results. And here all the data for one single submitted ticket is merged in one single result.

For example when we submit any ticket, entry goes to various database tables. I have indexed all that table using different sql queries. So when I search anything about submitted ticket it should give me single result. As data for that submitted ticket is not present in one table, currently I am getting more than one results for that submitted ticket. To avoid that, what I can do? Should I change my sql query or it can be handled in any other way? Kindly guide.

Thanks,  
Priyanka

---

<div class="post-metadata">

### Author: ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)
#### Post date: [June 27, 2019, 3:20pm UTC](https://discuss.elastic.co/t/can-we-change-the-view-that-currently-seeing-in-discover-section-of-kibana/185538/2 "2019-06-27T15:20:09Z")

</div>

Hi @pyerunka the Discover app in Kibana shows a list of matching documents indexed in elasticsearch for a specific index-pattern.  
If you index your `ticket` into multiple indices and your index-pattern cover all or some of them, likely more than one document will shows up.  
On discover there is no way to aggregate data coming from different indices based on a specific rule.  
Can you please describe a bit more the current index patterns used and shows some example of data? Also could you show us the discover page where you see multiple documents related to the same ticket?  
Thanks

---

<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: [July 25, 2019, 3:20pm UTC](https://discuss.elastic.co/t/can-we-change-the-view-that-currently-seeing-in-discover-section-of-kibana/185538/3 "2019-07-25T15:20:18Z")

</div>

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