# Kibana Architechture

**URL:** <https://discuss.elastic.co/t/kibana-architechture/164991>\
**Category:** Kibana\
**Created:** [January 21, 2019, 7:33am UTC](https://discuss.elastic.co/t/kibana-architechture/164991 "2019-01-21T07:33:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![suhasgupta](https://avatars.discourse-cdn.com/v4/letter/s/ecc23a/32.png) [@suhasgupta](https://discuss.elastic.co/u/suhasgupta)\
**Post date:** [January 21, 2019, 7:33am UTC](https://discuss.elastic.co/t/kibana-architechture/164991/1 "2019-01-21T07:33:02Z")

</div>

Hi All,

I am beginner started using kibana only from one month. I have 2 dataframes and number of records are approx 6,00,000(Increase on daily basis per day approx 20,000 records) in one and 1000 in another. I need columns from both dataframes in one Kibana dashboard.

Whether I should join both the dataframes and write one index for one dashboard or shall I write two dataframes in two different index and create one dashboard using two index.

PS: I am using pyspark in backend to do transformations and writing data to ES.

Thanks & Regards  
Suhas Gupta

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [January 21, 2019, 4:12pm UTC](https://discuss.elastic.co/t/kibana-architechture/164991/2 "2019-01-21T16:12:53Z")

</div>

It all depends on your data and how you want to query it. If you don't need to use data from both dataframes in one visualization, then I would suggest to use one index per dataframe and have a dashboard with visualizations from each index.

---

<div class="post-metadata">

**Author:** ![suhasgupta](https://avatars.discourse-cdn.com/v4/letter/s/ecc23a/32.png) [@suhasgupta](https://discuss.elastic.co/u/suhasgupta)\
**Post date:** [January 22, 2019, 5:44am UTC](https://discuss.elastic.co/t/kibana-architechture/164991/3 "2019-01-22T05:44:22Z")

</div>

Hi Marius,

Thank you for replying.

I want to use data from both dataframes but not in one visualization. I want to use data from both dataframes in one dashboard but in two different visualization.  
I want to ask why do you recommend keeping two different index for one dashboard ? I thought it will hamper performance of dashboard if we keep data in two different index rather than keeping in one index and creating two different visualization in one dashboard.

Thanks & Regards  
Suhas Gupta

---

<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:** [February 19, 2019, 5:44am UTC](https://discuss.elastic.co/t/kibana-architechture/164991/4 "2019-02-19T05:44:23Z")

</div>

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