# Use multiple indexes for calculation **URL:** \ **Category:** Kibana\ **Created:** [July 4, 2018, 8:27am UTC](https://discuss.elastic.co/t/use-multiple-indexes-for-calculation/138513 "2018-07-04T08:27:44Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![someOne](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/someone/32/32154_2.png) [@someOne](https://discuss.elastic.co/u/someOne)\ **Post date:** [July 4, 2018, 8:27am UTC](https://discuss.elastic.co/t/use-multiple-indexes-for-calculation/138513/1 "2018-07-04T08:27:44Z")
Hello, I'm a new one. I have two indices from csv files, one index contains all information of the other index that contains live data. for example : index 1 ID flied 1 1 40 2 80 .. .. 1000 200 index 2 ID flied 1 flied 2 50 1/1/2018 10 42 1/1/2018 15 110 1/2/2018 78 .. .. .. So I want to create a visualization that have y-axis as flied2/sum(flied1 of index1) and x-axis as date(flied1 of index2) on kibana. I use ELK version 6.2.4 Thanks for any help in advance. ---
**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:** [July 4, 2018, 4:15pm UTC](https://discuss.elastic.co/t/use-multiple-indexes-for-calculation/138513/2 "2018-07-04T16:15:33Z")
if the field names are unique between the 2 indices (for example you don't have a field1 in index1 and a field1 in index2) you could create an index pattern that covers both indices. ---
**Author:** ![someOne](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/someone/32/32154_2.png) [@someOne](https://discuss.elastic.co/u/someOne)\ **Post date:** [July 8, 2018, 3:31pm UTC](https://discuss.elastic.co/t/use-multiple-indexes-for-calculation/138513/3 "2018-07-08T15:31:58Z")
I created an index pattern that conver both indices (by ID). In index pattern management show all fields from both indices but it show fields from only index2 in discover (Time filter field in index2). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 5, 2018, 3:32pm UTC](https://discuss.elastic.co/t/use-multiple-indexes-for-calculation/138513/4 "2018-08-05T15:32:04Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.