# Cross tabulation Visualization between two categorical columns where both column are in different indexes

**URL:** <https://discuss.elastic.co/t/cross-tabulation-visualization-between-two-categorical-columns-where-both-column-are-in-different-indexes/219955>\
**Category:** Kibana\
**Created:** [February 19, 2020, 11:58am UTC](https://discuss.elastic.co/t/cross-tabulation-visualization-between-two-categorical-columns-where-both-column-are-in-different-indexes/219955 "2020-02-19T11:58:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sarvendras](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sarvendras/32/46287_2.png) [@sarvendras](https://discuss.elastic.co/u/sarvendras)\
**Post date:** [February 19, 2020, 11:58am UTC](https://discuss.elastic.co/t/cross-tabulation-visualization-between-two-categorical-columns-where-both-column-are-in-different-indexes/219955/1 "2020-02-19T11:58:02Z")

</div>

Hi All,  
Can we create cross tabultion visulaization(like stacked Vertical bar or stacked Pie Chart) between 2 categorical fields where both fields are in two different indexes having some common primary id.  
one index name is merchantindex and another name is merchantindexfraud ..when i created index pattern with wildcard pattern merchantindex\* and tried to create stacked bar/pie chart then its not working.When i am adding second field as split series then no stack chart is coming.  
Is there any alternate solution.

Thanks

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [February 19, 2020, 7:34pm UTC](https://discuss.elastic.co/t/cross-tabulation-visualization-between-two-categorical-columns-where-both-column-are-in-different-indexes/219955/2 "2020-02-19T19:34:38Z")

</div>

Can you provide a few example documents? What does the inspector show is being requested in your visualization?

---

<div class="post-metadata">

**Author:** ![sarvendras](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sarvendras/32/46287_2.png) [@sarvendras](https://discuss.elastic.co/u/sarvendras)\
**Post date:** [February 20, 2020, 5:13am UTC](https://discuss.elastic.co/t/cross-tabulation-visualization-between-two-categorical-columns-where-both-column-are-in-different-indexes/219955/3 "2020-02-20T05:13:17Z")

</div>

Thanks, @wylie for the reply.

for example below two indexes with below fields are there.here two categorical fields are model\_fraud and fraud and need to build cross tabulation(stacked bar charts,stacked piE) between these.

index1\> common field,name,city,model\_fraud  
index2\>common field,fraud

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [February 20, 2020, 2:41pm UTC](https://discuss.elastic.co/t/cross-tabulation-visualization-between-two-categorical-columns-where-both-column-are-in-different-indexes/219955/4 "2020-02-20T14:41:44Z")

</div>

Can you show example documents, not just the names of fields? Can you tell me what kind of query you are running?

---

<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:** [March 19, 2020, 2:41pm UTC](https://discuss.elastic.co/t/cross-tabulation-visualization-between-two-categorical-columns-where-both-column-are-in-different-indexes/219955/5 "2020-03-19T14:41:52Z")

</div>

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